Statistics for Managers Using Microsoft Excel

by Levine, David M.; Berenson, Mark L.; Krehbiel, Timothy C.; Stephan, David F.

• ISBN13: 9780132295451
• ISBN10: 0132295458
• Edition: 6th
• Format: Paperback
• Copyright: 2011-01-01
• Publisher: Prentice Hall

Summary

This book was the first to thoroughly integrate the use of Microsoft Excel as a tool for statistical analysis.The book focuses on the concepts of statistics with applications to the functional areas of business. It is rich in applications from accounting, finance, marketing, management and economics, covering data collection, tables and charts, probability, estimation, and more.For professionals, particularly managers, making financial analyses and decisions.

Table of Contents

Preface

Introduction and Data Collection

Presenting Data in Tables and Charts

Numerical Descriptive Measures

Basic Probability

Some Important Discrete Probability Distributions

The Normal Distribution and Other Continuous Distributions

Sampling and Sampling Distributions

Confidence Interval Estimation

Fundamentals of Hypothesis Testing: One-Sample Tests

Two-Sample Tests

Analysis of Variance

Chi-Square Tests and Nonparametric Tests

Simple Linear Regression

Introduction to Multiple Regression

Multiple Regression Model Building

Time-Series Forecasting and Index Numbers

Decision Making

Statistical Applications in Quality Management

Appendices

Review of Arithmetic, Algebra, and Logarithms

Summation Notation

Statistical Symbols and Greek Alphabet

CD-ROM Contents

Tables

Configuring Microsoft Excel and Installing PHStat

Self-Test Solutions and Answers to Selected Even-Numbered Problems

Index

CD-ROM Topics

Counting Rules

Using the Poisson Distribution to Approximate the Binomial Distribution

The Normal Approximation to the Binomial Distribution

Sampling from Finite Populations

Estimation and Sample Size Determination for Finite Populations

The Power of a Test

The Randomized Block Design

Chi-Square Test for a Variance or Standard Deviation

Table of Contents provided by Publisher. All Rights Reserved.