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.

Computer Resource: Microsoft Excel.

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. Yes No

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?Yes No

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?

LINK BELOW:

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