Brightness Level (X) | Hours (y) |
16 | 6.6 |
28 | 5.1 |
31 | 5.2 |
43 | 6 |
49 | 4.5 |
73 | 5 |
86 | 0.1 |
88 | 2.3 |
Steps:
Enter data > insert > scatterplot > add trendline and equation > ok
steps:
Enter data > Data > analyse > data analysis > regression > input x and y range > ok
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.820997151 | |||||
R Square | 0.674036322 | It explains 67.4 % variability in y | ||||
Adjusted R Square | 0.619709043 | |||||
Standard Error | 1.31397144 | |||||
Observations | 8 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 1 | 21.42087433 | 21.42087433 | 12.40695885 | 0.012482904 | significant at 0.05 |
Residual | 6 | 10.35912567 | 1.726520945 | |||
Total | 7 | 31.78 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 7.641360589 | 1.043531764 | 7.32259511 | 0.000331308 | 5.08793035 | 10.19479083 |
Brightness Level (X) | -0.063601171 | 0.018056453 | -3.522351324 | 0.012482904 | -0.107783719 | -0.019418622 |
Equation:
Hours = 7.6414 -0.0636 Brightness Level
Now, interpretation of slope:
For a 100% increase in Brightness Level, the hours decrease by 6.36%
For a brightness = 73
Hours = 7.6414 - 0.06363 * 73 = 2.99641 or 3 hours
Error / residual:
Actual value at x = 73, y = 5 hours
Predicted value at x = 73 ,
Error =
= 3 - 5 = -2 hours
Note: sign of the residual doesnot matter because the mean is always 0.
Please rate my answer and comment for doubt.
Cameron is investigating how long his phone's battery lasts (in hours) for various brightness levels (on...
Warren is investigating how long his phone's battery lasts (in hours) for various brightness levels (on a scale of 0-100). His data is displayed in the table and graph below. Brightness Level (x) 35 57 62 70 77 83 88 91 Hours (y) 6.1 3.7 4.8 1.8 2.9 3.2 2.6 1.6 brightness level 10 20 30 40 50 60 70 80 90 100 110 Hours 1 2 3 4 5 6 7 8 9 Brightness Level Hours a) Find the...