Using the photo below and this link of my spreadsheet please assist with Linear Regression. Question 1,2 (a-d) and 3 (a-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?

Please assist with the Inference question via photo above and accompanying link.

Specifically question 3

(a-e).

***PLEASE KEEP IN MIND AND OF NOTE--> This is (T-critical

Value that I am looking for. NOT the Z-Critical Value). ***

Link:

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

Source:

The data set consists of a

random sample of 1728 homes in

Saratoga County, NY taken

from public records.

Regression - living space as explanatory variable. 2. Perform linear regressions using living space as the independent/explanatory variable and selling pr as the dependent/response variable for houses with and without fireplaces, a. (2 points) What is the meaning of slope in these regressions? Explain in terms of the specific variables in your analysis. b. [6 points) Identify the slopes. Selling Price vs Living Area with Fireplaces: Selling Price vs Living Area Without Fireplaces: Slope Difference: c. (10 points) Use your regressions to complete the prediction table below to determine the selling prices of houses with and without fireplaces for the following square footages. House size [sq it) Price W/FP Price Wo FP Difference 10DO 1500 2000 2500 3000 (2 point) Explain why the slope difference by itself cannot be used to predict the difference in selling price. d. (3 points) Compare the differences between the answers in part (c) above and the answer to parts 1(b). Based on your comparison, what advice would you give to someone considering installing a fireplace. Use complete sentences and thoroughly explain your answer.Inference 3. It has been hypothesized that houses with fireplaces are larger than houses without fireplaces. Perform a hypothesis test at a = .05 to test the claim that houses WITH fireplaces have more square footage than houses WITHOUT fireplaces. a. (4 points) Write the hypotheses: Ho: Ha: b. (3 points) What is the value of your test statistic? c. (3 points) What is your P-value? d. (3 points) Test result (check correct response): REJECT THE NULL HYPOTHESIS FAIL TO REJECT THE NULL HYPOTHESIS e. (3 points) Write your conclusion about the hypothesis in complete sentences