O'Reilly logo

Statistics for Health Care Management and Administration by David A. Rosenthal, John F. Kros

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

Chapter 4Data Display: Descriptive Presentation, Excel Graphing Capability

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.

4.1 Creating, Displaying, and Understanding Frequency Distributions

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

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