Bus 308 Week 3 Assignment Explained

Set up the input table/range to use as fol ows: Put al of the salary values for each grade under the appropriate grade label. A B C D E F Anova: Single Factor 23 27 41 47 58 76 22 34 42 57 66 77 SUMMARY 23 36 47 50 60 76 Groups Count Sum Average Variance 24 34 40 49 69 75 A 15 353 23.53333 0.695238 24 28 43 55 64 72 B 7 222 31.71429 14.90476 24 28 56 77 C 5 213 42.6 7.3 23 35 60 D 5 258 51.6 17.8 24 65 E 12 751 62.58333 14.81061 24 62 F 6 453 75.5 3.5 24 65 24 60 23 66 ANOVA 22 Source of SS df MS F P-value F crit 25 Between G 17686.02 5 3537.204 409.5941 1.04E-35 2.42704 24 Within Gro 379.9786 44 8.635877 Total 18066 49 Result of ANOVA are statistical y significant. Al grade level don't have equal average salay (F(5, 44) = 409.5941, p < 0.0001) Grade Gender A B C D E F M 24 27 43 47 60 77 25 28 47 49 56 72 F 22 34 41 50 69 75 24 36 42 55 65 77 For each empty cel randomly pick a male or female salary from each grade. Interpret the results. Are the average salaries for each gender (listed as sample) equal? Are the average salaries for each grade (listed as column) equal? Anova: Two-Factor With Replication SUMMARYA B C D E F Total M Count 2 2 2 2 2 2 12 Sum 49 55 90 96 116 149 555 Average 24.5 27.5 45 48 58 74.5 46.25 Variance 0.5 0.5 8 2 8 12.5 323.8409

Score: Week 3 ANOVA and Paired T-test At this point we know the following about male and female salaries. a. Male and female overall average salaries are not equal in the population. b. Male and female overall average compas are equal in the population, but males are a bit more spread out. c. The male and female salary range are almost the same, as is their age and service. d. Average performance ratings per gender are equal. Let's look at some other factors that might influence pay - education(degree) and performance ratings. <1 point> 1 Last week, we found that average performance ratings do not differ between males and females in the population. Now we need to see if they differ among the grades. Is the average performace rating the same for all grades? (Assume variances are equal across the grades for this ANOVA.) You can use these columns to place grade Perf Ratings if desired. A B C D E F Null Hypothesis: the average performance ratings are alike for all 6 grade levels 90 75 100 65 55 95 Alt. Hypothesis: the average performance ratings are not alike for two out of the 6 grade levels 80 80 100 75 90 95 Place B17 in Outcome range box. 100 70 90 95 85 70 Anova: Single Factor 90 90 80 90 100 100 80 80 80 90 95 95 SUMMARY 65 95 90 95 Groups Count Sum Average Variance 95 80 95 A 15 1265 84.3333333 153.09524 60 90 B 7 570 81.4285714 72.619048 90 75 C 5 450 90 100 75 95 D 5 415 83 157.5 95 95 E 12 1045 87.0833333 152.08333 100 80 F 6 550 91.6666667 116.66667 85 70 90 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 519.20238 5 103.840476 0.7789854 0.570215477 2.4270401 Within Groups 5865.2976 44 133.302219 Total 6384.5 49 Interpretation: What is the p-value: 0.5702 Is P-value < 0.05? No Do we REJ or Not reject the null? Do not reject the null hypothesis NA Meaning of effect size measure: NA What does that decision mean in terms of our equal pay question: The results of the above ANOVA indicates that mean performance rating of each of t <1 point> 2 While it appears that average salaries per each grade differ, we need to test this assumption.

0 thoughts on “Bus 308 Week 3 Assignment Explained

Leave a Reply

Your email address will not be published. Required fields are marked *