Question

SELLING SQUARE AGE BEDROOMS PRICE FOOTAGE (YEARS) 84,000 1,670 79,000 1,339 91,500 1,712 120,000 1,840 127,500 2,300 132,500 2,234 145,000 2,311 164,000 2,377 155,000 2,736 168,000 2,500 172,500 2,500 174,000 2,479 175,000 2,400 177,500 184,000 2,500 195,500 4,062 195,000 2,854 w Aw Aw w Aw A w w w w w w NN a 3,124

Answer 1

Answer Date: 11/11/2019 1) The scattterplot of house price (v) on square footage (x) is, ଏ ତ ବି By using Excel software, draw scatterplot with the help of following steps: Import the data. Select the MegaStat from Add-Ins option. Select the Scatterplot from Regression. Select data input. 5) Select Plot linear regression line. Click Ok.

Scatterplot of Square footage and Price 210000 190000 170000 150000 130000 1100001 90000 70000 Price HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH 50000 Htttttttttttttttttttttttttttt 1000 1500 2000 2500 3000 3500 4000 4500 Square footage From the Excel output, a scattterplot of house price (v) on square footage (x) conclude there is a strong positive relationship between square footage and house price.