Suppose that you worked for a large engineering company with locations in various cities within the USA. “Employee turnover” is a critical factor in the success of every business since talented and experienced employees are difficult to replace if they decide to leave the company. Suppose that you have collected the turnover rate data presented in Fig. 8.6 by randomly sampling your company’s locations for each of the four departments of your company. You have been asked to analyze the data to determine if there was a significant difference in the turnover rate between the four departments over the past year.

(a) Enter these data on an Excel spreadsheet.

(b) Perform a one-way ANOVA test on these data, and show the resulting ANOVA table underneath the input data for the four departments.

(c) If the F-value in the ANOVA table is significant, create an Excel formula to compute the ANOVA t-test comparing the average for MANUFACTURING against SALES and show the results below the ANOVA table on the spreadsheet (put the standard error and the ANOVA t-test value on separate lines of your spreadsheet, and use one decimal place for each value)

(d) Print out the resulting spreadsheet so that all of the information fits onto one page

(e) Save the spreadsheet as: Turnover8

Transcribed Image Text:

COMPANY XYZ TURNOVER RATE (in percent) LAST YEAR ENGINEERING MANUFACTURING ADMINISTRATION SALES 8 11 8 6 10 19 9 12 11 17 15 12 16 10 286 9 18 11 7 8 12 9 9 10 13 14 8 11 15 9 10 12 16 8 14 76869 16 222 10 11 11 12 19 9 0218 a 18 60 7 8 10