A manufacturing company has been selected to assemble a small but important component that will be...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 components over the next several years. Company engineers select three potential assembly methods: Method A, Method B, and Method C. Management would like to select the method that produces the fewest number 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 specificaion among the three methods. After conducting the analysis report the findings to the management team. ANOVA Completely Randomized Design Batch Method A Method B Method C 1 164 142 125 23456 2 141 157 121 167 124 139 144 142 141 149 139 151 171 154 127 Sample Size Sum 6 936 Sample Mean 156 Sample Variance 165.6 Sample Standard Deviation 12.86856635 Grand Mean 144.3333333 Group Count 3 Observation Count 18 a. Compute the sum of squares between treatments (assembly methods). 817.7 b. Compute the mean square between treatments (to 1 decimal if necessary). 408.3 c. Compute the sum of squares due to error. 828 d. Compute the mean square due to error (to 1 decimal if necessary). 55.2 Source of Variation Treatments (Methods) Error Total Sum of Squares 816.6667 828 1644.6667 df 2 15 17 Level of significance 0.01 Reject null? Yes Are the means equal? No Mean Square F p-value 408.333 7.3973 0.0058 55.200 e. Set up the ANOVA table for this problem. Round all sum of squares to the nearest whole number. Round all Mean Squares to one decimal place. Round F to two decimal places. Source of Variation Treatments (Methods) Error Total Sum of Squares Degrees of Freedom Mean Square F 817 X 2 828 X 15 1645 17 108.3 X 55.2 X 7.40 X 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). 7.40 X The p-value is (to 4 decimals): 0.0058 What is your conclusion for management? [ Conclude that all method means are equal. Sample Size Sum Sample Mean Sample Variance Sample Standard Deviation Grand Mean Group Count Formulas =COUNT(B3:B8) =SUM(B3:B8) |=AVERAGE(B3:B8) =VAR.S(B3:B8) =STDEV.S(B3:B8) =AVERAGE(B3:D8) =COUNT(B3:D3) Observation Count =COUNT(B3:D8) Source of Variation Treatments Error Total Level of significance #N/A # N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Sum of Squares =B10*(B12-B16)^2+C10(C12-B16)^2+D10*(D12-B16)=B17-1 =(B10-1)*B13+(C10-1)*C13+(D10-1)*D13 =SUM(B21:B22) -B18-B17 0.01 df Mean Square F =B21/C21 =D21/D22 =B22/C22 p-value =F.DIST.RT(E21,C21,C22) Level of significance Reject null? Are the means equal? |=IF(F21 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 components over the next several years. Company engineers select three potential assembly methods: Method A, Method B, and Method C. Management would like to select the method that produces the fewest number 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 specificaion among the three methods. After conducting the analysis report the findings to the management team. ANOVA Completely Randomized Design Batch Method A Method B Method C 1 164 142 125 23456 2 141 157 121 167 124 139 144 142 141 149 139 151 171 154 127 Sample Size Sum 6 936 Sample Mean 156 Sample Variance 165.6 Sample Standard Deviation 12.86856635 Grand Mean 144.3333333 Group Count 3 Observation Count 18 a. Compute the sum of squares between treatments (assembly methods). 817.7 b. Compute the mean square between treatments (to 1 decimal if necessary). 408.3 c. Compute the sum of squares due to error. 828 d. Compute the mean square due to error (to 1 decimal if necessary). 55.2 Source of Variation Treatments (Methods) Error Total Sum of Squares 816.6667 828 1644.6667 df 2 15 17 Level of significance 0.01 Reject null? Yes Are the means equal? No Mean Square F p-value 408.333 7.3973 0.0058 55.200 e. Set up the ANOVA table for this problem. Round all sum of squares to the nearest whole number. Round all Mean Squares to one decimal place. Round F to two decimal places. Source of Variation Treatments (Methods) Error Total Sum of Squares Degrees of Freedom Mean Square F 817 X 2 828 X 15 1645 17 108.3 X 55.2 X 7.40 X 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). 7.40 X The p-value is (to 4 decimals): 0.0058 What is your conclusion for management? [ Conclude that all method means are equal. Sample Size Sum Sample Mean Sample Variance Sample Standard Deviation Grand Mean Group Count Formulas =COUNT(B3:B8) =SUM(B3:B8) |=AVERAGE(B3:B8) =VAR.S(B3:B8) =STDEV.S(B3:B8) =AVERAGE(B3:D8) =COUNT(B3:D3) Observation Count =COUNT(B3:D8) Source of Variation Treatments Error Total Level of significance #N/A # N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Sum of Squares =B10*(B12-B16)^2+C10(C12-B16)^2+D10*(D12-B16)=B17-1 =(B10-1)*B13+(C10-1)*C13+(D10-1)*D13 =SUM(B21:B22) -B18-B17 0.01 df Mean Square F =B21/C21 =D21/D22 =B22/C22 p-value =F.DIST.RT(E21,C21,C22) Level of significance Reject null? Are the means equal? |=IF(F21
Expert Answer:
Posted Date:
Students also viewed these mathematics questions
-
Graduate School of Business Examinations SECTION A: COMPULSORY (ANSWER BOTH QUESTIONS) QUESTION ONE BIL Plc is considering an investment in an ice cream making machine costing K1.5million with a life...
-
Image transcription text Module 5 Discussion A' Instructions: This discussion will be completed in two parts, and will give you an opportunity to reect upon this week's content and to interact with...
-
Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...
-
A website that reviews recent movies lists 6 five-star films (the highest rating), 17 four-star films, 14 three-star films, 9 two-star films, and 4 one-star films. Make a frequency table for the data...
-
x1 = 10, n1 = 20, x2 = 18, n2 = 30; 80% confidence interval a. Use the two-proportions plus-four z-interval procedure as discussed on page 467 to find the required confidence interval for the...
-
Propel alcohol (C3H7OH) is burned with 50 percent excess air. Write the balanced reaction equation for complete combustion and determine the air-to-fuel ratio.
-
Dallas Corporation wishes to market a new product for \(\$ 1.50\) a unit. Fixed costs to manufacture this product are \(\$ 100,000\) for less than 500,000 units and \(\$ 150,000\) for 500,000 or more...
-
Identifying Expenses Revenues are normally recognized when goods or services have been provided and payment or promise of payment has been received. Expense recognition is guided by an attempt to...
-
A 2. Rental Expenses. (Obj. 1) State the maximum amount of rental expenses attributable to the property that can be claimed by each of the following taxpayers. Taxpayer A B Description A dwelling...
-
What characteristics of a property, plant, and equipment item make it different from other assets, such as accounts receivable or inventory?
-
What is the purpose of an audit performed by a CPA? Do audits signify to financial statement users that no fraud and embezzlement occurred at the organization? How does sampling financial...
-
Below is the university student's completed experiment tally sheet of Jane's marginal utility "scores" and the calculation of her marginal utility per dollar, given that each sandwich costs $4.00,...
-
UMPI's Potatoes produces ready-to-eat mashed potatoes for resale at food stores. The master budget indicates that the company expects to use 5 pounds of direct materials for each unit produced at a...
-
A discussion of THREE separate ESG issues from Air canada company's report, one each addressing Environmental (CHAR), Social and Governance issues. Evaluate how each issue relates to the disclosure...
-
K Solve the problem. In 10 hr, Kerrie can travel 9 mi upriver and come back. The rate of the current is 4 mph. Find the rate of her boat in still water. Let x= the rate of her boat in still water in...
-
Lab4a.py Create the ~/ops445/lab4/lab4a.py script. The purpose of this script will be to demonstrate the different way of comparing sets. There will be three functions, each returning a different set...
-
Star Company, a wholly owned subsidiary of Orbit Inc., produces and sells three main product lines. The company employs a standard cost accounting system for record-keeping purposes.At the beginning...
-
Feller Company purchased a site for a limestone quarry for $100,000 on January 2, 2019. It estimate that the quarry will yield 400,000 tons of limestone. It estimates that its retirement obligation...
-
The following information relates to a machine purchased on January 3, 20X1. Work independently to complete the following problem. 1. Complete tables showing depreciation expense calculated using the...
-
Mannings, Inc. uses three plant asset accounts: Office Equipment, Store Equipment, and Warehouse Equipment. Instructions: 1. Journalize the transactions completed during the current year. Use page 1...
-
Use the plant asset records from On Your Own 8-2. The following transactions occurred in 20X5. A general journal, cash receipts journal, and plant asset records are provided in the Working Papers....
Study smarter with the SolutionInn App