A Statistics Professor Has Just Given the Final Examination in His

Essay

A statistics professor has just given the final examination in his introductory statistics course. In particular, he is interested in learning how his class of 50 students performed on this exam. The data are shown below.
-(A) Using these 50 students as the frame, use Excel to generate a simple random sample of size 10 from this frame.
​
(B) Compute the mean scores in the frame and the simple random sample you generated in (A).
​
(C) Compare the mean scores you computed in (B). Is your simple random sample a good representative of the frame? Why or why not?
​
(D) Using these 50 students as the frame, use Excel to generate a systematic sample of size 10 from this frame.
​
(E) Compare the mean scores in the frame with that in the systematic sample in (D). What do you conclude?