Consider the frame of 52 full-time employees of Beta Technologies, Inc. Beta’s human resources manager has collected current annual salary figures and related data for these employees. The data are in the file P2_1.XLS. In particular, these data include each selected employee’s gender, age, number of years of relevant work experience prior to employment at Beta, the number of years of employment at Beta, the number of years of post-secondary education, and annual salary.

a. Compute the mean, median, and standard deviation of the annual salaries for the 52 employees in the given frame.

b. Use Excel to choose a simple random sample of size 15 from this frame.

c. Compute the mean, median, and standard deviation of the annual salaries for the 15 employees included in your simple random sample. Compare these statistics with your computed descriptive measures for the frame obtained in part a. Is your simple random sample representative of the frame with respect to the annual salary variable?