Question: Please help me solve it. and explain it to me. Thank you a lot D Question 1 5 pts You are interested in predicting the
Please help me solve it. and explain it to me. Thank you a lot


D Question 1 5 pts 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 2 58 95 3 32 81 4 39 78 5 37 75 6 51 88 7 49 85 8 45 85 Upload Choose a FileD Question 2 1 pts For the data in Question #1, you would expect the correlation coefficient to be: O positive O negative zero D Question 3 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. Edit View Insert Format Tools Table 12pty Paragraph ~ | B I U A Q V TYPE BY BYB O S EVS IBSQ D 1 0 words >
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
