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 N 89 95 90 90 100 77 101 97 89 92 100 84 Generate report in Excel. Copy-paste the report in the box below. [5 points) D Question 20 1 pts 2a) Name the factor in this study. [0.5 points). Name the Treatments in this study [0.5 points). Edit View Insert Format Tools Table 12pt Paragraph BI U Aventul I 4 2b) Name the Experimental Design you would use for analyzing the data in this study Z Test O ANOVA. Completely Randomized Design ANOVA - Randomized Block Design O ANOVA - Full Factorial Design Chi-Square Test Question 22 2 pts 2c) State the Null and Alternative Hypotheses for this analysis using parameter labels (Greek labels). [1 point) Name all the parameter labels (specify what each label in the hypothesis stands for). [1 point] Edit View Insert Format Tools Table 12pt Paragraph I ALT I Question 23 2 pts 2d) Type in the Excel function along with inputs you would use to calculate the p-value in the box below. [1 point) Type in the p-value that you would use for conducting the Hypothesis Test in this problem in the box below. [1 point). Edit View Insert Format Tools Table 12pt Paragraph I o I Question 24 2 pts 2e) Conduct the hypothesis test at a 0.03 level of significance using p-value approach (specify the logic). [1 point] What is the decision on the Hypothesis test? [1 point] Question 25 2 pts 2f) Type in the Excel function along with inputs you would use to calculate the critical-value (at a 0.03 level of significance) in the box below. [1 point] Type in the critical value that you would use for conducting the Hypothesis Test in this problem in the box below. [1 point] D Question 26 2 pts 2g) Conduct the hypothesis test at a 0.03 level of significance using the critical-value approach (specify the logic). [1 point] What is the decision on the Hypothesis test? [1 point) D Question 27 1 pts 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 HO, 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 5 pts 2i) a 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. [5 points) D Question 29 2 pts 21) Which brand/s of paper towel provides the best performance? [1 point) Why do you say so? Provide reasoning for your answer in a sentence. [1 point] Edit View Insert Format Tools Table 12ptParagraph e Tv 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 N 89 95 90 90 100 77 101 97 89 92 100 84 Generate report in Excel. Copy-paste the report in the box below. [5 points) D Question 20 1 pts 2a) Name the factor in this study. [0.5 points). Name the Treatments in this study [0.5 points). Edit View Insert Format Tools Table 12pt Paragraph BI U Aventul I 4 2b) Name the Experimental Design you would use for analyzing the data in this study Z Test O ANOVA. Completely Randomized Design ANOVA - Randomized Block Design O ANOVA - Full Factorial Design Chi-Square Test Question 22 2 pts 2c) State the Null and Alternative Hypotheses for this analysis using parameter labels (Greek labels). [1 point) Name all the parameter labels (specify what each label in the hypothesis stands for). [1 point] Edit View Insert Format Tools Table 12pt Paragraph I ALT I Question 23 2 pts 2d) Type in the Excel function along with inputs you would use to calculate the p-value in the box below. [1 point) Type in the p-value that you would use for conducting the Hypothesis Test in this problem in the box below. [1 point). Edit View Insert Format Tools Table 12pt Paragraph I o I Question 24 2 pts 2e) Conduct the hypothesis test at a 0.03 level of significance using p-value approach (specify the logic). [1 point] What is the decision on the Hypothesis test? [1 point] Question 25 2 pts 2f) Type in the Excel function along with inputs you would use to calculate the critical-value (at a 0.03 level of significance) in the box below. [1 point] Type in the critical value that you would use for conducting the Hypothesis Test in this problem in the box below. [1 point] D Question 26 2 pts 2g) Conduct the hypothesis test at a 0.03 level of significance using the critical-value approach (specify the logic). [1 point] What is the decision on the Hypothesis test? [1 point) D Question 27 1 pts 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 HO, 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 5 pts 2i) a 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. [5 points) D Question 29 2 pts 21) Which brand/s of paper towel provides the best performance? [1 point) Why do you say so? Provide reasoning for your answer in a sentence. [1 point] Edit View Insert Format Tools Table 12ptParagraph e Tv