Please See Link Below:

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

Please Help: 1. Boxplot ? How do I make one again on excel with these numbers? Also, Need assistance with questions a., c., d. and e.

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 records. The data file is on Blackboard.

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

a.(3 points) 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.(6 points) Find the means and the difference in means.

DataMean

Selling Price with Fireplaces:$270,552.32

Selling Price Without Fireplaces:$133,746.99

Difference:$136,805.33

c.(3 points) 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.(3 points) 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. (3 points) Identify other possible reasons for the difference in the mean selling prices?