## Description

Statistics for Managers Using Microsoft Excel / Edition 7 by David M. Levine EBOOK PDF Instant Download

Table of Contents

Introduction and Data Collection

Why a Manager Needs to Know About Statistics

The Growth and Development of Modern Statistics

What Every Manager Needs to Know About Using Electronic Worksheets

What You Need to Know About Using the Software for This Textbook

Why Are Data Needed

Sources of Data

Types of Data

Types of Sampling Methods

Evaluating Survey Worthiness

Excel Primer

Working with Windows and Microsoft Excel

Common Workbook Operations

Basic Worksheet Concepts and Operations

Enhancing Worksheet Appearance

Using Microsoft Excel Wizards

Using Add-Ins

Presenting Data in Tables and Charts

Organizing Numerical Data

Tables and Charts for Numerical Data

Graphing Bivariate Numerical Data

Tables and Charts for Categorical Data

Tabulating and Graphing Bivariate Categorical Data

Graphical Excellence

Numerical Descriptive Measures

Exploring Numerical Data and Their Properties

Measures of Central Tendency, Variation, and Shape

Exploratory Data Analysis

Obtaining Descriptive Summary Measures from a Population

The Coefficient of Correlation

Pitfalls in Numerical Descriptive Measures and Ethical Issues

Basic Probability and Discrete Probability Distribution

Basic Probability Concepts

Conditional Probability

Bayes’ Theorem

The Probability Distribution for a Discrete Random Variable

Covariance and Its Application in Finance

Binomial Distribution

Poisson Distribution

Hypergeometric Distribution

Ethical Issues and Probability

The Normal Distribution and Sampling Distributions

The Normal Distribution

Evaluating the Normality Assumption

The Exponential Distribution

Introduction to Sampling Distributions

Sampling Distribution of the Mean

Sampling Distribution of the Proportion

Sampling from Finite Populations (CD-ROM Topic)

Confidence Interval Estimation

Confidence Interval Estimation of the Mean ([sigma] Known)

Confidence Interval Estimation of the Mean ([sigma] Unknown)

Confidence Interval Estimation for the Proportion

Determining Sample Size

Applications of Confidence Interval Estimation in Auditing

Confidence Interval Estimation and Ethical Issues

Estimation and Sample Size Determination for Finite Populations (CD-ROM Topic)

Fundamentals of Hypothesis Testing: One-Sample Tests

Hypothesis-Testing Methodology

Z Test of Hypothesis for the Mean ([sigma] Known)

One-Tail Tests

tTest of Hypothesis for the Mean ([sigma] Unknown)

Z Test of Hypothesis for the Proportion

Potential Hypothesis-Testing Pitfalls and Ethical Issues

Two-Sample Tests with Numerical Data

Comparing Two Independent Samples: t Tests for Differences Between Two Means

F Test for Differences Between Two Variances

Comparing Two Related Samples: t Test for the Mean Difference

Wilcoxon Rank Sum Test for Differences Between Two Medians

Analysis of Variance

The Completely Randomized Design: One-Way Analysis of Variance

The Two-Factor Factorial Design: Two-Way Analysis of Variance

The Kruskal-Wallis Rank Test for Differences Between Medians

Tests for Two or More Samples with Categorical Data

Z Test for the Difference Between Two Proportions

x[superscript 2] Test for the Difference Between Two Proportions

x[superscript 2] Test for Differences Between More Than Two Proportions

x[superscript 2] Test of Independence

Simple Linear Regression

Types of Regression Models

Determining the Simple Linear Regression Equation

Measures of Variation

Assumptions

Residual Analysis

Measuring Autocorrelation: The Durbin-Watson Statistic

Inferences About the Slope and Correlation Coefficient

Estimation of Mean and Prediction of Individual Values

Pitfalls in Regression and Ethical Issues

Computations in Simple Linear Regression

Multiple Regression

Developing the Multiple Regression Model

Residual Analysis for the Multiple Regression Model

Testing for the Significance of the Multiple Regression Model

Inferences Concerning the Population Regression Coefficients

Testing Portions of the Multiple Regression Model

The Quadratic Regression Model

Dummy Variable Models

Using Transformations in Regression Models

Collinearity

Model Building

Pitfalls in Multiple Regression and Ethical Issues

Time-Series Analysis

The Importance of Business Forecasting

Component Factors of the Classical Multiplicative Time-Series Model

Smoothing the Annual Time Series

Least-Squares Trend Fitting and Forecasting

Autoregressive Modeling for Trend Fitting and Forecasting

Choosing an Appropriate Forecasting Model

Time-Series Forecasting of Monthly or Quarterly Data

Pitfalls Concerning Time-Series Analysis

Index Numbers (CD-ROM Topic)

Decision Making

The Payoff Table and Decision Trees

Criteria for Decision Making

Decision Making with Sample Information

Utility

Statistical Applications in Quality and Productivity Management

Quality and Productivity: A Historical Perspective

Deming’s 14 Points: A Theory of Management

The Theory of Control Charts

Control Charts for the Proportion of Nonconforming Items: p Charts

The Red Bead Experiment: Understanding Process Variability

Control Charts for the Range and the Mean

Process Capability

Answers to Selected Problems

Appendices

Review of Arithmetic, Algebra, and Logarithms

Summation Notation

Statistical Symbols and the Greek Alphabet

CD-ROM Contents

Tables

Microsoft Excel Configuration and Customization

More About PHStat2

Index

CD-ROM Topics

Sampling from Finite Populations

Estimation and Sample Size Determination for Finite Populations

Index Numbers