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

Last updated
Save as PDF

Page ID: 20129

\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

This section teaches you to create a frequency table using the Excel spreadsheet provided for this textbook section. There are four spreadsheets in the Excel Spreadsheet below. You can download the spreadsheet by clicking the download button ( ), which is the first button on the left in the right-hand corner of the Excel Spreadsheet screen. To use the Excel spreadsheet below, you must type in the data. After you download the data, you can copy the data into the spreadsheet using copy and paste commands. To delete a cell in the spreadsheet below, You must delete it one cell at a time. You delete it by double-clicking in the cell and highlight the data, and hit the backspace key.

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.