statistics
You may use Excel to calculate, you have to show all your work every step
1. Organize the data set in a frequency table using bins with width 10, starting from 20-29, 30-39 and so on. Include columns for the relative and cumulative frequency.
2. Organize the data set in a frequency table using bins with width 10, starting from 20-29, 30-39 and so on. Include columns for the relative and cumulative frequency.
3. Calculate the standard deviation of the data set using the frequency table and the formula,
where x represents the class midpoint, f represents the class frequency, and n represents the total number of sample values. Also, compare this value of standard deviation with the value found in step
4. Use a calculator or software to find the 5- Number Summary of the data set. Construct a boxplot. Calculate IQR, semi-interquartile range, and midrange.
5. Identify outliers if there are any and construct a modified boxplot