Question

Instructions for Non-Excel Assignment 6 Using the tables produced by 'Regression': a) shade the cell containing the proportion of the total variation in Y explained by the model in orange b) shade the cell containing the best estimate of the effect that x has on y in yellow c) shade the cell containing the best estimate of the y-intercept in blue d) shade the cell containing the test statistic for testing whether there is a negative linear relationship between y and x in green e) shade the cell containing the p-value for testing whether there is a linear relationship between Y and X in purple f) change the font colour for the value of SE(b) to blue g) change the font colour for the value of SSM to green h) change the font colour for the value of the total variation in y to red i) shade the cells containing the lower and upper limits of the confidence interval for Bi to grey change the font colour for the value of se to orange j) Notes: 1) Do not shade the cells in such dark colours making reading the values in the cells difficult! 2) Bold the font colours that were changed making it easier to read the values.

Answer 1

used Excel and solve: we have given : y =dependent variable and x = independent variable We have to fit simple linear regression : DATA > Data Analysis > Regression> choose y input as y and x input as x variable ranges. SUMMARY OUTPUT ANOVA df SS F gnificance F 17.5979 0.003017 Regression Statistics Multiple R 0.829140727 R Square 0.687474345 Adjusted R Square 0.648408638 Standard Error 8.98779285 Observations 10 Regressio Residual Total MS 1 1421.566 1421.566 8 646.2434 80.78042 9 2067.809 Intercept Coefficients Standard Error t Stat P-value Lower 95%Upper 95%ower 95.09pper 95.0% 55.7046032 6.925830133 8.043022 4.2E-05 39.73361 71.6756 39.73361 71.6756 -1.53147995 0.365074007 -4.19498 0.003017 -2.37334 -0.68962 -2.37334 -0.68962 х