Skip to main content
Library homepage
 
Statistics LibreTexts

1.10 Using the Excel Spreadsheet provided - Frequency Table You Bin

  • Page ID
    19722
  • \( \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}}\)

    Frequency Table You Bin

    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 ( Excel Download button). It is the first button on the left in the right-hand corner of the Excel Spreadsheet screen.  Another method of downloading the Excel Spreadsheet is to put the URL in a web browser to download the workbook.

    URL: https://drive.google.com/uc?id=1KTtNFg9NW6x14EWI79uerZ4Oet1LHaet&export=download

    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, double-click the cell and hit the backspace button. 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 only. In the other cells, you will not be able to enter data. Some are blank, and others have formulas.  The formulas will create the frequency table.  

    See instructions below on how to use this Excel Spreadsheet.

    Suppose you have a problem that asks you to create a frequency table from the data below.

    4, 8, 9, 11, 13, 14, 15, 18, 18, 19, 19, 20, 21, 23, 24, 25

    Create a frequency table with the following bins.

    2 - 6
    7 - 11
    12 - 16
    17 - 21
    22 - 26

    Enter the data in cells A2 to A18.  Then starting in cell D8, enter 2.  Then in cell E8, enter 6.  In cell D9, enter 7.  In cell E9, enter 11.  In cell D10, enter 12.  Enter 16 in cell D16.  In cell D11, enter 17.  In cell E11, enter 21.  In cell D12, enter 22. Finally, in cell E12, enter 26.  

    In the frequency table, the Cumulative Frequency starts with the Frequency for the first-class frequency, 0.  Then the cumulative frequency is a running total of the frequency.  The relative frequency is the Frequency/Total Frequency.  The cumulative relative frequency is the cumulative frequency/Total frequency.

    Frequency Cumulative Frequency Relative Frequency Cumulative Relative Frequency
    1 1 =1/16 = 0.0625 (6.25%) =1/16 = 0.0625  (6.25%)
    3 1+3=4 =3/16 = 0.1875 (18.75%) =4/16 = 0.2500  (25.00%)
    3 4+3 = 7 =3/16 = 0.1875 (18.75%) =7/16 = 0.4375  (43.75%)
    6 7+6=13 =6/16 = 0.3750 (37.50%) =13/16 = 0.8125  (81.25%)
    3 13+3=16 =3/16 = 0.1875 (18.755%) =16/16 = 1.0000  (100.00%)

     


    1.10 Using the Excel Spreadsheet provided - Frequency Table You Bin is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?