Webster University (headquartered in St. Louis, Missouri, USA) offers a Master’s program in Human Resource Management. You have been asked to develop a mail survey that can be sent to students in this M.A. program one month before they are scheduled to graduate from the program to obtain feedback about the quality of the program from its graduate students. You are in the early stages of developing this survey, but a key item that you want to ask deals with the students’ overall attitude toward the quality of this degree program. You want to test your Excel skills on this type of survey, and so you want to analyze the hypothetical data for Item #23 that are given in Fig. 3.10:

Create an Excel spreadsheet with these data.

(a) Use Excel to the right of the table to find the sample size, mean, standard deviation, and standard error of the mean for these data. Label your answers, and use two decimal places for the mean, standard deviation, and standard error of the mean

(b) Enter the null hypothesis and the research hypothesis for this item onto your spreadsheet.

(c) Use Excel’s TINV function to find the 95 % confidence interval about the mean for these data. Label your answers on your spreadsheet. Use two decimal places for the lower limit and the upper limit of the confidence interval.

(d) Enter the result of the test on your spreadsheet.

(e) Enter the conclusion of the test in plain English on your spreadsheet.

(f) Print your final spreadsheet so that it fits onto one page (if you need help remembering how to do this, see the objectives at the end of Chap. 2 in Sect. 2.4).
(g) Draw a picture of the confidence interval, including the reference value, onto your spreadsheet.
(h) Save the final spreadsheet as: HRM4

Transcribed Image Text:

Webster University End of M.A. Program in Human Resource Management Exit Survey Item #23: "Overall, how would you rate the quality of the M.A. Program in Human Resource Management?" 1 2 3 Poor RATING 3 6 5 7 4 5 6 4 6 7 5 7 4 7 7 6 6 6 5 4 6 7 5 6 7 Excellent