Consider the data below. Use them to run a regression and answer questions in th
ID: 3244100 • Letter: C
Question
Consider the data below. Use them to run a regression and answer questions in this homework. The data are homework points for the homework right before a test and test points for a small economics class. Use the students' scores on the homework assignment to try to explain the scores on the test
Note: you can paste or type the data into excel and use excel to do the calculations for you or you can do it by hand.
1-Consider the data on homework points and test points that you used to run a regression for this homework. What is the estimated variance of the error term in the regression you ran? Answer to four decimal places.
2-Consider the data on homework points and test points that you used to run a regression for this homework. What is the F statistic for the test of the null hypothesis that slope of the regression line is 0? Answer to four decimal places.
3-Consider the data on homework points and test points that you used to run a regression for this homework. What is the F the test of the null hypothesis that slope of the regression line is 0 how many denominator degrees of freedom are there?
4-Consider the data on homework points and test points that you used to run a regression for this homework. What is the p-value the test of the null hypothesis that slope of the regression line is 0? Answer to four decimal places.
homework points test points 18.75 180.09 22.5 193.43 22.5 160.08 17.5 66.7 15 113.39 17.5 140.07 12.5 186.76 21.25 180.09 13.75 100.05 15 186.76 22.5 200.1 22.5 200.1 21.25 186.76 23.75 193.43Explanation / Answer
1] the estimated variance of the error term in the regression = 1440.8370.
2] What is the F statistic for the test of the null hypothesis that slope of the regression line is 0 = 4.0407.
3] F statistic denominator degrees of freedom = 1.
4] the p-value the test of the null hypothesis that slope of the regression line is 0 = 0.0674.
I am solved this problem in Excel, follows the following procedure:
I. Enter the data Homework points in first column of Excel sheet and in second column enter test points.
II. Chose data ==> Data Analysis
III Select Regression
Iv. Input Y range here Y variable is test point because it depends on homework points
V. Input X range it is independent variable.
VI. Output range select. then click ok.
OUTPUT
SUMMARY OUTPUT Regression Statistics Multiple R 0.50189748 R Square 0.25190108 Adjusted R Square 0.189559504 Standard Error 37.95836527 Observations 14 ANOVA df SS MS F Significance F Regression 1 5821.933627 5821.934 4.040659 0.067443783 Residual 12 17290.04992 1440.837 Total 13 23111.98355 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 57.59950742 53.60950587 1.074427 0.303761 -59.20557176 174.4045866 -59.20557176 174.4045866 homework points 5.564007122 2.767971109 2.010139 0.067444 -0.466883843 11.59489809 -0.466883843 11.59489809