Solution: Jamie Goodnews, the economic development director for Prescott Florida, is interested in finding out the relationship between the prices that houses
Question: Jamie Goodnews, the economic development director for Prescott Florida, is interested in finding out the relationship between the prices that houses are selling for Prescott and the total square footage of those houses.
Jamie does a random sample of 10 homes that have sold over the past year (out of the 250 that have sold) to see what the selling price was in comparison to the square footage of the house.
Sample Selling Price and Square Footage for homes in Prescott
|
House Price in $1000s
(Y) |
Square Feet
(X) |
| 245 | 1400 |
| 312 | 1600 |
| 279 | 1700 |
| 308 | 1875 |
| 199 | 1100 |
| 219 | 1550 |
| 405 | 2350 |
| 324 | 2450 |
| 319 | 1425 |
| 255 | 1700 |
• First use Microsoft Excel to create a scatter plot of this data to see what this visual tells you.
• Next create your null and research hypotheses about this study.
• Third, using POLYSTAT’s simple regression, compare this information and analyze it.
– Is there a relationship between selling price and square footage?
– If so, what is that relationship?
Deliverable: Word Document 