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 2Excel as a Statistical Tool

Many people have used Microsoft Excel spreadsheets for financial management, for budget keeping, or for maintaining lists, but not as a statistical tool. Excel has powerful statistical capabilities, and this book uses these statistical capabilities for examples and for problem sets. But to ensure that the user will have some facility with Excel from the outset, this chapter provides a basic introduction to most of what Excel can and will do as a statistical tool. Readers who are already comfortable with the use of Excel might skip Sections 2.1 and 2.2. However, anyone not currently carrying out statistical applications with Excel is likely to benefit from the material in the later sections of the chapter.

2.1 The Basics

Excel is a spreadsheet application. This means that it is made up of columns that are designated by letters (A through XFD) and of rows that are designated by numbers (1 through 1,048,576). There are 16,384 columns and 1,048,576 rows in Excel 2013. Figure 2.1 shows the initial view of an Excel spreadsheet. The intersection ...

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