Data Analysis with Microsoft Excel: Updated for Office 2007

...

Data Analysis with Microsoft ® Excel Updated for Offi ce 2007® Kenneth N. Berk Illinois State University Patrick Carey Carey Ass ...

© 2010, 2004 Brooks/Cole, Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be repr ...

About the Authors Kenneth N. Berk Kenneth N. Berk (Ph.D., University of Minnesota) is an emeritus professor of mathematics at Il ...

Preface Introduction Data Analysis with Microsoft® Excel: Updated for Offi ce 2007® harnesses the power of Excel and transforms ...

As spreadsheets have expanded in power and ease of use, there has been increased interest in using them in the classroom. There ...

Excel’s Statistical Tools Excel comes with 81 statistical functions and 59 mathematical functions. There are also functions devo ...

Preface vii Create statistical charts including boxplots, histograms, and normal probability plots Create quality control charts ...

Acknowledgments We thank Mac Mendelsohn, Managing Editor at Course Technology, for his support and enthusiasm for the First Edit ...

ix ...

...

...

Chapter Contents GETTING STARTED WITH EXCEL Getting Started Special Files for This Book Installing the StatPlus Files Excel a ...

1 Chapter 1 GETTING STARTED WITH EXCEL Objectives In this chapter you will learn to: Install StatPlus fi les Start Excel and rec ...

2 Excel I n this chapter you’ll learn how to work with Excel 2007 in the Windows operating system. You’ll be introduced to basic ...

Chapter 1 Getting Started with Excel 3 To run the installation routine: 1 On the companion website click on the StatPlus link un ...

4 Excel Excel and Spreadsheets Excel is a software program designed to help you evaluate and present infor- mation in a spreadsh ...

Chapter 1 Getting Started with Excel 5 Launching Excel When Excel 2007 is installed on your computer, the installation program a ...

6 Excel Viewing the Excel Window The Excel window shown in Figure 1-5 is the environment in which you’ll analyze the data sets u ...

Chapter 1 Getting Started with Excel 7 Running Excel Commands You can run an Excel command either by clicking the icons found on ...