Question: ONLY ANSWER QUESTION #3 THE REST IS FOR INFORMATION ONLY You are interested in predicting the final grade of students in a business course. You
ONLY ANSWER QUESTION #3 THE REST IS FOR INFORMATION ONLY

You are interested in predicting the final grade of students in a business course. You collect data on the number of hours studied and final grade for 8 students. Using the data provided below, find the predicted linear regression equation. Copy the data below into an excel spreadsheet, (or you can to this long hand on notebook paper). You must show all of your calculations. Take calculations out to the 4th decimal place. Do not round up or round down. Attach your work as an excel spreadsheet, (or jpg/pdf if longhand). Your answers must clearly show your answers for bo, b1, and the predicted linear regression equation. Note: to put a '' on the predicted value is a bit cumbersome in excel, Please spell out predicted..... in your answer submission. Data Definitions: Student - student identifying number Hours of study - number of hours studied Final Grade - based on 0-100 scale Student Hours Studying Final Grade 1 42 92 N 58 95 32 81 4 39 78 Student Hours Studying Final Grade 1 42 92 N 58 95 3 32 81 4 39 78 5 37 75 6 51 88 7 49 85 00 45 85 2 pts Refer back to Question #1, identify an additional explanatory variable that would be negatively related to final grade? Provide a justification as to why the explanatory variable would be negatively related to final grade
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
