Homework SourseThe following information applies to the questions displayed
[The following information applies to the questions displayed below.]
Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on an ongoing basis. Team members rotate from time to time. Every 4 months (three times a year) each department head rates the performance of each project team (using a 0 to 100 scale, where 100 is the best rating). Are the main effects significant? Is there an interaction?
Fill in the missing data. (Round your Table of Means values to 1 decimal place, SS and F values to 2 decimal places, MS values to 3 decimal places and p-value to 4 decimal places.)
| Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on an ongoing basis. Team members rotate from time to time. Every 4 months (three times a year) each department head rates the performance of each project team (using a 0 to 100 scale, where 100 is the best rating). Are the main effects significant? Is there an interaction? |
Solution
After carrying out the ANOVA in mS-EXCEL with data analysis toolpack we get the following results.
Based on this we can fill our tables.
| Anova: Two-Factor With Replication | ||||||
| SUMMARY | Marketing | Engineering | Finance | Total | ||
| 2004 | ||||||
| Count | 3 | 3 | 3 | 9 | ||
| Sum | 259 | 239 | 262 | 760 | ||
| Average | 86.3 | 79.7 | 87.3 | 84.4 | ||
| Variance | 14.3 | 17.3 | 56.3 | 35.0 | ||
| 2005 | ||||||
| Count | 3 | 3 | 3 | 9 | ||
| Sum | 257 | 247 | 261 | 765 | ||
| Average | 85.7 | 82.3 | 87.0 | 85.0 | ||
| Variance | 9.3 | 5.3 | 133.0 | 41.3 | ||
| 2006 | ||||||
| Count | 3 | 3 | 3 | 9 | ||
| Sum | 263 | 206 | 257 | 726 | ||
| Average | 87.7 | 68.7 | 85.7 | 80.7 | ||
| Variance | 4.3 | 2.3 | 0.3 | 83.5 | ||
| Total | ||||||
| Count | 9 | 9 | 9 | |||
| Sum | 779 | 692 | 780 | |||
| Average | 86.6 | 76.9 | 86.7 | |||
| Variance | 7.8 | 45.6 | 48.0 | |||
| ANOVA | ||||||
| Source of Variation | SS | df | MS | F | P-value | F crit |
| Sample | 100.07 | 2 | 50.037 | 1.86 | 0.1850 | 3.55 |
| Columns | 567.19 | 2 | 283.593 | 10.52 | 0.0009 | 3.55 |
| Interaction | 225.70 | 4 | 56.426 | 2.09 | 0.1240 | 2.93 |
| Within | 485.33 | 18 | 26.963 | |||
| Total | 1378.30 | 26 |
![[The following information applies to the questions displayed below.] Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on](/WebImages/18/the-following-information-applies-to-the-questions-displayed-1035857-1761537460-0.webp "[The following information applies to the questions displayed below.] Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on")
![[The following information applies to the questions displayed below.] Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on](/WebImages/18/the-following-information-applies-to-the-questions-displayed-1035857-1761537460-1.webp "[The following information applies to the questions displayed below.] Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on")
