Using the link below of my spreadsheet, please assist with descriptive Statistics. 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.

N Descriptive Statistics 1. Create side-by-side boxplots to compare selling price for houses with and without fireplaces, a. [ 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. h. (6 points) Find the means and the difference in means. Data Mean Selling Price with Fireplaces: Selling Price Without Fireplaces Difference: 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. Yes No. d. (3 points) if you were selling a house, would you pay to install a fireplace? Yes No I. If ma, explain why you would not install a fireplace, in Il yes, how much would you be willing to pay? Make sure to explain your choice. e. (3 points] Identify other possible reason for the difference in the mean selling prices