Question: Solve the problem without using EXCEL WORSHEET. The detailed calculation must appear in your ANSWER SHEETS. You can use the calculator. Limit your calculation
Solve the problem without using EXCEL WORSHEET. The detailed calculation must appear in your ANSWER SHEETS. You can use the calculator. Limit your calculation within 3 dismal points Take the printout of your assignment and attach it while submitting. The table given below shows the performance of students (scores) in econometrics and absenteeism (number of classes they were ahsent). Absenteeism Score in ECON 441 2 76 10 15 60 90 55 84 85 (1) Write down the econometric model. (2) Estimate the lincar regression model and interpret the coefficients (3) Calculate R-Square and interpret its value (4) Examine the relationship between absentecism and score in cconometrics based on correlation coefficient. (5) Ifa student has missed total 12 classes, what is the expected marks of the student in econometries? (6) Test if the slope coefficient is significant. The data was further collected on score of the above 6 students on prerequisite course- Business Statistics (BS) to show how performance in econometrics is affected by both - Absenteeism and Score in Prerequisite course. The multiple linear regression model was run using EXCEL Analysis Tool pack. The partial results are reported in Table below. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square ?? ?? ?? Standard Error 5.734 Observations ?? ANOVA df MS Regression ?? 466.680 Residual ?? ?? Total ?? Coefficients Standard Error 67.634 I Stot 0.657 Intercept 44.463 X Variable 1 X Variable 2 -1892 1.092 -1.732 0.584 0.809 0.722 (a) Do necessary calculations to fill the missing numbers (??) Show all your calculations.
Step by Step Solution
3.49 Rating (152 Votes )
There are 3 Steps involved in it
Let x Absenteeism nd y Score in ECON 441 All Calculations are shown below x y x2 y2 xy 10 60 100 3600 600 1 90 1 8100 90 15 55 225 3025 825 6 84 36 70... View full answer
Get step-by-step solutions from verified subject matter experts
