a. Construct a grouped frequency distribution and a cumulative frequency distribution with 6 classes. Note: give a brief explanation by specifying the covered steps.
Grouped Frequency Distribution Step 1. Find Range Step 2. Compute classes’ width Step 3. Create class boundaries Step 4. Tally the data and find the numerical frequencies from the tally
Cumulative Frequency Distribution Step 1. Find Range Step 2. Compute classes’ width Step 3. Find the frequencies and the corresponding percentage
b. Use Excel to construct a Histogram. (Tools Data Analysis Histogram for input range select the given values, for the bin range select the classes upper boundaries values check Chart Output).
I am sure that you have the information to do this either from your class or textbook. Otherwise, searching the internet should work. Also, show what you have done.