Skip to main content
Mathematics LibreTexts

6.3: Introduction to Statistical Calculations using Microsoft EXCEL

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

    Example \(\PageIndex{1}\): In Class project.

    We will collect the data in class.

    Instructions:

    1. Open a new Excel worksheet and save as Lab1.xls – I’d like the finished version submitted to the Blackboard site digital drop box. Put your name (first and last) in Cell A1. If you choose to work with a partner put the second name in Cell A2 and only submit one worksheet between you.

    Use the appropriate decimals button to reduce all answers to at most 3 decimals. Save often!

    Use Excel functions to calculate:

    1. The mean
    2. The median
    3. The mode, Explain your mode answer!
    4. The standard deviation
    5. The range
    6. The interquartile numbers
    7. The Five number summary.

    The functions you’ll need are the average( cell range), median (cell range), mode (cell range), max(cell range), min(cell range), stdev(cell range), Quartile (cell range, quartile number). Try using the function button to access the functions instead of typing them out.

    There is an easier way to get the above information and more!

    1. Go to the file Button (top left hand corner), Excel Options, Add-Ins. Select the Data Analysis Tool Pack and add it in!
    • Highlight the data from Question 1.
    • Under Data select data analysis, descriptive statistics. Enter the data cell range and for input just put a cell where you want the top line to appear. Check the box for summary statistics and hit enter!
    1. To draw box plot: calculate the
      statistical functions QUARTILE(q1), MIN, MEDIAN, MAX and QUARTILE(q3)
      in that order for each data set. Arrange the results on an Excel
      worksheet.

    This page titled 6.3: Introduction to Statistical Calculations using Microsoft EXCEL is shared under a CC BY-NC-SA license and was authored, remixed, and/or curated by Pamini Thangarajah.