Skip to main content
Statistics LibreTexts

1.20 Installing the Data Analysis Tool for Excel

  1. Last updated
  2. Save as PDF
  • Page ID
    20156

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

    To use the Data Analysis Tool to create a Frequency table and Histogram, it must be installed in a Desktop version of Excel.  Google Chrome book or Excel online version does not have the option to install the Data Analysis Tool Pak.  

     

    Windows Operating System 

    First, click the Data tab on the main menu.  Look to the right, and if you do not see Data Analysis, you must install it.

    This screenshot is of the Excel Data Tab Menu. Look to the far-right; there is no Data Analysis option.

    To install the data analysis tool pack, click on the File option on the main menu. Then select Options.

    This screenshot is what you will see after selecting File then Options from the menu.

    When the dialog box appears, click on Add-ins.

    This screenshot is of the dialog box that will appear when you select Options. Click on the Add-In options to see this screen.

      
    At the bottom of the dialog box, you will see a GO button. Click on it.  Select the options Analysis ToolPak and Analysis ToolPak - VBA, then click the OK button.

    clipboard_e63b71a1e6450634da19cef6a47b62d60.png


    Now click on the Data tab to see if the Data Analysis tool is installed.


    After installing the Data Analysis TookPak, Data Analysis will appear on the far-right-hand side of the Data Tab menu.

    Video - Windows Operation System

    Video on how to install the Data Analysis ToolPak on a Windows operating system.

    Mac OS

    1.20 Installing the Data Analysis Tool for Excel is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.