Using the link below of my spreadsheet, please assist with Linear Regression. Question 1 (a-e). PLEASE SHOW ALL WORK. Thanks!

Link:

https://docs.google.com/spreadsheets/d/e/2PACX-1vTf6uQyLx1-vkV0d6A8y2m7BABk8IHPAOYE5cjY4bTuSy1e8fbyAsW1S5sSe_AI9g/pub?output=xlsx

Nearly 60% of the houses in

Saratoga County New York have fireplaces. On average, those houses sell for

about $65,000 more than houses without fireplaces. The goal is to answer the

question: Is

the fireplace the reason for the difference?

Resource:

The data set consists of a

random sample of 1728 homes in Saratoga County, NY taken from public

1.Create side-by-side boxplots to compare selling price for houses with and without fireplaces.

a.Do the boxplots indicate that houses with fireplaces sell for a higher price? Explain what boxplot features you used to support your answer choice.YesNo

b. Find the means and the difference in means.

DataMean

Selling Price with Fireplaces: ___________

Selling Price Without Fireplaces:___________

Difference: ___________

c.Can you conclude that the presence of a fireplace adds to the difference found in part (b) to the selling price of a house? Explain your reasoning.YesNo

d. If you were selling a house, would you pay to install a fireplace?YesNo

i.If no, explain why you would not install a fireplace.

ii.If yes, how much would you be willing to pay? Make sure to explain your choice.

iii.

e. Identify other possible reasons for the difference in the mean selling prices?