The statistics department is interested in the different factorsthat might influence a student’s score on the final exam. Theyidentify three factors to test: the student’s midterm exam score,the number of hours the student reports having studied for thefinal exam, and the average number of drinks of alcohol the studentreports having on a night out. They collect data on all of thesefactors and want to estimate the following model:
FinalExamScore=β0+β1 MidtermExamScore +β2HourStudied+β3AverageAlcohol +ε
Variable Descriptions:
Final Exam Score: A student’s final exam score,measured in % on scale from 0 – 100
Midterm Exam Score: A student’s midterm exam score, measured in% on scale from 0 – 100
Hour Studied: The number of hours the student reports studyingfor the final exam
Average Alcohol: The average number of alcoholic drinks thestudent reports having on a typical night out.
For this question, you will need to download the StudentGrade Data and then use the data analysis tool pack in Excel to runa regression. Note, you will need to install the data analysis toolpack on your computer. How to do this differs based on the type ofcomputer you are using, but instructions can be found on google forboth Mac and PC.
https://arizona.grtep.com/core/uploadfiles/components/282918/files/Student%20Grade%20Data.xlsx(Student Grade Data)
Estimate the sample regression equation above and fill in theestimated coefficients. Round the coefficient estimates to4 decimals.
FinalExamˆScore=_______+_______MidtermExamScore+_____HourStudied−______AverageAlcohol
Predict a student’s final exam score who scored a 79% on themidterm, studied for 15 hours, and who only drinks 2 drinks on anaverage night out. Round your answer to 2decimals. Hint, be sure to use your coefficients thatwere rounded to 4 decimal points.
