# 1.11 Using Excel Spreadsheet Provided - Frequency Table


## Frequency Table

Click on the Frequency Table tab in the Excel spreadsheet provided.  Start in cell A2 and enter the data below.  In this spreadsheet, you must enter the data one cell at a time.  Enter the data below in cells A2 through A26.  The spreadsheet will determine the number of classes based on the 2n method.  The 2n process sets the number of classes to the smallest integer greater than log(n)/log(2), where n is the sample size (i. e., log(25)/log(2)).

#### Data

 14.3 , 16.1 , 19.4 , 14.8 , 24 , 16.8 , 23.1 , 18.4 , 21.7 , 16.3 , 12.5 , 17.6 , 22.7 , 18.7 , 10.3 , 19.6 , 27.5 , 25.1 , 25.8 , 16.8 , 21.2 , 21.8 , 27.5 , 13.4 , 17.1

Entering the data in the cells.

• Enter 14.3 in cell A2.
• Enter 16.1 in cell A3.
• Enter 19.4 in cell A4.
• Enter 14.8 in cell A5.
• Continue this process until you enter 17.1 in A26.

The spreadsheet will calculate part of the frequency table.

You are to complete the table based on the definition of each part in the table below.  You will enter values in the blue cells.  In the table below

 Class Start End Frequency Cum Freq. Rel Freq. Cum Rel. Freq. 1 10.3 13.79 3 3 3/25 = 0.1200 3/25 = 0.1200 2 13.79 17.28 7 3+7 = 10 7/25 = 0.2800 10/25 = 0.4000 3 17.28 20.77 5 10+5 = 15 5/25 = 0.2000 15/25 = 0.6000 4 20.77 24.26 6 15+ 6 =21 6/25 = 0.2400 21/25 = 0.8400 5 24.26 27.75 4 21 + 4=25 4/25 = 0.1600 25/25 = 1.0000 Total 25

You will complete the table by entering the following.

• Enter 13.79 in cell D9.
• Enter 20.77 in cell D11.
• Enter 3 in cell G8.
• Enter 21 in cell G11.
• Enter 0.2800 in cell H9.
• Enter 0.2400 in cell H11.
• Enter 0.1200 in cell I9.
• Enter 08400 in cell I11.

1.11 Using Excel Spreadsheet Provided - Frequency Table is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.