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. 

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 systematic sample of size 13 from this frame. 

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