STATS

Consider the following data set:59 6476 311 3 10 1313 14111110 78 13 11 1311 46145 69 3 6 Click here for the Excel Data Filea.Construct a frequency distribution using classes of 3 up to 5, 5 up to 7, etc. ClassFrequency A. 3 up to 5 B. 5 up to 7 C. 7 up to 9 D. 9 up to 11 E. 11 up to 13 F. 13 up to 15 Total b.Construct relative frequency, cumulative frequency, and cumulative relative frequency distributions. (Round “Relative Frequency” and “Cumulative Relative Frequency” to 2 decimal places.) ClassRelativeFrequencyCumulativeFrequencyCumulativeRelative Frequency A. 3 up to 5 B. 5 up to 7 C. 7 up to 9 D. 9 up to 11 E. 11 up to 13 F. 13 up to 15 Total c-1.How many of the observations are at least 7 but less than 9? Number of observations c-2.How many of the observations are less than 9? Number of observations d-1.What percentage of the observations are at least 7 but less than 9? (Round your answer to the nearest whole percent.) Percentage of observations%d-2.What percentage of the observations are less than 9? (Round your answer to the nearest whole percent.) Percentage of observations%e.Select a relative frequency histogram.Histogram AHistogram BHistogram CHistogram AHistogram BHistogram Cf.Graph an Ogive.Before plotting the points, round the “Relative Frequency” to 2 decimal places.Click the Plotter tool and drag the first point you want to plot onto the grid. Continue clicking and dragging the plotter tool until you have identified all of the necessary points for this line. To earn full credit for this graph, you must plot all required points for sample mean.Once all points have been plotted, click on the line (not individual points) and a tool icon will pop up. You can use this to enter exact co-ordinates for your points as needed.