Please explain me this problem without using Excel please. Thank you. Answer the
ID: 2909525 • Letter: P
Question
Please explain me this problem without using Excel please. Thank you.
Answer the following questions based on the above information and use a 95% confidence.
a. Is the regression model significant at 95% confidence? Why or why not. Fully explain.
b. Is X significant? Why or why not. Fully explain.
c. Compute the value of R-square.
d. Determine the multiple R.
e. Compute the standard error.
f. What has been the sample size for this problem?
df ss ms f significance f regression 1 552.0 552.0 69.0 0.0000 residual(error) 10 80.0 8.0 total 11 632.0Explanation / Answer
Answers
a. Is the regression model significant at 95% confidence? Why or why not. Fully explain.
F-statistic = 69.0
P-value = 0.0000
Since the p-value is less than 0.05, we reject the null hypothesis and conclude that the regression model is significant.
b. Is X significant? Why or why not. Fully explain.
t-statistic = 8.2315
P-value = 0.0000
Since the p-value is less than 0.05, we reject the null hypothesis and conclude that X is significant.
c. Compute the value of R-square.
R-square = SSR/SST = 552.0/632.0 = 0.8734
d. Determine the multiple R.
Multiple R = SQRT (0.8734) = 0.9346
e. Compute the standard error.
Standard error = SQRT (MSE) = SQRT (8.0) = 2.8284
f. What has been the sample size for this problem?
Sample size = Total df + 1 = 11 + 1 = 12