Need answer for question 17. Please show all work calculations! Thank you! Correlation and Simple Linear Regression V2 T

[answerhappygod]

Need answer for question 17. Please show all work
calculations! Thank you!
Correlation and Simple Linear Regression V2
The present study shows data for prices per gallon of paint and
the demand for each brand of paint. The sales manager at a home
improvement store is interested in knowing if there is a
significant relationship between the price a gallon of paint and
the demand (number of gallons sold). A sample of 28 different paint
brands is collected and analyzed. We will test the claim that there
is no relationship between the two variables. We will compare the
observed level of significance (p-value) with alpha and decide if
we can conclude that there is relationship between the two
variable.
3. In cell C4. find the covariance between the price and demand
for the sample on the Data sheet. 4.
4. In cell C5, find the correlation between the price and demand
for the sample on the Data sheet.
5. By assessing the values in cells C4 and C5, what can you say
about the relationship between the Price of the paint and Demand?
Choose your answer from the dropdown menu in cell Co.
6. Explain the answer you chose in cell C6. Choose your answer
from the dropdown menu in cell C7.
7. In cell C8, find the Y-Intercept (BO) of the Regression
Equation from the Data Analysis output table on the Data sheet.
8. In cell C9, find the Price (X variable) coefficient (B1) from
the Data Analysis output table on the Data sheet.
9. In cell C10, find the Coefficient of Determination (R2) from
the Data Analysis output table on the Data sheet.
10. In cell C11, find the Regression Sum of Squares (SSR) from
the Data Analysis output table on the Data sheet.
11. In cell C12, find the Error Sum of Squares (SSE) from the
Data Analysis output table on the Data sheet.
12. In cell C13, find the Total Sum of Squares (SST) from the
Data Analysis output table on the Data sheet.
13. In cell C14, find the value of Coefficient of Determination
(R2) using SSR and SST.
14. Explain what the value of R2 means. Choose your answer from
the dropdown menu in cell C15.
15. In cell C16, find the lowest price for which we can
predict demand.
16. In cell C17, find the highest price for which we can
predict demand.
17. In cell C18, predict the demand for a paint
that is priced at $50 per gallon.
Answers for above except 17:
From above excel op, we have:
Q3. Covariance = -3675.34
Q4. Correlation= -0.91499
Q.5 There is a strong negative relationship
Q.6 because the correlation coefficient is negative.
Q7. Bo= 950.867
Q.8 B1= -11.723
Q.9 R^2 = 0.837
Q.10 SSR = 1163337.936
Q.11 SS = 226214.17
Q. 12 SST = 1389552.107
Q.13 R^2 = SSR/SST = 0.8372
Q. 14 R^2 represents the percentage of variation in the
demand that is explained by the price
Q.15 lowest = 24.23
Q.16 highest = 95
Q.17 Demand = ?