When universities in the USA want to hire qualified faculty, they typically advertise for the position on a Web site for professional organizations that include job openings on the Web site so that members of the organizations can become informed about possible job matches in their career search. If a university wants to hire a new qualified faculty member to teach Human Resource Management, there are three popular Web sites that provide this job listing:

(1) The American Society for Training and Development (ASTD), (2) The Society for Human Resource Management (SHRM), and (3) The Chronicle of Higher Education. Suppose that a university wants to determine if there was a difference in applications received from these three Web sites when the past eight professors of HRM were hired by that university. The hypothetical data for this study are given in Fig. 8.8.

(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 three Web sites.

(c) If the F-value in the ANOVA table is significant, create an Excel formula to compute the ANOVA t-test comparing the average applications for SHRM against the average applications for ASTD, 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 two decimal places for each value)

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

(e) Save the spreadsheet as: Placement6