Human Resource Management researchers examined the impact ofenvironment on employee development. Employees were randomlyassigned one of the following four workplace types/conditions:Impoverished (isolated cubicles each with bare minimum equipment -chair, desk & computer), standard (cubicles placed hear eachother, equipped with a 'normal level' of office equipment -printer, shelves, manuals, stationery, etc.), enriched (standardcubicles plus regular work-related meetings), super enriched(enriched environment plus regular non-work-related socialevents).
Employees were also categorized by functionthey performed for the company (engineering, sales, manufacturing,etc.), because it's possible that functional background may havebeen a bigger association with test score than workingcondition. Â
After two months, the employees were tested on a variety ofwork-relevant learning measures. Use the Microsoft Excel \"Anova:Two-Factor Without Replication\" Data Analysis tool to conduct a2-way ANOVA test for the data in the followingtable:
| Employee Function | WorkingCondition |
| Impoverished | Standard | Enriched | Super Enriched |
| Engineering | 8 | 17 | 22 | 22 |
| Sales | 7 | 21 | 24 | 19 |
| Marketing | 15 | 10 | 15 | 21 |
| Finance & Accounting | 14 | 12 | 19 | 29 |
| Purchasing | 18 | 19 | 15 | 16 |
| Manufacturing | 12 | 11 | 14 | 4 |
- What are the two Questions, incontext, that we want our ANOVA to answer?
- What are your two answers? Use thefactor confidence levels obtained by way of the Excel ANOVA outputtable's p-values. State your answers in terms of working conditionand employee function.
- What are your two null hypotheses in this study?
- What are your two corresponding alternate hypotheses? Use thephrase \"at least one\" in each of your hypothesis statements.
