Practice for Module 9 (2)

Store A Store B Store C Store D Store E This is data for five groups, with 1 31.2 24.6 30.0 34.4 28.0 34.8 28.4 37.8 32.4 32.0 A. Use Data>Data Ana 26.0 31.8 31.4 36.0 28.8 yes B. At the 5% signfican 29.4 30.6 33.3 33.3 27.9 4.01 C. Which value of Q fr 33.9 34.6 38.7 29.9 25.7 10.177055 D. What is the Mean S 29.0 28.6 28.5 24.9 25.4 11.00 E. Appropriate value o 35.7 25.7 30.7 32.4 24.8 3.86 F. Critical Range 30.2 22.4 33.7 34.2 25.9 none Which stores, if any, c 29.3 24.3 31.7 34.8 26.2 CD Which stores, if any, c 27.3 26.6 29.5 27.9 32.0 30.7 27.2 33.1 32.5 24.0 Anova: Single Factor SUMMARY Groups Count Sum Average Variance Column 1 11 337.5 30.681818 9.2736364 Column 2 11 304.8 27.709091 12.884909 Column 3 11 358.4 32.581818 10.523636 Column 4 11 352.7 32.063636 10.828545 Column 5 11 300.7 27.336364 7.3745455 ANOVA urce of Variati SS df MS F P-value F crit Between Gr 260.75164 4 65.187909 6.4053807 0.000305 2.5571791 Within Grou 508.85273 50 10.177055 Total 769.60436 54

11 observations per group. alysis to produce ANOVA single factor results, and paste them beginning in cell A15 nce level, can you conclude that at least two of means are different? (Yes or no in the green box) rom the Q Table should be used in the critical range equation? 50 Square Within (MSW)? of "n" to use in the critical range equation can you conclude have a different mean than Store A? can you conclude have a different mean than Store B? Yes Anova: Single Factor 4.01 10.177055 SUMMARY 11 Groups Count Sum Average Variance 3.86 Store 1 11 337.5 30.68182 9.273636 none Store 2 11 304.8 27.70909 12.88491 CD Store 3 11 358.4 32.58182 10.52364 Store 4 11 352.7 32.06364 10.82855 Store 5 11 300.7 27.33636 7.374545 ANOVA Source of Varia SS df MS F P-value F crit Between G 260.7516 4 65.18791 6.405381 0.000305 2.557179 Within Gro 508.8527 50 10.17705 Total 769.6044 54

Number of Groups df↓ 3 4 5 6 7 8 10 3.88 4.33 4.66 4.92 5.13 5.31 11 3.82 4.26 4.58 4.83 5.03 5.21 12 3.78 4.20 4.51 4.75 4.95 5.12 13 3.74 4.16 4.46 4.69 4.89 5.05 14 3.71 4.12 4.41 4.64 4.83 4.99 15 3.68 4.08 4.37 4.60 4.79 4.94 16 3.65 4.05 4.34 4.56 4.75 4.90 17 3.63 4.02 4.31 4.53 4.71 4.86 18 3.61 4.00 4.28 4.50 4.68 4.83 19 3.60 3.98 4.26 4.47 4.65 4.80 20 3.58 3.96 4.24 4.45 4.62 4.77 21 3.57 3.95 4.22 4.43 4.60 4.75 22 3.56 3.93 4.20 4.41 4.58 4.73 23 3.55 3.92 4.18 4.39 4.56 4.71 24 3.54 3.91 4.17 4.38 4.55 4.69 25 3.53 3.89 4.16 4.36 4.53 4.67 26 3.52 3.88 4.15 4.35 4.52 4.66 27 3.51 3.87 4.13 4.34 4.50 4.64 28 3.50 3.87 4.12 4.33 4.49 4.63 29 3.50 3.86 4.12 4.32 4.48 4.62 30 3.49 3.85 4.11 4.31 4.47 4.61 35 3.47 3.82 4.07 4.27 4.43 4.56 40 3.45 3.80 4.04 4.24 4.39 4.53 45 3.43 3.78 4.02 4.21 4.37 4.50 50 3.42 3.76 4.01 4.19 4.35 4.48 55 3.41 3.75 3.99 4.18 4.33 4.46 60 3.40 3.74 3.98 4.17 4.32 4.45 70 3.39 3.73 3.96 4.15 4.30 4.42 80 3.38 3.72 3.95 4.13 4.28 4.41 90 3.37 3.71 3.94 4.12 4.27 4.39 200 3.34 3.66 3.89 4.07 4.21 4.33

Observed excellent good fair poor Total male 58 99 42 20 219 female 41 91 59 36 227 Total 99 190 101 56 446 0.2219731 0.426009 0.2264574 0.1255605 Expected excellent good fair poor Male 48.6121 93.2960 49.5942 27.4978 Female 50.3879 96.7040 51.4058 28.5022 1.8130 0.3487 1.1629 2.0444 1.7491 0.3364 1.1219 1.9723 10.5487 0.01443 YES The data to the left shows product ra determine if there is a relationship b rating by answering the series of que A. Put the expected values in the gr B. Put the relative squared errors an green boxes to the left. C. Convert the value in cell F18 to a Excel formula. You must use the valu D. Can you conclude that there is a r and product rating? (Yes or no in the

Observed excellent good fair poor male 58 99 42 20 female 41 91 59 36 Total 99 190 101 56 0.221973 0.426009 0.226457 0.125561 Expected excellent good fair poor male 48.6121 93.2960 49.5942 27.4978 female 50.3879 96.7040 51.4058 28.5022 Relative Squared Errors excellent good fair poor male 1.8130 0.3487 1.1629 2.0444 female 1.7491 0.3364 1.1219 1.9723 TOTAL: rating by gender. Test to between gender and product estions below. reen boxes to the left. nd total of these errors in the p-value using the appropriate ue in cell F18. relationship between gender e box).