(A)Compute the Mean,median,and Standard Deviation of the Annual Salaries for the 52

Essay

(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 the frame of annual salaries.
(C)Compute the mean,median,and standard deviation of the annual salaries for the 13 employees included in your systematic sample in (B)
(D)Compare your statistics in (C)with your computed descriptive measures for the frame in (A).Is your systematic sample representative of the frame with respect to the annual salary variable?
(E)Assume that we wish to stratify these employees by the number of years of post-secondary education,select such a stratified sample of size 15 with approximately proportional sample sizes.
(F)Compute the mean,median,and standard deviation of the annual salaries for the 15 employees included in your stratified sample in (E).
(G)Compare these statistics in (F)with your computed descriptive measures for the frame obtained in (A).Is your stratified sample representative of the frame with respect to the annual salary variable?