Morale surveys of employees are an important aspect of the work of Human Resource (HR) departments in organizations so that top management can be made aware of employees’ attitudes before major problems occur. Suppose that you have been asked to analyze the data from a recent HR survey of middle managers in your organization and that you want to test your Excel skills on a small sample of managers for Item #21 of this survey. The hypothetical data appear in Fig. 1.17.

(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 round off the mean, standard deviation, and standard error of the mean to two decimal places; use number format for these three figures.

(b) Print the result on a separate page.

(c)

(c) Save the file as: MGT21