Set up an Excel worksheet to apply formulas (8.5) and (8.6) to compute the values of b₀ and b₁ for the data in the Excel file Home Market Value.

Everything needed for this question can be found below:

Formula 8.5:

Formula 8.6:

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

i-1 i-1 nXY n X2 i-1 i-1 nXY n X2