Question: Please put it in excel. 1. A test administered to a statistics class of 50 students resulted in the following scores: 65 45 33 72


Please put it in excel. 1. A test administered to a statistics class of 50 students resulted in the following scores: 65 45 33 72 50 36 43 52 65 82 85 63 76 52 60 32 63 52 82 46 78 55 40 90 86 37 47 40 92 70 63 30 92 45 82 60 92 72 36 41 86 46 77 36 34 46 74 70 87 83 a.) Construct a frequency distribution using 10 class intervals with the lower limit of the lowest class interval as the lowest score of the above data. Include the "relative" and the cumulative "less than" and "more than" frequency distribution. b.) Construct the histogram, frequency polygon and ogive using graphing paper
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
