. A manufacturing process is suspected to be affected by the level of humidity.
ID: 3791234 • Letter: #
Question
. A manufacturing process is suspected to be affected by the level of humidity. Humidity and scrap data was taken on several days. Use the least squares regression method to determine a prediction equation for the data. Determine the equation first by using matrix calculations in Excel and then using the Excel regression data analysis tool. What is the r squared value? The company would like to know what would happen to the scrap level if the level of humidity level reaches 0.70 (70%). Is the model a good indicator of the effects of humidity on scrap?
Humidity % Scrap %
0 0
13 4
24 11
32 15
41 18
57 22
Please post the answer in Excel format
Explanation / Answer
Hi
In Excel , create the data as above and create the equation and install data anlysis plugin .
Go to the Data tab and check for data analysis .open data analysis
Give the X and Y value and specify threshold if you want .
Then click ok .
The above
result is obtained when I made the confidence level to 70% .
SUMMARY OUTPUT Regression Statistics Multiple R 0.986392 R Square 0.972969 Adjusted R Square 0.966211 Standard Error 1.545241 Observations 6 ANOVA df SS MS F Significance F Regression 1 343.7823 343.7823 143.9763 0.000277 Residual 4 9.551077 2.387769 Total 5 353.3333 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 70.0% Upper 70.0% Intercept 0.270947 1.140146 0.237642 0.823835 -2.89461 3.436499 -1.08533 1.627226 X Variable 1 0.409427 0.034122 11.99901 0.000277 0.31469 0.504164 0.368837 0.450017The above
result is obtained when I made the confidence level to 70% .
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.