Question
Problem 2: Product developers at a paper towel company developed three brands of paper towels and tested for their ability to absorb water. Equal-size towels
Problem 2: Product developers at a paper towel company developed three brands of paper towels and tested for their ability to absorb water. Equal-size towels were used, with four sections of towels tested per brand and the "Absorbency Rating" data are presented in the following table. Perform an appropriate analysis on the data at 0.03 level of significance. Paper Towel Brands X Y Z 89 95 90 90 100 77 101 97 89 92 100 84 Generate report in Excel. Copy-Paste the report in the box below.
Answer the following questions (Questions 19 through 28) in the boxes underneath them for another20 points. You must provide your answers in the boxes under the questions to earn points. Attaching an Excel report/file is not sufficient to earn points. You must demonstrate your understanding and ability for utilizing the report to answer specfic questions to earn points. Question 20 2a) Name the Factor in this Study. Name the Treatments in this study. Question 21 2b) Name the Experimental Design you would use for analyzing the data in this study. Group of answer choices Z Test ANOVA - Completely Randomized Design ANOVA - Randomized Block Design ANOVA - Full Factorial Design Chi-Square Test Question 22 2c) State the Null and Alternative Hypotheses for this analysis using parameter labels (Greek labels). Name all the parameter labels (specify what each label in the hypothesis stands for). Question 23 2d) Type in theExcel function along with inputsyou would use to calculate the p-value in the box below. Type in thep-valuethat you would use for conducting the Hypothesis Test in this problem in the box below. Question 24 2e) Conduct the hypothesis test at a 0.03 level of significance using p-value approach (specify the logic). What is the decision on the Hypothesis test? Question 25 2f) Type in theExcel function along with inputsyou would use to calculate the critical-value (at a 0.03 level of significance) in the box below.[1 point] Type in thecritical-valuethat you would use for conducting the Hypothesis Test in this problem in the box below. Question 26 2g) Conduct the hypothesis test at a 0.03 level of significance using the critical-value approach (specify the logic). What is the decision on the Hypothesis test? Question 27 2h) State the conclusion(as an English sentence for Paper Towel Absobency Rating problem) based on p-value and critical-values approaches for the hypothesis tests you have conducted in the previous questions above.[1 point] Note:Reject H0, Fail to Reject Ho are NOT conclusions. They are the decisions on the hypothesis test. What they mean in the business problem context is the conclusion - an actionable piece of information for the decision maker. Question 28 2i) Conduct the LSD tests in Excel (showing all the steps) at a 0.03 level of significance to identify which brand/s of paper towel provide different performance with respect to "Absorbency Rating" among the ones tried. Copy-Paste the results in the box below. Question 29 2j) Which brand/s of paper towel provides the best performance? Why do you say so? Provide reasoning for your answer in a sentence.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started