Use the following data to relate defective units of a drug to active milligrams and degrees of temperature with multiple regression.
Milligrams 3 2 5 4 6
Defects 8 7 9 10 11
Grades F 84 87 83 90 93
using excel>data>data analysis>Regression
we have
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.961719 | |||||
R Square | 0.924904 | |||||
Adjusted R Square | 0.849807 | |||||
Standard Error | 0.612766 | |||||
Observations | 5 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 2 | 9.249037 | 4.624518 | 12.31623 | 0.075096 | |
Residual | 2 | 0.750963 | 0.375482 | |||
Total | 4 | 10 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | -6.37408 | 6.780632 | -0.94004 | 0.446428 | -35.5488 | 22.80062 |
Milligrams | 0.743958 | 0.213319 | 3.487539 | 0.073293 | -0.17388 | 1.661795 |
Grades | 0.141856 | 0.081092 | 1.749334 | 0.222339 | -0.20705 | 0.490766 |
the regression equation is
Defects = -6.374 +0.744*milligrams +0.142*Grades
Get Answers For Free
Most questions answered within 1 hours.