WILL MARK BRAINLIEST- 30 POINTS
The table shows the test scores and the sleep averages of several students.
Hours of Sleep Test Score
5 60
8.5 92
5.25 62
6 64
6.75 70
7 72
7.5 78
9 93
9.25 90
5.5 71
8 93
8.25 94
a. Write the LINEAR least squares regression equation that models the data, rounding all values to the nearest tenth. You should be using Excel to find this equation. You must provide your Excel sheet to receive credit for this problem.
Let x = average sleep and y = test score
b. Use the equation to determine the approximate hours of sleep of a student who received a 84%. Round to the nearest tenth.
Show your work.