JUST ANSWER QUESTION #2 QUESTION ONE IS ONLY LISTED FOR INFORMATION

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 3 32 81 4 39 78 Student Hours Studying Final Grade 1 42 92 2. 58 95 3 32 81 4 39 78 5 37 75 6 51 88 7 49 85 8 45 85 For the data in Question #1, you would expect the correlation coefficient to be: positive negative zero