1.The probation sentences of 21 individuals are: 2, 2, 2, 3, 4, 4, 5, 5, 5, 5, 6, 6, 6, 6, and 7, 7, 7, 7, 7, 7, 7 years. (26 points)

a.Present these raw data in a simple frequency distribution table.

b.Determine relative frequencies (percentages) and cumulative relative frequencies (cum%).

c.Calculate the mean, median, mode, and standard deviation for the frequency distribution

d.Convert the frequency distribution into a grouped frequency distribution that has 3 equal intervals and determine the class interval (i).

e.In a newly created table, display the grouped frequency distribution, the class intervals, and for each interval list the absolute frequency, the relative frequency (%), the relative cumulative frequency (cum%), the mid-point (M), and the exact interval limits.

Use Excel to create bar/column graph that would display the probation sentences for the sample. You should use the grouped frequency distribution and the percentage of people in each category.Make sure your chart has a title and all relevant information is included.