O'Reilly logo

The Complete Idiot's Guide to Statistics, 2nd Edition by Robert Donnelly

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Excel to Calculate Central Tendency

Excel will kindly calculate the mean, median, and mode for you all at once with a few mouse clicks. Let’s demonstrate this using the data set from the video game example.
1. To begin, open a blank Excel worksheet and enter the video game data (Figure 4.1).
2. Click on the Tools menu at the top of the spreadsheet (between Format and Data) and select Data Analysis. (See the section “Installing the Data Analysis Add-in” in Chapter 2 for more details on this step if you don’t see the Data Analysis command.) After selecting Data Analysis, you should see the dialog box shown in Figure 4.2.
082
Figure 4.1 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required