A researcher investigates the factors that are associated withthe salaries of professors who teach courses at a major university.The researcher gathers data about the subject area and the salaryper course for a random sample of professors. Data are found in thefile Academic Salaries by Subject Area.
a) State the null and alternate hypothesis we would run todetermine if the average salaries of the professors is the sameacross all subjcet areas.
b) Run the appropriate test in Excel and show output. Whatconclusions can you make?
c) Obtain boxplots for these data, each individual data NPP, anda NPP for all residuals.
d) Are the assumptions of an ANOVA reasonably satisfied? Explain& Discussion in reference to the plots.
e) If there is a difference in salaries run a Tukey’s test toshow how the salaries for the different subject areas compare toeach other. Describe what the results of the Tukey’s test tell you.
Salary per course | | |
Humanities | Social Sciences | Engineering | Managament |
1700 | 2500 | 2700 | 2500 |
1900 | 2300 | 2800 | 2600 |
1800 | 2600 | 2900 | 2300 |
2100 | 2400 | 3000 | 2800 |
2500 | 2700 | 2800 | 3300 |
2700 | 2400 | 2700 | 3400 |
2900 | 2600 | 3700 | 3300 |
2500 | 2400 | 3600 | 3500 |
2600 | 2500 | 3700 | 3600 |
2800 | 3500 | 3800 | |
2700 | 3300 | 3900 | |
2900 | 3600 | | |
| 3400 | | |