Skip to main content
Statistics LibreTexts

1.11 Using Excel Spreadsheet Provided - Frequency Table

  • Page ID
    20153
  • \( \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

    To download the Excel Workbook click on the link below.

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

    Click on the Frequency Table tab in the Excel spreadsheet provided.  Scroll to the left to see cell A1.  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

    The spreadsheet will calculate part of the frequency table.  You are to complete the table based on the definition of each part.  You will enter values in the blue cells.

    The start cell, D9, should be the same as the ending cell value for class one.  Similarly, cell D11 is the same as the ending cell value for class four, provided there is a value in cell C11.

    The cumulative frequency value in cell G8 is the starting value.  It is the same as cell F8.  The value in cell G11 is the sum of cell G10 and F11, provided there is a value in cell C11. 

    The relative frequency value is the frequency divided by the total frequency in cell F16.  For cell H9, divide the frequency in cell F9 by the total frequency in cell F16.  For example, if the frequency is seven, then the relative frequency is =7/25. 

    The cumulative relative frequency (Cum Rel Freq) is the cumulative frequency divided by the total frequency.  For example, if the cumulative frequency is three, then the cumulative relative frequency is =3/25.

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

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