This data gives the square footage and sales prices for severalhouses and sales prices for several houses in Dallas, Texas.
| |
| Square Footage | Value |
| 2000 | 238139.4 |
| 2200 | 259712 |
| 2400 | 300953.7 |
| 3000 | 369965.7 |
| 3200 | 340091.3 |
| 3600 | 405425 |
| 2900 | 345131 |
- You plan to build a 500-sqaure-foot addition to your house. Howmuch do you think your home value will increase as a result?
- What percentage of the variation in home value is explained bythe variation in the house size?
Please set up using an excel worksheet and show anyformulas used.
