When universities in the USA want to hire qualified faculty, they typically advertise for the position on
Question:
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
Step by Step Answer:
Excel 2013 For Human Resource Management Statistics A Guide To Solving Practical Problems
ISBN: 97173
2nd Edition
Authors: Thomas J. Quirk, Julie Palmer Schuyler