| |

| |

Preface | |

| |

| |

About the Authors | |

| |

| |

| |

Data and Statistics | |

| |

| |

Statistics in Practice: Business Week | |

| |

| |

| |

Applications in Business and Economics | |

| |

| |

Accounting | |

| |

| |

Finance | |

| |

| |

Marketing | |

| |

| |

Production | |

| |

| |

Economics | |

| |

| |

| |

Data | |

| |

| |

Elements, Variables, and Observations | |

| |

| |

Scales of Measurement | |

| |

| |

Qualitative and Quantitative Data | |

| |

| |

Cross-Sectional and Time Series Data | |

| |

| |

| |

Data Sources | |

| |

| |

Existing Sources | |

| |

| |

Statistical Studies | |

| |

| |

Data Acquisition Errors | |

| |

| |

| |

Descriptive Statistics | |

| |

| |

| |

Statistical Inference | |

| |

| |

| |

Statistical Analysis Using Microsoft Excel | |

| |

| |

Data Sets and Excel Worksheets | |

| |

| |

Using Excel for Statistical Analysis | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Supplementary Exercises | |

| |

| |

| |

An Introduction to SWStat+ | |

| |

| |

| |

Descriptive Statistics: Tabular and Graphical Presentations | |

| |

| |

Statistics in Practice: Colgate-Palmolive Company | |

| |

| |

| |

Summarizing Qualitative Data | |

| |

| |

Frequency Distribution | |

| |

| |

Using Excel's COUNTIF Function to Construct a Frequency Distribution | |

| |

| |

Relative Frequency and Percent Frequency Distributions | |

| |

| |

Using Excel to Construct Relative Frequency and Percent Frequency Distributions | |

| |

| |

Bar Graphs and Pie Charts | |

| |

| |

Using Excel's Chart Wizard to Construct Bar Graphs and Pie Charts | |

| |

| |

| |

Summarizing Quantitative Data | |

| |

| |

Frequency Distribution | |

| |

| |

Using Excel's FREQUENCY Function to Construct a Frequency Distribution | |

| |

| |

Relative Frequency and Percent Frequency Distributions | |

| |

| |

Histogram | |

| |

| |

Using Excel's Chart Wizard to Construct a Histogram | |

| |

| |

Cumulative Distributions | |

| |

| |

Using Excel's Histogram Tool to Construct a Frequency Distribution and Histogram | |

| |

| |

| |

Exploratory Data Analysis: The Stem-and-Leaf Display | |

| |

| |

| |

Crosstabulations and Scatter Diagrams | |

| |

| |

Crosstabulation | |

| |

| |

Using Excel's PivotTable Report to Construct a Crosstabulation | |

| |

| |

Simpson's Paradox | |

| |

| |

Scatter Diagram and Trendline | |

| |

| |

Using Excel's Chart Wizard to Construct a Scatter Diagram and a Trendline | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

Case Problem Pelican Stores | |

| |

| |

| |

Descriptive Statistics: Numerical Measures | |

| |

| |

Statistics in Practice: Small Fry Design | |

| |

| |

| |

Measures of Location | |

| |

| |

Mean | |

| |

| |

Median | |

| |

| |

Mode | |

| |

| |

Using Excel to Compute the Mean, Median, and Mode | |

| |

| |

Percentiles | |

| |

| |

Quartiles | |

| |

| |

Using Excel's Rank and Percentile Tool to Compute Percentiles and Quartiles | |

| |

| |

| |

Measures of Variability | |

| |

| |

Range | |

| |

| |

Interquartile Range | |

| |

| |

Variance | |

| |

| |

Standard Deviation | |

| |

| |

Using Excel to Compute the Sample Variance and Sample Standard Deviation | |

| |

| |

Coefficient of Variation | |

| |

| |

Using Excel's Descriptive Statistics Tool | |

| |

| |

| |

Measures of Distribution Shape, Relative Location, and Detecting Outliers | |

| |

| |

Distribution Shape | |

| |

| |

z-Scores | |

| |

| |

Chebyshev's Theorem | |

| |

| |

Empirical Rule | |

| |

| |

Detecting Outliers | |

| |

| |

| |

Exploratory Data Analysis | |

| |

| |

Five-Number Summary | |

| |

| |

Box Plot | |

| |

| |

| |

Measures of Association Between Two Variables | |

| |

| |

Covariance | |

| |

| |

Interpretation of the Covariance | |

| |

| |

Correlation Coefficient | |

| |

| |

Interpretation of the Correlation Coefficient | |

| |

| |

Using Excel to Compute the Covariance and Correlation Coefficient | |

| |

| |

| |

The Weighted Mean and Working with Grouped Data | |

| |

| |

Weighted Mean | |

| |

| |

Grouped Data | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

| |

Pelican Stores | |

| |

| |

| |

National Health Care Association | |

| |

| |

| |

Business Schools of Asia-Pacific | |

| |

| |

| |

Constructing a Box Plot Using SWStat+ | |

| |

| |

| |

Introduction to Probability | |

| |

| |

Statistics in Practice: Morton International | |

| |

| |

| |

Experiments, Counting Rules, and Assigning Probabilities | |

| |

| |

Counting Rules, Combinations, and Permutations | |

| |

| |

Assigning Probabilities | |

| |

| |

Probabilities for the KP&L Project | |

| |

| |

| |

Events and Their Probabilities | |

| |

| |

| |

Some Basic Relationships of Probability | |

| |

| |

Complement of an Event | |

| |

| |

Addition Law | |

| |

| |

| |

Conditional Probability | |

| |

| |

Independent Events | |

| |

| |

Multiplication Law | |

| |

| |

| |

Bayes' Theorem | |

| |

| |

Tabular Approach | |

| |

| |

Using Excel to Compute Posterior Probabilities | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

Case Problem Hamilton County Judges | |

| |

| |

| |

Discrete Probability Distributions | |

| |

| |

Statistics in Practice: Citibank | |

| |

| |

| |

Random Variables | |

| |

| |

Discrete Random Variables | |

| |

| |

Continuous Random Variables | |

| |

| |

| |

Discrete Probability Distributions | |

| |

| |

| |

Expected Value and Variance | |

| |

| |

Expected Value | |

| |

| |

Variance | |

| |

| |

Using Excel to Compute the Expected Value, Variance, and Standard Deviation | |

| |

| |

| |

Binomial Probability Distribution | |

| |

| |

A Binomial Experiment | |

| |

| |

Martin Clothing Store Problem | |

| |

| |

Using Excel to Compute Binomial Probabilities | |

| |

| |

Expected Value and Variance for the Binomial Probability Distribution | |

| |

| |

| |

Poisson Probability Distribution | |

| |

| |

An Example Involving Time Intervals | |

| |

| |

An Example Involving Length or Distance Intervals | |

| |

| |

Using Excel to Compute Poisson Probabilities | |

| |

| |

| |

Hypergeometric Probability Distribution | |

| |

| |

Using Excel to Compute Hypergeometric Probabilities | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

| |

Continuous Probability Distributions | |

| |

| |

Statistics in Practice: Procter & Gamble | |

| |

| |

| |

Uniform Probability Distribution | |

| |

| |

Area as a Measure of Probability | |

| |

| |

| |

Normal Probability Distribution | |

| |

| |

Normal Curve | |

| |

| |

Standard Normal Probability Distrbution | |

| |

| |

Computing Probabilities for Any Normal Probability Distribution | |

| |

| |

Grear Tire Company Problem | |

| |

| |

Using Excel to Compute Normal Probabilities | |

| |

| |

| |

Exponential Probability Distribution | |

| |

| |

Computing Probabilities for the Exponential Distribution | |

| |

| |

Relationship Between the Poisson and Exponential Distributions | |

| |

| |

Using Excel to Compute Exponential Probabilities | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

Case Problem Specialty Toys | |

| |

| |

| |

Sampling and Sampling Distributions | |

| |

| |

Statistics in Practice: MeadWestvaco Corporation | |

| |

| |

| |

The Electronics Associates Sampling Problem | |

| |

| |

| |

Simple Random Sampling | |

| |

| |

Sampling from a Finite Population | |

| |

| |

Sampling from an Infinite Population | |

| |

| |

| |

Point Estimation | |

| |

| |

| |

Introduction to Sampling Distributions | |

| |

| |

| |

Sampling Distribution of x | |

| |

| |

Expected Value of x | |

| |

| |

Standard Deviation of x | |

| |

| |

Form of the Sampling Distribution of x | |

| |

| |

Sampling Distribution of x for the EAI Problem | |

| |

| |

Practical Value of the Sampling Distribution of x | |

| |

| |

Relationship Between Sample Size and the Sampling Distribution of x | |

| |

| |

| |

Sampling Distribution of p | |

| |

| |

Expected Value of p | |

| |

| |

Standard Deviation of p | |

| |

| |

Form of the Sampling Distribution of p | |

| |

| |

Practical Value of the Sampling Distribution of p | |

| |

| |

| |

Sampling Methods | |

| |

| |

Stratified Random Sampling | |

| |

| |

Cluster Sampling | |

| |

| |

Systematic Sampling | |

| |

| |

Convenience Sampling | |

| |

| |

Judgment Sampling | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

| |

Interval Estimation | |

| |

| |

Statistics in Practice: Food Lion | |

| |

| |

| |

Population Mean: [sigma] Known | |

| |

| |

Margin of Error and the Interval Estimate | |

| |

| |

Using Excel | |

| |

| |

Practical Advice | |

| |

| |

| |

Population Mean: [sigma] Unknown | |

| |

| |

Margin of Error and the Interval Estimate | |

| |

| |

Using Excel | |

| |

| |

Practical Advice | |

| |

| |

Using a Small Sample | |

| |

| |

Summary of Interval Estimation Procedures | |

| |

| |

| |

Determining the Sample Size | |

| |

| |

| |

Population Proportion | |

| |

| |

Using Excel | |

| |

| |

Determining the Sample Size | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

| |

Bock Investment Services | |

| |

| |

| |

Gulf Real Estate Properties | |

| |

| |

| |

Metropolitan Research, Inc. | |

| |

| |

| |

Hypothesis Tests | |

| |

| |

Statistics in Practice: John Morrell & Company | |

| |

| |

| |

Developing Null and Alternative Hypotheses | |

| |

| |

Testing Research Hypotheses | |

| |

| |

Testing the Validity of a Claim | |

| |

| |

Testing in Decision-Making Situations | |

| |

| |

Summary of Forms for Null and Alternative Hypotheses | |

| |

| |

| |

Type I and Type II Errors | |

| |

| |

| |

Population Mean: [sigma] Known | |

| |

| |

One-Tailed Test | |

| |

| |

Two-Tailed Test | |

| |

| |

Using Excel | |

| |

| |

Summary and Practical Advice | |

| |

| |

Relationship Between Interval Estimation and Hypothesis Testing | |

| |

| |

| |

Population Mean: [sigma] Unknown | |

| |

| |

One-Tailed Test | |

| |

| |

Two-Tailed Test | |

| |

| |

Using Excel | |

| |

| |

Summary and Practical Advice | |

| |

| |

| |

Population Proportion | |

| |

| |

Using Excel | |

| |

| |

Summary | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

| |

Quality Associates, Inc. | |

| |

| |

| |

Unemployment Study | |

| |

| |

| |

Comparisons Involving Means | |

| |

| |

Statistics in Practice: Fisons Corporation | |

| |

| |

| |

Inferences About the Difference Between Two Population Means: [sigma subscript 1] and [sigma subscript 2] Known | |

| |

| |

Interval Estimation of [mu subscript 1] - [mu subscript 2] | |

| |

| |

Using Excel to Construct a Confidence Interval | |

| |

| |

Hypothesis Tests About [mu subscript 1] - [mu subscript 2] | |

| |

| |

Using Excel to Conduct a Hypothesis Test | |

| |

| |

Practical Advice | |

| |

| |

| |

Inferences About the Difference Between Two Population Means: [sigma subscript 1] and [sigma subscript 2] Unknown | |

| |

| |

Interval Estimation of [mu subscript 1] - [mu subscript 2] | |

| |

| |

Using Excel to Construct a Confidence Interval | |

| |

| |

Hypothesis Tests About [mu subscript 1] - [mu subscript 2] | |

| |

| |

Using Excel to Conduct a Hypothesis Test | |

| |

| |

Practical Advice | |

| |

| |

| |

Inferences About the Difference Between Two Population Means: Matched Samples | |

| |

| |

Using Excel to Conduct a Hypothesis Test | |

| |

| |

| |

Introduction to Analysis of Variance | |

| |

| |

Assumptions for Analysis of Variance | |

| |

| |

Conceptual Overview | |

| |

| |

| |

Analysis of Variance: Testing for the Equality of k Population Means | |

| |

| |

Between-Treatments Estimate of Population Variance | |

| |

| |

Within-Treatments Estimate of Population Variance | |

| |

| |

Comparing the Variance Estimates: The F Test | |

| |

| |

ANOVA Table | |

| |

| |

Using Excel | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

| |

Par, Inc. | |

| |

| |

| |

Wentworth Medical Center | |

| |

| |

| |

Compensation for ID Professionals | |

| |

| |

| |

Comparisons Involving Proportions and a Test of Independence | |

| |

| |

Statistics in Practice: United Way | |

| |

| |

| |

Inferences About the Difference Between Two Population Proportions | |

| |

| |

Interval Estimation of p[subscript 1] - p[subscript 2] | |

| |

| |

Using Excel to Construct a Confidence Interval | |

| |

| |

Hypothesis Tests About p[subscript 1] - p[subscript 2] | |

| |

| |

Using Excel to Conduct a Hypothesis Test | |

| |

| |

| |

Hypothesis Test for Proportions of a Multinomial Population | |

| |

| |

Using Excel to Conduct a Goodness of Fit Test | |

| |

| |

| |

Test of Independence | |

| |

| |

Using Excel to Conduct a Test of Independence | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

Case Problem A Bipartisan Agenda for Change | |

| |

| |

| |

Simple Linear Regression | |

| |

| |

Statistics in Practice: Alliance Data Systems | |

| |

| |

| |

Simple Linear Regression Model | |

| |

| |

Regression Model and Regression Equation | |

| |

| |

Estimated Regression Equation | |

| |

| |

| |

Least Squares Method | |

| |

| |

Using Excel to Develop a Scatter Diagram and Compute the Estimated Regression Equation | |

| |

| |

| |

Coefficient of Determination | |

| |

| |

Using Excel to Compute the Coefficient of Determination | |

| |

| |

Correlation Coefficient | |

| |

| |

| |

Model Assumptions | |

| |

| |

| |

Testing for Significance | |

| |

| |

Estimate of [sigma superscript 2] | |

| |

| |

t Test | |

| |

| |

Confidence Interval for [beta subscript 1] | |

| |

| |

F Test | |

| |

| |

Some Cautions About the Interpretation of Significance Tests | |

| |

| |

| |

Excel's Regression Tool | |

| |

| |

Using Excel's Regression Tool for the Armand's Pizza Parlors Problem | |

| |

| |

Interpretation of Estimated Regression Equation Output | |

| |

| |

Interpretation of ANOVA Output | |

| |

| |

Interpretation of Regression Statistics Output | |

| |

| |

| |

Using the Estimated Regression Equation for Estimation and Prediction | |

| |

| |

Point Estimation | |

| |

| |

Interval Estimation | |

| |

| |

Confidence Interval Estimate of the Mean Value of y | |

| |

| |

Prediction Interval Estimate of an Individual Value of y | |

| |

| |

Using Excel to Develop Confidence and Prediction Interval Estimates | |

| |

| |

| |

Residual Analysis: Validating Model Assumptions | |

| |

| |

Residual Plot Against x | |

| |

| |

Residual Plot Against y | |

| |

| |

Using Excel's Regression Tool to Construct a Residual Plot | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

| |

Spending and Student Achievement | |

| |

| |

| |

U.S. Department of Transportation | |

| |

| |

| |

Alumni Giving | |

| |

| |

| |

Major League Baseball Teams Values | |

| |

| |

| |

Regression Analysis with SWStat+ | |

| |

| |

| |

Multiple Regression | |

| |

| |

Statistics in Practice: International Paper | |

| |

| |

| |

Multiple Regression Model | |

| |

| |

Regression Model and Regression Equation | |

| |

| |

Estimated Multiple Regression Equation | |

| |

| |

| |

Least Squares Method | |

| |

| |

An Example: Butler Trucking Company | |

| |

| |

Using Excel's Regression Tool to Develop the Estimated Multiple Regression Equation | |

| |

| |

Note on Interpretation of Coefficients | |

| |

| |

| |

Multiple Coefficient of Determination | |

| |

| |

| |

Model Assumptions | |

| |

| |

| |

Testing for Significance | |

| |

| |

F Test | |

| |

| |

t Test | |

| |

| |

Multicollinearity | |

| |

| |

| |

Using the Estimated Regression Equation for Estimation and Prediction | |

| |

| |

| |

Qualitative Independent Variables | |

| |

| |

An Example: Johnson Filtration, Inc. | |

| |

| |

Interpreting the Parameters | |

| |

| |

More Complex Qualitative Variables | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

| |

Consumer Research, Inc. | |

| |

| |

| |

Predicting Student Proficiency Test Scores | |

| |

| |

| |

Alumni Giving | |

| |

| |

| |

Multiple Regression Analysis with SWStat+ | |

| |

| |

| |

Statistical Methods for Quality Control | |

| |

| |

Statistics in Practice: Dow Chemical | |

| |

| |

| |

Philosophies and Frameworks | |

| |

| |

Malcolm Baldrige National Quality Award | |

| |

| |

ISO 9000 | |

| |

| |

Six Sigma | |

| |

| |

| |

Statistical Process Control | |

| |

| |

Control Charts | |

| |

| |

x Chart: Process Mean and Standard Deviation Known | |

| |

| |

x Chart: Process Mean and Standard Deviation Unknown | |

| |

| |

R Chart | |

| |

| |

Using Excel to Construct an R Chart and an x Chart | |

| |

| |

p Chart | |

| |

| |

np Chart | |

| |

| |

Interpretation of Control Charts | |

| |

| |

| |

Acceptance Sampling | |

| |

| |

KALI, Inc.: An Example of Acceptance Sampling | |

| |

| |

Computing the Probability of Accepting a Lot | |

| |

| |

Selecting an Acceptance Sampling Plan | |

| |

| |

Multiple Sampling Plans | |

| |

| |

Summary | |

| |

| |

Glossary | |

| |

| |

Key Formulas | |

| |

| |

Supplementary Exercises | |

| |

| |

| |

References and Bibliography | |

| |

| |

| |

Tables | |

| |

| |

| |

Summation Notation | |

| |

| |

| |

Self-Test Solutions and Answers to Even-Numbered Exercises | |

| |

| |

| |

Using Excel Functions | |

| |

| |

Index | |