Suppose that the HR department of your organization completed a training program a year ago that was intended to reduce the number of sexual harassment complaints received from employees. Suppose, further, that the HR department received an average of 25 complaints per month of sexual harassment from employees 2 years ago in the 12 months prior to this training program, and that you want to determine if the number of complaints has been reduced for the year just ended. You have collected data on each of the previous 12 months for this research question, and you want to practice your data interpretation skills on the hypothetical data which appear in Fig. 4.7.

(a) Write the null hypothesis and the research hypothesis on your spreadsheet

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

(c) Enter the critical t from the t-table in Appendix E onto your spreadsheet, and label it.

(d) Use Excel to compute the t-value for these data (use two decimal places)
and label it on your spreadsheet

(e) Type the result on your spreadsheet, and then type the conclusion in plain English on your spreadsheet

(f) Save the file as: COMPLAINTS3