Chapter 10.2, Problem 3SE

Is there a difference in the average number of years’ seniority between returning part-time seasonal employees and returning full-time seasonal employees at a ski resort? From a random sample of 191 returning part-time employees, the average seniority, ${\bar{x}}_1$, was 4.9 years with a standard deviation, s₁, equal to 5.4 years. From a random sample of 833 returning full-time employees, the average seniority, ${\bar{x}}_2$, was 7.9 years with a standard deviation, s₂, equal to 8.3 years. Assume the population variances are not equal. (a) Test the hypothesis of equal means using α = .01. (b) Calculate the p-value using Excel.