Question: PROBLEM 3: (15 Marks) Students in a management science class have just received their grades on the midterm exam. The instructor has provided information about

PROBLEM 3: (15 Marks) Students in a management science class have just received their grades on the midterm exam. The instructor has provided information about the midterm exam grades in some previous classes and the final average for the same students. See the Excel file Student Grade on Brightspace for the data. Develop a regression model and answer the following questions. Your answer must show how you arrived at a conclusion wherever possible. For example, use a formula instead of a number, as the formula clearly shows the process.

a) Using MS Excel, develop a regression model that could predict the final average in the course based on the midterm exam grade. Clearly state the regression equation. (2 Marks)

b) Predict a student's final average who scored 98 on the midterm exam? (1 Mark)

c) Give the values of r and r 2 for this model. Then, interpret the value of r 2 in the context of this problem. (4 Marks)

d) Do you believe this model is useful (at alpha 0.05) in predicting the final average? Justify your answer using the information provided in the computer output. (2 Marks)

e) Calculate the residual for each data using the TREND function. (2 Marks)

f) What would be the 95% final average interval for a student with 78 in the midterm exam? (2 Marks) g) How much the midterm exam result must be if the predicted final average of a student is 98? (2 Marks)

(Please include formulas)

This is not a midterm exam. Its a data file about midterm exam grades

Question: PROBLEM 3: (15 Marks) Students in a management science class have just received their grades on the midterm exam. The instructor has provided information about

Step by Step Solution

Students Have Also Explored These Related Mathematics Questions!