Question

QUESTION 8 The operations manager for an appliance manufacturer wants to determine the optimal length of time for the washing cycle of a household clothes washer. An experiment is designed to measure the effect of detergent brand and washing cycle time on the amount of dirt removed from standard household laundry loads. Four brands of detergent (A,B,C,D) and four levels of washing cycles (18, 20, 22, and 24 minutes) are specifically selected for analysis. 32 standard household laundry loads (having equal weight and dirt) are randomly assigned to the 16 detergent-washing cycle time combinations. The results (in pounds of dirt removed) are Washing Cycle Time (in Minutes) 20 24 0.17 0.18 0.19 Brand 0.11 0.09 0.12 0.1 0.08 009 0.11 0.13 0.17 0.19 0.17 0.18 0.18 0.17 0.16 0.17 0.13 0.14 0.15 0.16 0.13 0.12 0.13 0.2 0.16 0.15 0.17 Perform a Two-way Analysis of Variance with Replication in Excel and output the ANOVA table assuming a 5% level of significance. To answer the question, is there an effect due to detergent brand, what is the p-value? Round your answer to 2 decimal places
0 0
Add a comment Improve this question Transcribed image text
Answer #1

To test the following null hypothesis:

H0: The means of observations grouped by 'Brand' are the same.

Vs Alternative hypotheses,

Ha: The means of observations grouped by 'Brand' are different.

Using excel,

Once the data is entered,

BOOKT-MIcrosoTL EXCel Home Insert Page Layout FormulasData Review View E固卦 ト 盼姐? 1 E3Data Analysis Clear ョ급 Connections Show Detail Properties |집 Sort Filter Y Hide Detail om From From From OtherExisting Refresh ess Web Text SourcesConnections All | sort | Filter Text to Remove Data Consolidate What-f Group Ungroup Subtotal Edit Links Advanced Columns Duplicates Validation Analysis Get External Data Connections Sort & Filter Data Tools Analysis f Brand Data Analysis Brand 18 20 0.13 0.13 0.14 0.15 0.16 0.13 0.12 0.13 24 0.17 0.18 0.19 0.17 0.2 0.16 0.15 0.17 0.19 0.17 0.18 0.18 0.17 0.16 Analysis Toos Anova: Anova: Two-Factor With Replcation Anova: Two Factor Without Repication Correlation e Factor 0.09 0.12 0.1 0.08 0.09 0.11 Descriptive Statistics Exponental Smoothing F-Test Two-Sample for Variances Fourier Analysis HistogramHere, rows per sample is the no. of observations in each group, i.e., the no .of observations of a Brand at one level of Washing Cycle Time is 2.

The output is obtained as follows:

Looking into the two way ANOVA table,

For the factor Brands (Sample),

No. of brands(n) = 4 and its corresponding df = n-1 = 3.

Here, the F statistic value is less than the tabled value.And the p value obtained is 0.519 >0.05.Therefore, we do not have sufficient evidence to reject H0.We may accept H0 at 5% level of significance.

It may be concluded that, the means of observations grouped by 'Brand' are the same.

Hence,

The p value for effect due to detergent brand is 0.52.Since it is not significant at 5% level, it may be concluded that there is no significant effect due to detergent brand.

Add a comment
Know the answer?
Add Answer to:
QUESTION 8 The operations manager for an appliance manufacturer wants to determine the optimal length of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • can someone please check my answer, thanks! The operations manager for an appliance manufacturer wants to...

    can someone please check my answer, thanks! The operations manager for an appliance manufacturer wants to determine the optimal length of time for the washing cycle of a household clothes washer. An experiment is designed to measure the effect of detergent brand and washing cycle time on the amount of dirt removed from standard household laundry loads. Four brands of detergent (A,B,C,D) and four levels of washing cycles (18, 20, 22, and 24 minutes) are specifically selected for analysis. 32...

  • ...l Verizon 21:37 6% Х MBA 626 Case Stu... Q MBA 626 Case Study Two-Way ANOVA...

    ...l Verizon 21:37 6% Х MBA 626 Case Stu... Q MBA 626 Case Study Two-Way ANOVA Product development engineers and marketers at a household washing machine manufacturing firm want to determine the optimal length of time for a washing cycle. Part of the study includes understanding the relationship between the detergent used (four brands) and the length of the washing cycle (18, 20, 22, or 24 minutes). In order to run the experiment, 32 standard household laundry loads (having equal...

  • may I be able to get the excel sheet for this? sections A and B, I...

    may I be able to get the excel sheet for this? sections A and B, I do have the rest of it. ...l Verizon 21:37 6% Х MBA 626 Case Stu... Q MBA 626 Case Study Two-Way ANOVA Product development engineers and marketers at a household washing machine manufacturing firm want to determine the optimal length of time for a washing cycle. Part of the study includes understanding the relationship between the detergent used (four brands) and the length of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT