CHAPTER 2
EXCEL AS A STATISTICAL TOOL
LEARNING OBJECTIVES
• Understand and use the basic functions of an Excel spreadsheet
• Understand and create a graph in Excel
• Understand and perform data and data string sorting and frequency calculation functions
• Understand the functions associated with Excel’s Data Analysis Pack and understand when the Data Analysis Pack should be “added in”
• Understand Excel’s dollar sign ($) convention and its use
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 ...
Get Statistics for Health Care Professionals: Working With Excel, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
