# 1.11 Using the Excel Spreadsheet to create a Frequency Table - Frequency Table Tab


You can enter information in the blue cells; however, the green cells are calculated cells that will take your information to create the frequency table.

See instructions below on how to use this Excel Spreadsheet.

#### Tab: Frequency Table

When you have continuous data, you want the spreadsheet to compute the class width and create a frequency table.  Please enter the data into the spreadsheet and complete the blue cells that do not have data in them.

1.1, 1.5, 2.3, 5.4, 9.8, 11.2, 8.7, 7.7, 8.4, 5.6, 6.3, 5.9, 7.4, 8.9

The classes will begin at the start and not include the end value.  The ending value and the start values of the class are the same.

Enter the data into the cells starting with cell A2.  Then determine the other values to complete the frequency distribution.

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