Suppose your company has just completed a Webinar training program on Health and Safety issues for its managers, and that you have been asked to develop a satisfaction survey and to analyze the data that would be collected by an email survey of participants after the Webinar has been completed. You are in the early stages of developing this survey, but you are sure that you want to include an item asking participants for their overall evaluation of the quality of the HR Webinar Training Program dealing with Health and Safety Issues, and that you want to practice your Excel skills on the hypothetical data are presented in Fig. 4.6:

(a) On your Excel spreadsheet, write the null hypothesis and the research hypothesis for these data.

(b) Use Excel to find the sample size, mean, standard deviation, and standard error of the mean for these data (two decimal places for the mean, standard deviation, and standard error of the mean).

(c) Use Excel to perform a one-group t-test on these data (two decimal places).

(d) On your printout, type the critical value of t given in your t-table in Appendix E.

(e) On your spreadsheet, type the result of the t-test.

(f) On your spreadsheet, type the conclusion of your study in plain English.
(g) save the file as: SAFETY3

Transcribed Image Text:

HR WEBINAR TRAINING PROGRAM ON HEALTH AND SAFETY ISSUES Item #10: ""Overall, how would you rate the quality of the HR Webinar Training Program dealing with Health and Saftey issues?" 1 2 3 4 5 6 7 very very poor good DATA 3 4 5 2 4 3 5 6 7 4 3 5 4 3 3 5 4 6 2 3