One of the most important aspects of statistical analysis is to be able to present your results in a way that is easily accessible to your audience. Microsoft Excel provides several useful tools to create accessible presentations. These include, in particular, the Excel frequency function, the Excel pivot table report capabilities, and the Excel graphing capability.
One recurring need in statistical analysis is the need to be able to summarize quickly and efficiently the data that are under analysis. Later sections of the book, particularly Chapter 6, discuss measures of central tendency and dispersion (the mean and the standard deviation). Mean and standard deviation are useful devices for summarizing numerical data. This section discusses the Excel
=FREQUENCY() function that was introduced in Chapter 2.
Recall the data file that was imported to Excel in Chapter 3. When the import process was finished, that file contained an ID number for each record and nine variables. The variables were Sex (as indicated by “F” and “M”), Sex (the