$($a$)$ Develop a frequency distribution using classes of $12-14,15-17,18-20,21-23,$ and $24-26.$

A frequency distribution is a tabular summary of data showing the number $($frequency$)$ of observations in each of several nonoverlapping categories or classes. There is also a final row

displaying the total sample size. To develop a frequency distribution for the given data, count the number of times each value appears in the given ranges. This can be done in Excel using the

FREQUENCY function. This function has the format FREQUENCY $($range of data, upper class limits$).$

Recall the given data.

Copy and paste the given data into an Excel spreadsheet. In cell A$10,$ add the label Class and list the specified classes. If the cell for the class $12-14$ changes to $"14-$Dec," change the format

to Text in the Number group on the Home tab of the Ribbon and reenter $12-14$ into the cell. In cell B$10,$ add the label Bin and list the upper value from each of the specified classes. In cell

B$16$ add the label Total. In cell C$10,$ add the label Frequency.

Use the following procedure to count the number of observations in each class.

Select the cells where the frequency counts will go$,$ C$11$:C$15.$

Type the formula $=$FREQUENCY$($A$1$:E$8,$ B$11$:B$15).$ Press CTRL $+$ SHIFT $+$ ENTER after typing the formula. The range of data is located in the cell range A$1$:E$8$ and the upper

bin limits are located in cells B$11$:B$15.$ The frequency counts will p$$pulate in cells C$11$:C$15.$