The Excel file – “Real Estate – 2241.xlsx” – includes a rubric and the data you need to complete all steps in the assignment
Question Description
|
A. |
Create the Descriptive Statistics for “Price” and “SQFT” – Include a 95% Confidence Test on the Population Mean |
||
|
B. |
Produce a Scatterplot for Price (Dependent) and SQFT (Independent) (PLACE BELOW) |
||
|
C. |
Conduct a 95% Hypothesis Test (i.e., α = .05) to determine if the Mean Price of Houses is greater than $242,512. Use a |
||
|
Population Standard Deviation of $172,000 for your Z-test (i.e., we are determing if the mean has increased from the previous year). |
|||
