Square Feet	Price
1550	$329,744
1614	$259,000
1715	$295,100
1758	$309,500
1794	$282,900
1860	$296,950
1877	$219,000
1900	$349,900
1911	$374,900
1921	$314,360
1921	$314,360
2015	$369,900
2118	$395,342
2351	$321,900
1800	$209,900
2083	$275,000
2100	$309,900
2112	$317,750
2112	$317,750
2210	$279,699
2260	$295,500
2400	$239,900
2416	$374,900
2444	$331,900
2600	$369,900
3159	$463,055
3200	$479,000
3200	$470,000
2580	$389,900
3300	$559,000

Using excel for the scatter plot of price vs. square feet for the sample data. Plot square feet on the x-axis and price on the yaxis.

2. Based on the scatter plot, describe the relationship (if any) between square feet and price.

3. Use EXCEL to calculate the correlation coefficient and explain what it tells you about the relationship between square feet and price.

4. Use EXCEL to calculate the least-squares regression line (trend line) for the data. Write the equation.

5. Interpret the slope of the least-squares regression line. Specifically what does it tell you about the relationship between square feet and price?

6. Use the equation of the least-squares regression line from #4 to estimate how much you should charge for your home (which has 2,235 square feet). How does it compare with the price recommended by the real estate agent?

I need all parts answered! except the graphs

thank you!