I DONT KNOW HOW TO ATTACH THE EXCEL SHEET PLEASE HELPPP!!!

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?

I DONT KNOW HOW TO ATTACH THE EXCEL SHEET PLEASE HELPPP!!!