Question

1. 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

2. Using the predicted linear regression equation from #1, find the predicted final grade for a student who studied 40 hours.

3. You would expect the correlation coefficient to be:

Group of answer choices

positive

negative

zero

4. What is another explanatory variable that you could use to predict final grade? Why did you chose this variable? In other words, justify your decision.

Answer 1

1. The Excel sheet is:

The linear regression equation is:

y = 58.01 + 0.61*x

2. y = 82.36

3. positive

4. The IQ level of the person can be another explanatory variable that you could use to predict the final grade. This is because, the more the IQ is, the less the person has to study.