Solutions Statistics

Using the data in the Excel in the file Home Market Value, construct a scatter chart for market valu

Question: Using the data in the Excel in the file Home Market Value, construct a scatter chart for market value versus age and add a linear trendline. Compare the coefficient of determination with the model developed in this chapter. What do you conclude?

Home Market Value

House Age	Square Feet	Market Value
33	1,812	$90,000.00
32	1,914	$104,400.00
32	1,842	$93,300.00
33	1,812	$91,000.00
32	1,836	$101,900.00
33	2,028	$108,500.00
32	1,732	$87,600.00
33	1,850	$96,000.00
32	1,791	$89,200.00
33	1,666	$88,400.00
32	1,852	$100,800.00
32	1,620	$96,700.00
32	1,692	$87,500.00
32	2,372	$114,000.00
32	2,372	$113,200.00
33	1,666	$87,500.00
32	2,123	$116,100.00
32	1,620	$94,700.00
32	1,731	$86,400.00
32	1,666	$87,100.00
28	1,520	$83,400.00
27	1,484	$79,800.00
28	1,588	$81,500.00
28	1,598	$87,100.00
28	1,484	$82,600.00
28	1,484	$78,800.00
28	1,520	$87,600.00
27	1,701	$94,200.00
28	1,484	$82,000.00
28	1,468	$88,100.00
28	1,520	$88,100.00
27	1,520	$88,600.00
27	1,484	$76,600.00
28	1,520	$84,400.00
27	1,668	$90,900.00
28	1,588	$81,000.00
28	1,784	$91,300.00
27	1,484	$81,300.00
27	1,520	$100,700.00
28	1,520	$87,200.00
27	1,684	$96,700.00
27	1,581	$120,700.00