Excel Statistics: A Quick Guide, 2nd Edition

Use real data, and become a pro at using Excel for statistical analysis!

Designed for users already familiar with Excel and basic computer operations, this Second Edition of Neil J. Salkind’s Excel Statistics: A Quick Guide shows readers how to utilize the features of Microsoft® Excel to answer both simple and complex questions about data analysis. Part I explores thirty-five Excel functions while Part II of the text contains fifteen Analysis Toolpak tools. The description and use of each function and tool appear on one page with corresponding screen shots of the element in action on the facing page, allowing the user to see what each function or tool looks like as it is being applied. The actual data files used in the examples are also available to readers. Excel novices and experts alike will find this text not only practical but also easy to use and engaging.

Table of Contents

PART I. USING EXCEL FUNCTIONS
Chapter 1.Computing Averages
Chapter 2.Looking at Variability
Chapter 3.Describing Data
Chapter 4.Looking at Relationships
Chapter 5.Testing Independence
Chapter 6.Testing Significance
Chapter 7.Looking at Data

PART II. USING THE ANALYSIS TOOLPAK
Chapter 8.Describing Data
Chapter 9.Comparing Means
Chapter 10.Looking at Relationships
Chapter 11.Illustrating Data

Appendix A. Answers to QuickGuide Questions
Appendix B. Using the Macintosh Excel Formula Builder