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.
Figure 4.1 ...