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