components that are out of specification among the three methods. After conducting the analysis, report the findings to the management team.
Due to a recent change by Microsoft, you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak
Open spreadsheet
a. Compute the sum of squares between treatments (assembly methods).
b. Compute the mean square between treatments (to 1 decimal if necessary).
c. Compute the sum of squares due to error.
d. Compute the mean square due to error (to 1 decimal if necessary).
f. At the α = 0.01 level of significance, test whether the means for the three methods are equal.
Calculate the value of the test statistic (to 2 decimals).
The p-value is (to 4 decimals):
A manufacturing company has been selected to assemble a small but important component that will be used during the construction of numerous infrastructure projects. The company anticipates the need to assemble several million units over the next several years. Company engineers elect three potential assembly methods: Method A, Method B, and Method C. Management would like to select the method that produces the fewest number of parts per 10,000 parts produced that do not meet specifications. It may also be possible that there is no statistical difference between the three methods, in which case the lowest cost method will be selected for production. While all parts are checked before leaving the factory, the best method will reduce the number of parts that need to be recycled back into the production process.
To test each method, six batches of 10,000 components are produced using each of the three methods. The number of components out of specification are recorded in the Microsoft Excel Online file below. Analyze the data to determine if there is any difference in the mean number of components that are out of specification among the three methods. After conducting the analysis, report the findings to the management team.
Due to a recent change by Microsoft, you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak. Open spreadsheet.
a. Compute the mean square between treatments (to 1 decimal if necessary).
ANOVA Completely Randomized Design Method A Method B 163 146 142 157 168 125 145 146 149 137 6 187 147
c. Compute the sum of squares due to error.
Batch
Method C 123 122 133 144 154 128
d. Compute the necessary? Set up the ANOVA table for this problem. Round all sum of squares to the nearest whole number. Round all Mean Squares to
Source of Variation Sum of Squares Degrees of Freedom Mean Square Treatments (Methods) Error Total
f. At the α = 0.01 level of significance, test whether the means for the three methods are equal.
Calculate the value of the test statistic (to 2 decimals).
The p-value is (to 4 decimals):
