2022 Introduction to Statistics in Research Mitchell 2nd ed

I N T R O T O R E S E A R C H : D A T A V I S U A L I Z A T I O N & C O M M O N S T A T T E S T S

Watch the video: Descriptive Statistics in Excel.

Mitchell, J. (2020, Mar 30), Descriptive Statistics in Excel. [Video]. YouTube. Available from https://youtu.be/-sWy5Z_wHSk

Descriptive Statistics ADD the Analysis Toolpak in Excel Before we can do anything with statistics in Excel, we need to add the Analysis Toolpak as an add-in to Excel. Here are the steps to add it.

Add the Analysis Toolpak to your PC

To generate descriptive statistics in Excel you first need to make sure you add the Analysis Toolpak (and solver) in Excel. Macs have access to these tools, but the steps below are for a PC.

1. Click the File tab, click Options , and then click the Add-ins category 2. In the Manage box, select Excel Add-ins and then Go. 3. In the Add-ins box, check the Analysis ToolPak check box, and then OK. 4. Select all the tools. 5. Once you have this added, it should appear on your ribbon. 6. If you open the Data Analysis tools, you will be amazed at the number of tools packed into Excel!

Table 69: Tools available for Data Analysis in Excel

82