Please use Excel and G-powder solve'

General Cereals is a large manufacturer of pre-sweetened, ready-to-eat childrens cereals. One of its oldest brands is Super Golden Sweeties. As part of its marketing efforts, General Cereals has been running a test market for new package designs for Super Golden Sweeties. The test of the three designs ran for 52 weeks. The research question: Are sales for the three package designs unequal? And, if they are, which of the pairs are unequal? Here are the results based on cases sold per week in the test markets for each of the three package designs:

2) Select a Level of Significance,

A 5 percent significance level has been selected. What is the Critical Value of F? Please Note: You will not find the critical value on a standard F-distribution table. Use Excels F.INV.RT function. Excels Anova: Single Factor tool also reports the critical value of F. Do not show the ANOVA Table here.

3) State the Null and Alternate Hypotheses

H0:
H1:

Follow the examples shown in Clear-Sighted Statistics. You must use the appropriate Greek letters and mathematical symbols.

4) Compose a Decision Rule

5) Data Analysis. Create an ANOVA table. Calculate and interpret the eta-square Effect Size. Calculate Statistical Power and the probability of a Type II error. When necessary, conduct a complete LSD Confidence Interval post hoc analysis. Do not use any other post hoc method. All of your calculations must go here. Do not use any software other than Microsoft Excel.

ANOVA Table:

Effect Size, Statistical Power, and the Probability of a Type II Error:

Effect Size and Interpretation:

Statistical Power:

Probability of a Type II Error:

Interpretation of Statistical Power:

LSD Confidence Interval Post Hoc Analysis:

6) Decide and Report. Conduct a post hoc analysis if you reject the Null Hypothesis

Please Note: You report must be framed in the context of the research question. Merely stating that you rejected or failed to reject the Null Hypothesis is not sufficient. You must consider the issues of statistical power, Effect Size, and practical significance in your report.

B Cases of Super Golden Sweeties Sold 2 Week Design 1 Design 2 Design 3 3 1 150 200 170 4 2 180 220 170 5 3 170 160 120 6 4 175 190 170 5 180 160 160 8 6 180 180 150 9 7 190 150 170 10 8 170 170 180 11 9 180 190 170 12 10 165 180 190 13 11 190 140 160 14 12 180 190 170 15 13 160 200 170 16 14 170 160 120 17 15 175 190 170 18 16 195 160 160 19 17 195 190 150 20 18 170 180 170 21 191 180 150 180 22 20 180 190 170 23 21 170 180 190 24 22 200 120 170 25 23 150 190 170 26 24 160 200 120 27 25 185 190 170 28 26 160 160 160 29 27 180 120 150 30 28 170 150 170 31 29 190 150 180 32 30 190 190 170 33 31 175 180 190 34 32 190 120 170 35 33 180 100 170 36 34 165 150 120 37 35 180 190 170 38 36 175 160 160 39 37 180 120 150 40 38 175 150 170 41 39 175 150 180 42 40 165 190 170 43 41 160 180 190 44 42 180 120 160 45 43 180 180 190 46 44 160 120 160 47 45 190 160 48 46 165 150 190 49 47 190 100 170 50 48 170 180 190 51 49 170 160 180 52 50 180 170 150 160