Statistics for Managers Using Microsoft Excel

This hallmark text was the first to thoroughly integrate the use of Microsoft Excel and still provides more Excel coverage than any other textbook. The streamlined coverage (15 chapters) focuses on the concepts of statistics with applications to the functional areas of business. It is rich with applications from accounting, finance, marketing, management and economics. There is significant emphasis on using statistical software as a tool, with most examples presented in a spreadsheet environment. This is the #1 best-selling business statistics text!

Features

• NEW—Excel coverage—The major thrust of this revision was to streamline the coverage of Excel, and make it less intrusive. Excel output and concise coverage of Excel is now seamlessly integrated into the chapter itself.
• Allows students to quickly generate results using PHStat and Microsoft Excel.
• NEW—Detailed coverage of Excel—Detailed instructions have been moved to new reference sections called the Excel Handbook located at the end of each chapter.
• Enables users to develop their own workbook solutions to statistical problems from scratch.
• NEW—Motivating applications—Each chapter begins with a Using Statistics example that shows how statistics can be used in one of the functional areas of business—accounting, finance, management or marketing. Each scenario is revisited throughout the chapter to provide an applied context for the topics presented. The Using Statistics applications are updated and enhanced from the last edition.
• Provides a frame of reference for business students.
• NEW—Real data from the Wall Street Journal, USA Today, and other sources—Added to numerous exercises.
• Provides additional reinforcement of the relevance of statistical methods in business.
• NEW—Report Writing Exercises and Internet Exercises—Located in the chapter review problems.
• Helps students hone their critical thinking skills.

• 1. Introduction and Data Collection Excel Primer.
• 2. Presenting Data in Tables and Charts.
• 3. Numerical Descriptive Measures.
• 4. Basic Probability and Discrete Probability Distributions.
• 5. The Normal Distribution and Sampling Distributions.
• 6. Confidence Interval Estimation.
• 7. Hypothesis Testing: One Sample Tests.
• 8. Two Sample Tests with Numerical Data.
• 9. Analysis of Variance.
• 10. Tests for Two or More Samples with Categorical Data.
• 11. Simple Linear Regression.
• 12. Multiple Regression.
• 13. Time-Series Analysis.
• 14. Decision Making.
• 15. Statistical Applications in Quality and Productivity Management.