Statistics Case Study Assignment

Ann Perkins, a realtor in Brownsburg, Indiana, would like to use estimates from a multiple
regression model to help prospective sellers determine a reasonable asking price for their homes.
She believes that the following four factors influence the asking price (Price) of a house:
1) The square footage of the house (SQFT)
2) The number of bedrooms (Bed)
3) The number of bathrooms (Bath)
4) The lot size (LTSZ) in acres
She randomly collects online listings for 50 single-family homes. The data file is in the
Blackboard “Case Study Indiana Real Estate Data File Excel” within the Case Study folder.
Requirements and associated point values:
Part 1 – Provide summary statistics (with Excel Data Analysis) by calculating the mean and
standard deviation on the asking price, square footage, the number of bedrooms, the number
of bathrooms, and the lot size. Explain each factor’s mean and standard deviation. What does
each of these summary statistics tell us.
A total of ten calculations 4 points each for a total of 40 points.
Part 2 – Estimate and interpret a multiple regression model where the asking price is the
response variable and the other four factors are the explanatory variables.
The end result should be a Excel Regression Output

Also provide the estimate model equation: Price =
A total of 40 points will be assigned to Part 2.
Part 3 – Interpret the resulting coefficient of determination.
A total of 20 points will be assigned to Part 3.
Part 4 – Write your findings in thorough, concise, and well-written report form. For an example
review and refer to other reports throughout your textbook. There is at least one at the end of
each chapter. Please note you are expected to use proper statistical terminology when
appropriate but remember you are writing for a group who may not be as knowledgeable about
statistics as you are. You must be sure they can understand your findings while also writing a
professional report.
A total of 50 points will be assigned to Part 4.
Part 5 – Prepare your report in a PowerPoint Presentation and record your presentation within
Relay according to the instructions provided in the Blackboard “PowerPoint Presentation Case
Study Information” located within the Case Study folder.
A total of 50 points will be assigned to Part 5.
The submission link to attach your Case Study Report, PowerPoint Presentation and Excel Data
Output Worksheet is in the same Case Study folder. You will record your PowerPoint
Presentation under “Student Recordings” within Knowmia (formerly Relay). Refer to the course
schedule for the Case Study due date. The case study is valued at a total of 200 points.

Statistics assignment M2

Students will use SPSS to enter raw data contained in four documents. The name of the document shows you the participant ID number and their responses are circled within the word document. First, create a data file in SPSS. Then, enter the data. Create your own variable names and using the variable view, fill in the label and value boxes for each variable. Finally, upload your .sav (SPSS) datafile to the assignment link.

After you enter your data, make a chart depicting the data. You maye choose any variables you wish. Save and submit the SPSS outut file (a .spv file) to the same assignment link.

Module 2 Discussion
Discussion Board

• Complete Task 8 on page 133. Take a screenshot of your variable view and your data editor. Then, embed these screenshots into your discussion board post. Discuss any problems you had entering the data or any questions you might have regarding this week's readings.

Students will post twice each week during each of the modules, with an initial post on Wednesday.

A radio station claims that the amount of advertising per hour of broadcast time has an average of 14
minutes and a standard deviation equal to 1.6 minutes. You listen to the radio station for 1​ hour, at a randomly selected​ time, and carefully observe that the amount of advertising time is equal to 16 minutes. Calculate the​ z-score for this amount of advertising time. Round your answer to two decimal places as needed.

How to solve the statistics Question

Graded Discussion: Solve Normal Distribution Application

For this graded discussion, you will be given a scenario to analyze using a cumulative from the mean z-table.
Requirements:

A minimum of two posts is required.
You must give a detailed solution for each part in your first post to get full credit.
It is not enough to just give the final answer. You must show steps or explain your reasoning.
If it is easier, you can write your solution out on paper, take a picture, and upload it to the discussion as a PDF file. The PDF file type is the only file type that will be accepted.
You will be able to see other students' posts once you post your own solution.
Review their responses to determine if they agree with your own.
For your second post, reply to a classmate to indicate if your answers are the same or different from theirs.
If they are different, explain which post you think is correct, yours or theirs.
If your original post was incorrect, reply to yourself with a correction. Don't worry! You will not lose points for an incorrect answer, as long as you make a reasonable effort at the first post and post a reply with the correct answer.
Complete required posts by the posted deadline.

Part 1: Prepare
Familiarize yourself with the following data.
In 1955, scientists R.R. Sokal and P.E. Hunter analyzed the affects of pesticides on houseflies. Among the data sets they collected were samples of housefly wing lengths. These are normally distributed. The data they collected is summarized in the following frequency distribution.

Normally Distributed

*Source: Sokal, R.R. and F.J. Rohlf, 1968. Biometry, Freeman Publishing Co., p 109. Original data from Sokal, R.R. and P.E. Hunter. 1955. A morphometric analysis of DDT-resistant and non-resistant housefly strains Ann. Entomol. Soc. Amer. 48: 499-507.
Part 2: First Post*

Answer these questions:

Find the mean and standard deviation of the sample of housefly wing lengths. (2 points)
List the data values that are within 2 standard deviations of the mean. Justify your answer. (2 points)
What percentage of the data values are within 2 standard deviations of the mean? (2 points)
Is this consistent with the Empirical Rule? Explain. (2 points)

Part 3: Second Post
For your second post, reply to a classmate to indicate if your answers are the same or different from theirs. If they are different, explain which post you think is correct, yours or theirs. (2 points)
If your original post was incorrect, reply to yourself with a correction. Don't worry! You will not lose points for an incorrect answer as long as you make a reasonable effort at the first post and post a reply with the correct answer.

Note that My Course Tutor can help you write this discussion posts under our statistics assignment help services. We have writing experts who are qualified to handle mathematics and statistics courses at all academic learning levels.

Deliverable 7 - Statistical Analysis Report item options Assignment Content

Competencies

Describe the data using the measures of central tendency and measures of variability.
Apply the normal distribution, standard normal distribution, and central limit theorem.
Develop a confidence interval for a population parameter.
Evaluate hypothesis tests for population parameters from one population.
Evaluate hypothesis tests for population parameters from two populations.
Determine the linear correlation and regression equation between two variables to make predictions for the dependent variable.

Student Success Criteria
View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.

Instructions
You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past few days, you have noticed an increase in patients admitted with a particular infectious disease. You believe that the ages of these patients play a critical role in the method used to treat the patients. You decide to speak to your manager, and together you work to use statistical analysis to look more closely at the ages of these patients.

You do some research and put together a spreadsheet of the data that contains the following information
Client number
Infection disease status
Age of the patient

Deliverable 7 - Statistical Analysis Report.xlsx

You are to put together a PowerPoint presentation that explains the analysis of your findings which you will submit to your manager. The presentation should contain all components of your findings. For review, the components of the report should include:

Brief overview of the scenario and variables in the data set
Discussion, calculation, and interpretation of the mean, median, mode, range, standard deviation, and variance
Discussion, construction, and interpretation of the 95% confidence interval
Explanation of the full hypothesis test
Conclusion

The calculations should be performed in your spreadsheet that you will also submit to your manager. You can find additional information on what to add to your PowerPoint presentation in this Word document.

Deliverable 7 - PowerPoint Instructions.docx

Use the questions in the Word document as your guide for the contents of your presentation.

For your final deliverable, submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document.