BOOK
Statistics for Managers Using Microsoft Excel, Global Edition
David M. Levine | David F. Stephan | Kathryn A. Szabat
(2016)
Additional Information
Book Details
Abstract
For undergraduate business statistics courses.
Analyzing the Data Applicable to Business
This text is the gold standard for learning how to use Microsoft Excel® in business statistics, helping students gain the understanding they need to be successful in their careers. The authors present statistics in the context of specific business fields; full chapters on business analytics further prepare students for success in their professions. Current data throughout the text lets students practice analyzing the types of data they will see in their professions. The friendly writing style include tips throughout to encourage learning.
The book also integrates PHStat, an add-in that bolsters the statistical functions of Excel.
MyStatLab™ not included. Students, if MyStatLab is a recommended/mandatory component of the course, please ask your instructor for the correct ISBN and course ID. MyStatLab should only be purchased when required by an instructor.
Table of Contents
Section Title | Page | Action | Price |
---|---|---|---|
Cover | Cover | ||
A Roadmap for Selectinga Statistical Method | 1 | ||
Title Page | 3 | ||
Copyright Page | 4 | ||
About the Authors | 6 | ||
Brief Contents | 7 | ||
Contents | 8 | ||
Preface | 17 | ||
Resources for Success | 23 | ||
First Things First | 25 | ||
Using Statistics: “The Price of Admission” | 25 | ||
Now Appearing on Broadway . . . and Everywhere Else | 26 | ||
FTF.1 Think Differently About Statistics | 26 | ||
Statistics: A Way of Thinking | 26 | ||
Analytical Skills More Important than Arithmetic Skills | 27 | ||
Statistics: An Important Part of Your Business Education | 27 | ||
FTF.2 Business Analytics: The Changing Face of Statistics | 28 | ||
“Big Data” | 28 | ||
Structured Versus Unstructured Data | 28 | ||
FTF.3 Getting Started Learning Statistics | 29 | ||
Statistic | 29 | ||
Can Statistics (pl., Statistic) Lie? | 30 | ||
FTF.4 Preparing to Use Microsoft Excel for Statistics | 30 | ||
Reusability Through Recalculation | 31 | ||
Practical Matters: Skills You Need | 31 | ||
Ways of Working with Excel | 31 | ||
Excel Guides | 32 | ||
Which Excel Version to Use? | 32 | ||
Conventions Used | 32 | ||
References | 33 | ||
Key Terms | 33 | ||
Excel Guide | 34 | ||
EG.1 Entering Data | 34 | ||
EG.2 Reviewing Worksheets | 34 | ||
EG.3 If You Plan to Use the Workbook Instructions | 35 | ||
1 Defining and Collecting Data | 36 | ||
Using Statistics: Defining Moments | 36 | ||
1.1 Defining Variables | 37 | ||
Classifying Variables by Type | 38 | ||
Measurement Scales | 38 | ||
1.2 Collecting Data | 39 | ||
Populations and Samples | 40 | ||
Data Sources | 40 | ||
1.3 Types of Sampling Methods | 41 | ||
Simple Random Sample | 42 | ||
Systematic Sample | 42 | ||
Stratified Sample | 43 | ||
Cluster Sample | 43 | ||
1.4 Data Preparation | 44 | ||
Data Cleaning | 44 | ||
Data Formatting | 45 | ||
Stacked and Unstacked Variables | 45 | ||
Recoding Variables | 46 | ||
1.5 Types of Survey Errors | 47 | ||
Coverage Error | 47 | ||
Nonresponse Error | 47 | ||
Sampling Error | 47 | ||
Measurement Error | 48 | ||
Ethical Issues About Surveys | 48 | ||
Consider This: New Media Surveys/Old Survey Errors | 48 | ||
Using Statistics: Defining Moments, Revisited | 50 | ||
Summary | 50 | ||
References | 50 | ||
Key Terms | 50 | ||
Checking Your Understanding | 51 | ||
Chapter Review Problems | 51 | ||
Cases For Chapter 1 | 52 | ||
Managing Ashland MultiComm Services | 52 | ||
CardioGood Fitness | 52 | ||
Clear Mountain State Student Survey | 53 | ||
Learning with the Digital Cases | 53 | ||
Chapter 1 Excel Guide | 54 | ||
EG1.1 Defining Variables | 54 | ||
EG1.2 Collecting Data | 54 | ||
EG1.3 Types of Sampling Methods | 54 | ||
EG1.4 Data Preparation | 55 | ||
2 Organizing and Visualizing Variables | 56 | ||
Using Statistics: “The Choice Is Yours” | 56 | ||
2.1 Organizing Categorical Variables | 57 | ||
The Summary Table | 57 | ||
The Contingency Table | 58 | ||
2.2 Organizing Numerical Variables | 61 | ||
The Frequency Distribution | 62 | ||
Classes and Excel Bins | 64 | ||
The Relative Frequency Distribution and the Percentage Distribution | 65 | ||
The Cumulative Distribution | 67 | ||
2.3 Visualizing Categorical Variables | 70 | ||
The Bar Chart | 70 | ||
The Pie Chart and the Doughnut Chart | 71 | ||
The Pareto Chart | 72 | ||
Visualizing Two Categorical Variables | 74 | ||
2.4 Visualizing Numerical Variables | 76 | ||
The Stem-and-Leaf Display | 77 | ||
The Histogram | 78 | ||
The Percentage Polygon | 79 | ||
The Cumulative Percentage Polygon (Ogive) | 80 | ||
2.5 Visualizing Two Numerical Variables | 83 | ||
The Scatter Plot | 83 | ||
The Time-Series Plot | 85 | ||
2.6 Organizing and Visualizing a Mix of Variables | 87 | ||
Multidimensional Contingency Table | 87 | ||
Adding a Numerical Variable to a Multidimensional Contingency Table | 88 | ||
Drill Down | 88 | ||
Excel Slicers | 89 | ||
PivotChart | 90 | ||
Sparklines | 90 | ||
2.7 The Challenge in Organizing and Visualizing Variables | 92 | ||
Obscuring Data | 92 | ||
Creating False Impressions | 93 | ||
Chartjunk | 94 | ||
EXHIBIT: Best Practices for Creating Visualizations | 96 | ||
Using Statistics: The Choice Is Yours, Revisited | 97 | ||
Summary | 97 | ||
References | 98 | ||
Key Equations | 98 | ||
Key Terms | 99 | ||
Checking Your Understanding | 99 | ||
Chapter Review Problems | 99 | ||
Cases For Chapter 2 | 104 | ||
Managing Ashland MultiComm Services | 104 | ||
Digital Case | 104 | ||
CardioGood Fitness | 105 | ||
The Choice Is Yours Follow-Up | 105 | ||
Clear Mountain State Student Survey | 105 | ||
Chapter 2 Excel Guide | 106 | ||
EG2.1 Organizing Categorical Variables | 106 | ||
EG2.2 Organizing Numerical Variables | 108 | ||
EG2.3 Visualizing Categorical Variables | 110 | ||
EG2.4 Visualizing Numerical Variables | 112 | ||
EG2.5 Visualizing Two Numerical Variables | 116 | ||
EG2.6 Organizing and Visualizing a Set of Variables | 116 | ||
3 Numerical Descriptive Measures | 119 | ||
Using Statistics: More Descriptive Choices | 119 | ||
3.1 Central Tendency | 120 | ||
The Mean | 120 | ||
The Median | 122 | ||
The Mode | 123 | ||
The Geometric Mean | 124 | ||
3.2 Variation and Shape | 125 | ||
The Range | 125 | ||
The Variance and the Standard Deviation | 126 | ||
EXHIBIT: Manually Calculating the Sample Variance, S², and Sample Standard Deviation, S | 127 | ||
The Coefficient of Variation | 129 | ||
Z Scores | 130 | ||
Shape: Skewness | 132 | ||
Shape: Kurtosis | 132 | ||
3.3 Exploring Numerical Data | 137 | ||
Quartiles | 137 | ||
EXHIBIT: Rules for Calculating the Quartiles from a Set of Ranked Values | 137 | ||
The Interquartile Range | 139 | ||
The Five-Number Summary | 139 | ||
The Boxplot | 141 | ||
3.4 Numerical Descriptive Measures for a Population | 143 | ||
The Population Mean | 144 | ||
The Population Variance and Standard Deviation | 144 | ||
The Empirical Rule | 145 | ||
Chebyshev’s Theorem | 146 | ||
3.5 The Covariance and the Coefficient of Correlation | 148 | ||
The Covariance | 148 | ||
The Coefficient of Correlation | 149 | ||
3.6 Statistics: Pitfalls and Ethical Issues | 154 | ||
Using Statistics: More Descriptive Choices, Revisited | 154 | ||
Summary | 154 | ||
References | 155 | ||
Key Equations | 155 | ||
Key Terms | 156 | ||
Checking Your Understanding | 156 | ||
Chapter Review Problems | 157 | ||
Cases For Chapter 3 | 160 | ||
Managing Ashland MultiComm Services | 160 | ||
Digital Case | 160 | ||
CardioGood Fitness | 160 | ||
More Descriptive Choices Follow-up | 160 | ||
Clear Mountain State Student Survey | 160 | ||
Chapter 3 Excel Guide | 161 | ||
EG3.1 Central Tendency | 161 | ||
EG3.2 Variation and Shape | 162 | ||
EG3.3 Exploring Numerical Data | 162 | ||
EG3.4 Numerical Descriptive Measures for a Population | 163 | ||
EG3.5 The Covariance and the Coefficient of Correlation | 163 | ||
4 Basic Probability | 165 | ||
Using Statistics: Possibilities at M&R Electronics World | 165 | ||
4.1 Basic Probability Concepts | 166 | ||
Events and Sample Spaces | 167 | ||
Contingency Tables | 169 | ||
Simple Probability | 169 | ||
Joint Probability | 170 | ||
Marginal Probability | 171 | ||
General Addition Rule | 171 | ||
4.2 Conditional Probability | 175 | ||
Computing Conditional Probabilities | 175 | ||
Decision Trees | 176 | ||
Independence | 178 | ||
Multiplication Rules | 179 | ||
Marginal Probability Using the General Multiplication Rule | 180 | ||
4.3 Ethical Issues and Probability | 182 | ||
4.4 Bayes’ Theorem | 183 | ||
Consider This: Divine Providence and Spam | 183 | ||
4.5 Counting Rules | 184 | ||
Using Statistics: Possibilities at M&R Electronics World, Revisited | 185 | ||
Summary | 185 | ||
References | 185 | ||
Key Equations | 185 | ||
Key Terms | 186 | ||
Checking Your Understanding | 186 | ||
Chapter Review Problems | 186 | ||
Cases For Chapter 4 | 188 | ||
Digital Case | 188 | ||
CardioGood Fitness | 188 | ||
The Choice Is Yours Follow-Up | 188 | ||
Clear Mountain State Student Survey | 188 | ||
Chapter 4 Excel Guide | 189 | ||
EG4.1 Basic Probability Concepts | 189 | ||
EG4.4 Bayes’ Theorem | 189 | ||
5 Discrete Probability Distributions | 190 | ||
Using Statistics: Events of Interest at Ricknel Home Centers | 190 | ||
5.1 The Probability Distribution for a Discrete Variable | 191 | ||
Expected Value of a Discrete Variable | 191 | ||
Variance and Standard Deviation of a Discrete Variable | 192 | ||
5.2 Binomial Distribution | 195 | ||
5.3 Poisson Distribution | 202 | ||
5.4 Covariance of a Probability Distribution and its Application in Finance | 205 | ||
5.5 Hypergeometric Distribution | 206 | ||
Using Statistics: Events of Interest…, Revisited | 206 | ||
Summary | 206 | ||
References | 206 | ||
Key Equations | 206 | ||
Key Terms | 207 | ||
Checking Your Understanding | 207 | ||
Chapter Review Problems | 207 | ||
Cases For Chapter 5 | 209 | ||
Managing Ashland MultiComm Services | 209 | ||
Digital Case | 210 | ||
Chapter 5 Excel Guide | 211 | ||
EG5.1 The Probability Distribution for a Discrete Variable | 211 | ||
EG5.2 Binomial Distribution | 211 | ||
EG5.3 Poisson Distribution | 212 | ||
6 The Normal Distribution and Other Continuous Distributions | 213 | ||
Using Statistics: Normal Load Times at MyTVLab | 213 | ||
6.1 Continuous Probability Distributions | 214 | ||
6.2 The Normal Distribution | 215 | ||
EXHIBIT: Normal Distribution Important Theoretical Properties | 215 | ||
Computing Normal Probabilities | 216 | ||
VISUAL EXPLORATIONS: Exploring the Normal Distribution | 222 | ||
Finding X Values | 222 | ||
Consider This: What Is Normal? | 226 | ||
6.3 Evaluating Normality | 227 | ||
Comparing Data Characteristics to Theoretical Properties | 228 | ||
Constructing the Normal Probability Plot | 229 | ||
6.4 The Uniform Distribution | 231 | ||
6.5 The Exponential Distribution | 233 | ||
6.6 The Normal Approximation to the Binomial Distribution | 233 | ||
Using Statistics: Normal Load Times…, Revisited | 234 | ||
Summary | 234 | ||
References | 234 | ||
Key Equations | 235 | ||
Key Terms | 235 | ||
Checking Your Understanding | 235 | ||
Chapter Review Problems | 235 | ||
Cases For Chapter 6 | 237 | ||
Managing Ashland MultiComm Services | 237 | ||
CardioGood Fitness | 237 | ||
More Descriptive Choices Follow-up | 237 | ||
Clear Mountain State Student Survey | 237 | ||
Digital Case | 237 | ||
Chapter 6 Excel Guide | 238 | ||
EG6.1 Continuous Probability Distributions | 238 | ||
EG6.2 The Normal Distribution | 238 | ||
EG6.3 Evaluating Normality | 238 | ||
7 Sampling Distributions | 240 | ||
Using Statistics: Sampling Oxford Cereals | 240 | ||
7.1 Sampling Distributions | 241 | ||
7.2 Sampling Distribution of the Mean | 241 | ||
The Unbiased Property of the Sample Mean | 241 | ||
Standard Error of the Mean | 243 | ||
Sampling from Normally Distributed Populations | 244 | ||
Sampling from Non-normally Distributed Populations— The Central Limit Theorem | 247 | ||
EXHIBIT: Normality and the Sampling Distribution of the Mean | 248 | ||
VISUAL EXPLORATIONS: Exploring Sampling Distributions | 251 | ||
7.3 Sampling Distribution of the Proportion | 252 | ||
Using Statistics: Sampling Oxford Cereals, Revisited | 255 | ||
Summary | 256 | ||
References | 256 | ||
Key Equations | 256 | ||
Key Terms | 256 | ||
Checking Your Understanding | 257 | ||
Chapter Review Problems | 257 | ||
Cases For Chapter 7 | 259 | ||
Managing Ashland Multicomm Services | 259 | ||
Digital Case | 259 | ||
Chapter 7 Excel Guide | 260 | ||
EG7.2 Sampling Distribution of the Mean | 260 | ||
8 Confidence Interval Estimation | 261 | ||
Using Statistics: Getting Estimates at Ricknel Home Centers | 261 | ||
8.1 Confidence Interval Estimate for the Mean (σ Known) | 262 | ||
Can You Ever Know the Population Standard Deviation? | 267 | ||
8.2 Confidence Interval Estimate for the Mean (σ Unknown) | 268 | ||
Student’s t Distribution | 268 | ||
Properties of the t Distribution | 269 | ||
The Concept of Degrees of Freedom | 270 | ||
The Confidence Interval Statement | 271 | ||
8.3 Confidence Interval Estimate for the Proportion | 276 | ||
8.4 Determining Sample Size | 279 | ||
Sample Size Determination for the Mean | 279 | ||
Sample Size Determination for the Proportion | 281 | ||
8.5 Confidence Interval Estimation and Ethical Issues | 284 | ||
8.6 Application of Confidence Interval Estimation in Auditing | 285 | ||
8.7 Estimation and Sample Size Estimation for Finite Populations | 285 | ||
8.8 Bootstrapping | 285 | ||
Using Statistics: Getting Estimates. . ., Revisited | 285 | ||
Summary | 286 | ||
References | 286 | ||
Key Equations | 286 | ||
Key Terms | 287 | ||
Checking Your Understanding | 287 | ||
Chapter Review Problems | 287 | ||
Cases For Chapter 8 | 290 | ||
Managing Ashland MultiComm Services | 290 | ||
Digital Case | 291 | ||
Sure Value Convenience Stores | 291 | ||
CardioGood Fitness | 291 | ||
More Descriptive Choices Follow-Up | 291 | ||
Clear Mountain State Student Survey | 291 | ||
Chapter 8 Excel Guide | 292 | ||
EG8.1 Confidence Interval Estimate for the Mean (σ Known) | 292 | ||
EG8.2 Confidence Interval Estimate for the Mean (σ Unknown) | 292 | ||
EG8.3 Confidence Interval Estimate for the Proportion | 293 | ||
EG8.4 Determining Sample Size | 293 | ||
9 Fundamentals of Hypothesis Testing: One-Sample Tests | 294 | ||
Using Statistics: Significant Testing at Oxford Cereals | 294 | ||
9.1 Fundamentals of Hypothesis-Testing Methodology | 295 | ||
The Null and Alternative Hypotheses | 295 | ||
The Critical Value of the Test Statistic | 296 | ||
Regions of Rejection and Nonrejection | 297 | ||
Risks in Decision Making Using Hypothesis Testing | 297 | ||
Z Test for the Mean (σ Known) | 300 | ||
Hypothesis Testing Using the Critical Value Approach | 300 | ||
EXHIBIT: The Critical Value Approach to Hypothesis Testing | 301 | ||
Hypothesis Testing Using the p-Value Approach | 303 | ||
EXHIBIT: The p-Value Approach to Hypothesis Testing | 304 | ||
A Connection Between Confidence Interval Estimation and Hypothesis Testing | 305 | ||
Can You Ever Know the Population Standard Deviation? | 306 | ||
9.2 t Test of Hypothesis for the Mean (σ Unknown) | 308 | ||
The Critical Value Approach | 308 | ||
p-Value Approach | 310 | ||
Checking the Normality Assumption | 310 | ||
9.3 One-Tail Tests | 314 | ||
The Critical Value Approach | 314 | ||
The p-Value Approach | 315 | ||
EXHIBIT: The Null and Alternative Hypotheses in One-Tail Tests | 317 | ||
9.4 Z Test of Hypothesis for the Proportion | 318 | ||
The Critical Value Approach | 319 | ||
The p-Value Approach | 320 | ||
9.5 Potential Hypothesis-Testing Pitfalls and Ethical Issues | 322 | ||
EXHIBIT: Questions for the Planning Stage of Hypothesis Testing | 322 | ||
Statistical Significance Versus Practical Significance | 323 | ||
Statistical Insignificance Versus Importance | 323 | ||
Reporting of Findings | 323 | ||
Ethical Issues | 323 | ||
9.6 Power of the Test | 324 | ||
Using Statistics: Significant Testing. . ., Revisited | 324 | ||
Summary | 324 | ||
References | 325 | ||
Key Equations | 325 | ||
Key Terms | 325 | ||
Checking Your Understanding | 325 | ||
Chapter Review Problems | 326 | ||
Cases For Chapter 9 | 328 | ||
Managing Ashland MultiComm Services | 328 | ||
Digital Case | 328 | ||
Sure Value Convenience Stores | 328 | ||
Chapter 9 Excel Guide | 329 | ||
EG9.1 Fundamentals of Hypothesis-Testing Methodology | 329 | ||
EG9.2 t Test of Hypothesis for the Mean (σ Unknown) | 329 | ||
EG9.3 One-Tail Tests | 330 | ||
EG9.4 Z Test of Hypothesis for the Proportion | 330 | ||
10 Two-Sample Tests | 331 | ||
Using Statistics: Differing Means for Selling Streaming Media Players at Arlingtons? | 331 | ||
10.1 Comparing the Means of Two Independent Populations | 332 | ||
Pooled-Variance t Test for the Difference Between Two Means | 332 | ||
Confidence Interval Estimate for the Difference Between Two Means | 337 | ||
t Test for the Difference Between Two Means, Assuming Unequal Variances | 338 | ||
Consider This: Do People Really Do This? | 339 | ||
10.2 Comparing the Means of Two Related Populations | 341 | ||
Paired t Test | 342 | ||
Confidence Interval Estimate for the Mean Difference | 347 | ||
10.3 Comparing the Proportions of Two Independent Populations | 349 | ||
Z Test for the Difference Between Two Proportions | 350 | ||
Confidence Interval Estimate for the Difference Between Two Proportions | 354 | ||
10.4 F Test for the Ratio of Two Variances | 356 | ||
10.5 Effect Size | 360 | ||
Using Statistics: Differing Means for Selling. . ., Revisited | 361 | ||
Summary | 361 | ||
References | 362 | ||
Key Equations | 362 | ||
Key Terms | 363 | ||
Checking Your Understanding | 363 | ||
Chapter Review Problems | 363 | ||
Cases For Chapter 10 | 365 | ||
Managing Ashland MultiComm Services | 365 | ||
Digital Case | 366 | ||
Sure Value Convenience Stores | 366 | ||
CardioGood Fitness | 366 | ||
More Descriptive Choices Follow-Up | 366 | ||
Clear Mountain State Student Survey | 366 | ||
Chapter 10 Excel Guide | 367 | ||
EG10.1 Comparing The Means of Two Independent Populations | 367 | ||
EG10.2 Comparing the Means of Two Related Populations | 369 | ||
EG10.3 Comparing the Proportions of Two Independent Populations | 370 | ||
EG10.4 F Test for the Ratio of Two Variances | 371 | ||
11 Analysis of Variance | 372 | ||
Using Statistics: The Means to Find Differences at Arlingtons | 372 | ||
11.1 The Completely Randomized Design: One-Way ANOVA | 373 | ||
Analyzing Variation in One-Way ANOVA | 374 | ||
F Test for Differences Among More Than Two Means | 376 | ||
One-Way ANOVA F Test Assumptions | 380 | ||
Levene Test for Homogeneity of Variance | 381 | ||
Multiple Comparisons: The Tukey-Kramer Procedure | 382 | ||
The Analysis of Means (ANOM) | 384 | ||
11.2 The Factorial Design: Two-Way ANOVA | 387 | ||
Factor and Interaction Effects | 388 | ||
Testing for Factor and Interaction Effects | 390 | ||
Multiple Comparisons: The Tukey Procedure | 393 | ||
Visualizing Interaction Effects: The Cell Means Plot | 395 | ||
Interpreting Interaction Effects | 395 | ||
11.3 The Randomized Block Design | 399 | ||
11.4 Fixed Effects, Random Effects, and Mixed Effects Models | 399 | ||
Using Statistics: The Means to Find Differences at Arlingtons Revisited | 399 | ||
Summary | 400 | ||
References | 400 | ||
Key Equations | 400 | ||
Key Terms | 401 | ||
Checking Your Understanding | 402 | ||
Chapter Review Problems | 402 | ||
Cases For Chapter 11 | 404 | ||
Managing Ashland MultiComm Services | 404 | ||
PHASE 1 | 404 | ||
PHASE 2 | 404 | ||
Digital Case | 405 | ||
Sure Value Convenience Stores | 405 | ||
CardioGood Fitness | 405 | ||
More Descriptive Choices Follow-Up | 405 | ||
Clear Mountain State Student Survey | 405 | ||
Chapter 11 Excel Guide | 406 | ||
EG11.1 The Completely Randomized Design: One-Way ANOVA | 406 | ||
EG11.2 The Factorial Design: Two-Way ANOVA | 408 | ||
12 Chi-Square and Nonparametric Tests | 410 | ||
Using Statistics: Avoiding Guesswork about Resort Guests | 410 | ||
12.1 Chi-Square Test for the Difference Between Two Proportions | 411 | ||
12.2 Chi-Square Test for Differences Among More Than Two Proportions | 418 | ||
The Marascuilo Procedure | 421 | ||
The Analysis of Proportions (ANOP) | 423 | ||
12.3 Chi-Square Test of Independence | 424 | ||
12.4 Wilcoxon Rank Sum Test: A Nonparametric Method for Two Independent Populations | 430 | ||
12.5 Kruskal-Wallis Rank Test: A Nonparametric Method for the One-Way ANOVA | 436 | ||
Assumptions | 439 | ||
12.6 McNemar Test for the Difference Between Two Proportions (Related Samples) | 441 | ||
12.7 Chi-Square Test for the Variance or Standard Deviation | 441 | ||
Using Statistics: Avoiding Guesswork. . ., Revisited | 442 | ||
Summary | 442 | ||
References | 443 | ||
Key Equations | 443 | ||
Key Terms | 444 | ||
Checking Your Understanding | 444 | ||
Chapter Review Problems | 444 | ||
Cases For Chapter 12 | 446 | ||
Managing Ashland MultiComm Services | 446 | ||
PHASE 1 | 446 | ||
PHASE 2 | 446 | ||
Digital Case | 447 | ||
Sure Value Convenience Stores | 447 | ||
CardioGood Fitness | 447 | ||
More Descriptive Choices Follow-Up | 447 | ||
Clear Mountain State Student Survey | 447 | ||
Chapter 12 Excel Guide | 448 | ||
EG12.1 Chi-Square Test for the Difference Between Two Proportions | 448 | ||
EG12.2 Chi-Square Test for Differences Among More Than Two Proportions | 448 | ||
EG12.3 Chi-Square Test of Independence | 449 | ||
EG12.4 Wilcoxon Rank Sum Test: a Nonparametric Method for Two Independent Populations | 449 | ||
EG12.5 Kruskal-Wallis Rank Test: a Nonparametric Method for the One-Way ANOVA | 450 | ||
13 Simple Linear Regression | 451 | ||
Using Statistics: Knowing Customers at Sunflowers Apparel | 451 | ||
13.1 Types of Regression Models | 452 | ||
Simple Linear Regression Models | 453 | ||
13.2 Determining the Simple Linear Regression Equation | 454 | ||
The Least-Squares Method | 454 | ||
Predictions in Regression Analysis: Interpolation Versus Extrapolation | 457 | ||
Computing the Y Intercept, b0 and the Slope, b₁ | 457 | ||
VISUAL EXPLORATIONS: Exploring Simple Linear Regression Coefficients | 460 | ||
13.3 Measures of Variation | 462 | ||
Computing the Sum of Squares | 462 | ||
The Coefficient of Determination | 463 | ||
Standard Error of the Estimate | 465 | ||
13.4 Assumptions of Regression | 467 | ||
13.5 Residual Analysis | 467 | ||
Evaluating the Assumptions | 467 | ||
13.6 Measuring Autocorrelation: The Durbin-Watson Statistic | 471 | ||
Residual Plots to Detect Autocorrelation | 471 | ||
The Durbin-Watson Statistic | 472 | ||
13.7 Inferences About the Slope and Correlation Coefficient | 475 | ||
t Test for the Slope | 475 | ||
F Test for the Slope | 477 | ||
Confidence Interval Estimate for the Slope | 478 | ||
t Test for the Correlation Coefficient | 479 | ||
13.8 Estimation of Mean Values and Prediction of Individual Values | 482 | ||
The Confidence Interval Estimate for the Mean Response | 482 | ||
The Prediction Interval for an Individual Response | 483 | ||
13.9 Potential Pitfalls in Regression | 486 | ||
EXHIBIT: Six Steps for Avoiding the Potential Pitfalls | 486 | ||
Using Statistics: Knowing Customers. . ., Revisited | 488 | ||
Summary | 488 | ||
References | 489 | ||
Key Equations | 490 | ||
Key Terms | 491 | ||
Checking Your Understanding | 491 | ||
Chapter Review Problems | 491 | ||
Cases For Chapter 13 | 495 | ||
Managing Ashland MultiComm Services | 495 | ||
Digital Case | 495 | ||
Brynne Packaging | 495 | ||
Chapter 13 Excel Guide | 496 | ||
EG13.2 Determining the Simple Linear Regression Equation | 496 | ||
EG13.3 Measures of Variation | 497 | ||
EG13.4 Assumptions of Regression | 497 | ||
EG13.5 Residual Analysis | 497 | ||
EG13.6 Measuring Autocorrelation: The Durbin-Watson Statistic | 498 | ||
EG13.7 Inferences about the Slope and Correlation Coefficient | 498 | ||
EG13.8 Estimation of Mean Values and Prediction of Individual Values | 498 | ||
14 Introduction to Multiple Regression | 499 | ||
Using Statistics: The Multiple Effects of OmniPower Bars | 499 | ||
14.1 Developing a Multiple Regression Model | 500 | ||
Interpreting the Regression Coefficients | 500 | ||
Predicting the Dependent Variable Y | 503 | ||
14.2 r², Adjusted r², and the Overall F Test | 505 | ||
Coefficient of Multiple Determination | 505 | ||
Adjusted r² | 505 | ||
Test for the Significance of the Overall Multiple Regression Model | 506 | ||
14.3 Residual Analysis for the Multiple Regression Model | 508 | ||
14.4 Inferences Concerning the Population Regression Coefficients | 510 | ||
Tests of Hypothesis | 510 | ||
Confidence Interval Estimation | 511 | ||
14.5 Testing Portions of the Multiple Regression Model | 513 | ||
Coefficients of Partial Determination | 517 | ||
14.6 Using Dummy Variables and Interaction Terms in Regression Models | 519 | ||
Interactions | 521 | ||
14.7 Logistic Regression | 528 | ||
Using Statistics: The Multiple Effects . . ., Revisited | 533 | ||
Summary | 533 | ||
References | 535 | ||
Key Equations | 535 | ||
Key Terms | 536 | ||
Checking Your Understanding | 536 | ||
Chapter Review Problems | 536 | ||
Cases For Chapter 14 | 539 | ||
Managing Ashland MultiComm Services | 539 | ||
Digital Case | 539 | ||
Chapter 14 Excel Guide | 541 | ||
EG14.1 Developing a Multiple Regression Model | 541 | ||
EG14.2 r², Adjusted r², and the Overall F Test | 542 | ||
EG14.3 Residual Analysis for the Multiple Regression Model | 542 | ||
EG14.4 Inferences Concerning the Population Regression Coefficients | 543 | ||
EG14.5 Testing Portions of the Multiple Regression Model | 543 | ||
EG14.6 Using Dummy Variables and Interaction Terms in Regression Models | 543 | ||
EG14.7 Logistic Regression | 544 | ||
15 Multiple Regression Model Building | 545 | ||
Using Statistics: Valuing Parsimony at WSTA-TV | 545 | ||
15.1 Quadratic Regression Model | 546 | ||
Finding the Regression Coefficients and Predicting Y | 546 | ||
Testing for the Significance of the Quadratic Model | 549 | ||
Testing the Quadratic Effect | 549 | ||
The Coefficient of Multiple Determination | 551 | ||
15.2 Using Transformations in Regression Models | 553 | ||
The Square-Root Transformation | 553 | ||
The Log Transformation | 555 | ||
15.3 Collinearity | 558 | ||
15.4 Model Building | 559 | ||
The Stepwise Regression Approach to Model Building | 561 | ||
The Best Subsets Approach to Model Building | 562 | ||
Model Validation | 565 | ||
EXHIBIT: Steps for Successful Model Building | 566 | ||
15.5 Pitfalls in Multiple Regression and Ethical Issues | 568 | ||
Pitfalls in Multiple Regression | 568 | ||
Ethical Issues | 568 | ||
Using Statistics: Valuing Parsimony…, Revisited | 568 | ||
Summary | 569 | ||
References | 570 | ||
Key Equations | 570 | ||
Key Terms | 570 | ||
Checking Your Understanding | 570 | ||
Chapter Review Problems | 570 | ||
Cases For Chapter 15 | 572 | ||
The Mountain States Potato Company | 572 | ||
Sure Value Convenience Stores | 573 | ||
Digital Case | 573 | ||
The Craybill Instrumentation Company Case | 573 | ||
More Descriptive Choices Follow-Up | 574 | ||
Chapter 15 Excel Guide | 575 | ||
Eg15.1 The Quadratic Regression Model | 575 | ||
Eg15.2 Using Transformations In Regression Models | 575 | ||
Eg15.3 Collinearity | 576 | ||
Eg15.4 Model Building | 576 | ||
16 Time-Series Forecasting | 577 | ||
Using Statistics: Principled Forecasting | 577 | ||
16.1 The Importance of Business Forecasting | 578 | ||
16.2 Component Factors of Time-Series Models | 578 | ||
16.3 Smoothing an Annual Time Series | 579 | ||
Moving Averages | 580 | ||
Exponential Smoothing | 582 | ||
16.4 Least-Squares Trend Fitting and Forecasting | 585 | ||
The Linear Trend Model | 585 | ||
The Quadratic Trend Model | 587 | ||
The Exponential Trend Model | 588 | ||
Model Selection Using First, Second, and Percentage Differences | 590 | ||
16.5 Autoregressive Modeling for Trend Fitting and Forecasting | 595 | ||
Selecting an Appropriate Autoregressive Model | 596 | ||
Determining the Appropriateness of a Selected Model | 597 | ||
EXHIBIT: Autoregressive Modeling Steps | 599 | ||
16.6 Choosing an Appropriate Forecasting Model | 604 | ||
Performing a Residual Analysis | 604 | ||
Measuring the Magnitude of the Residuals Through Squared or Absolute Differences | 605 | ||
Using the Principle of Parsimony | 605 | ||
A Comparison of Four Forecasting Methods | 605 | ||
16.7 Time-Series Forecasting of Seasonal Data | 607 | ||
Least-Squares Forecasting with Monthly or Quarterly Data | 608 | ||
16.8 Index Numbers | 613 | ||
CONSIDER THIS: Let the Model User Beware | 613 | ||
Using Statistics: Principled Forecasting, Revisited | 613 | ||
Summary | 614 | ||
References | 615 | ||
Key Equations | 615 | ||
Key Terms | 616 | ||
Checking Your Understanding | 616 | ||
Chapter Review Problems | 616 | ||
Cases For Chapter 16 | 617 | ||
Managing Ashland MultiComm Services | 617 | ||
Digital Case | 617 | ||
Chapter 16 Excel Guide | 618 | ||
Eg16.3 Smoothing an Annual Time Series | 618 | ||
Eg16.4 Least-Squares Trend Fitting and Forecasting | 619 | ||
Eg16.5 Autoregressive Modeling for Trend Fitting and Forecasting | 620 | ||
Eg16.6 Choosing an Appropriate Forecasting Model | 620 | ||
Eg16.7 Time-Series Forecasting of Seasonal Data | 621 | ||
17 Getting Ready to Analyze Data in the Future | 622 | ||
Using Statistics: Mounting Future Analyses | 622 | ||
17.1 Analyzing Numerical Variables | 623 | ||
EXHIBIT: Questions to Ask When Analyzing Numerical Variables | 623 | ||
Describe the Characteristics of a Numerical Variable? | 623 | ||
Reach Conclusions about the Population Mean or the Standard Deviation? | 623 | ||
Determine Whether the Mean and/or Standard Deviation Differs Depending on the Group? | 624 | ||
Determine Which Factors Affect the Value of a Variable? | 624 | ||
Predict the Value of a Variable Based on the Values of Other Variables? | 625 | ||
Determine Whether the Values of a Variable Are Stable Over Time? | 625 | ||
17.2 Analyzing Categorical Variables | 625 | ||
EXHIBIT: Questions to Ask When Analyzing Categorical Variables | 625 | ||
Describe the Proportion of Items of Interest in Each Category? | 625 | ||
Reach Conclusions about the Proportion of Items of Interest? | 625 | ||
Determine Whether the Proportion of Items of Interest Differs Depending on the Group? | 626 | ||
Predict the Proportion of Items of Interest Based on the Values of Other Variables? | 626 | ||
Determine Whether the Proportion of Items of Interest Is Stable Over Time? | 626 | ||
Using Statistics: Back to Arlingtons for the Future | 626 | ||
17.3 Introduction to Business Analytics | 627 | ||
Data Mining | 627 | ||
Power Pivot | 627 | ||
17.4 Descriptive Analytics | 628 | ||
Dashboards | 629 | ||
Dashboard Elements | 629 | ||
17.5 Predictive Analytics | 630 | ||
Classification and Regression Trees | 631 | ||
Using Statistics: The Future to be Visited | 632 | ||
References | 632 | ||
Chapter Review Problems | 632 | ||
Chapter 17 Excel Guide | 635 | ||
EG17.3 Introduction to Business Analytics | 635 | ||
EG17.4 Descriptive Analytics | 635 | ||
18 Statistical Applications in Quality Management (online) | 18-1 | ||
Using Statistics: Finding Quality at the Beachcomber | 18-1 | ||
18.1 The Theory of Control Charts | 18-2 | ||
18.2 Control Chart for the Proportion: The p Chart | 18-4 | ||
18.3 The Red Bead Experiment: Understanding Process Variability | 18-10 | ||
18.4 Control Chart for an Area of Opportunity: The c Chart | 18-12 | ||
18.5 Control Charts for the Range and the Mean | 18-15 | ||
The R Chart | 18-16 | ||
The X Chart | 18-18 | ||
18.6 Process Capability | 18-21 | ||
Customer Satisfaction and Specification Limits | 18-21 | ||
Capability Indices | 18-23 | ||
CPL, CPU, and Cpk | 18-24 | ||
18.7 Total Quality Management | 18-26 | ||
18.8 Six Sigma | 18-28 | ||
The DMAIC Model | 18-29 | ||
Roles in a Six Sigma Organization | 18-30 | ||
Lean Six Sigma | 18-30 | ||
Using Statistics: Finding Quality at the Beachcomber, Revisited | 18-31 | ||
Summary | 18-31 | ||
References | 18-32 | ||
Key Equations | 18-32 | ||
Key Terms | 18-33 | ||
Chapter Review Problems | 18-34 | ||
Cases For Chapter 18 | 18-35 | ||
The Harnswell Sewing Machine Company Case | 18-35 | ||
Managing Ashland Multicomm Services | 18-38 | ||
Chapter 18 Excel Guide | 18-39 | ||
EG18.1 The Theory of Control Charts | 18-39 | ||
EG18.2 Control Chart for the Proportion: The p Chart | 18-39 | ||
EG18.3 The Red Bead Experiment: Understanding Process Variability | 18-40 | ||
EG18.4 Control Chart for an Area of Opportunity: The c Chart | 18-40 | ||
EG18.5 Control Charts for the Range and the Mean | 18-41 | ||
EG18.6 Process Capability | 18-42 | ||
19 Decision Making (online) | 19-1 | ||
Using Statistics: Reliable Decision Making | 19-1 | ||
19.1 Payoff Tables and Decision Trees | 19-2 | ||
19.2 Criteria for Decision Making | 19-6 | ||
Maximax Payoff | 19-6 | ||
Maximin Payoff | 19-7 | ||
Expected Monetary Value | 19-7 | ||
Expected Opportunity Loss | 19-9 | ||
Return-to-Risk Ratio | 19-11 | ||
19.3 Decision Making with Sample Information | 19-16 | ||
19.4 Utility | 19-21 | ||
Consider This: Risky Business | 19-22 | ||
Using Statistics: Reliable Decision-Making, Revisited | 19-22 | ||
Summary | 19-23 | ||
References | 19-23 | ||
Key Equations | 19-23 | ||
Key Terms | 19-23 | ||
Chapter Review Problems | 19-23 | ||
Cases For Chapter 19 | 19-26 | ||
Digital Case | 19-26 | ||
Chapter 19 Excel Guide | 19-27 | ||
EG19.1 Payoff Tables and Decision Trees | 19-27 | ||
EG19.2 Criteria for Decision Making | 19-27 | ||
Appendices | 637 | ||
A. Basic Math Concepts and Symbols | 638 | ||
A.1 Rules for Arithmetic Operations | 638 | ||
A.2 Rules for Algebra: Exponents and Square Roots | 638 | ||
A.3 Rules for Logarithms | 639 | ||
A.4 Summation Notation | 640 | ||
A.5 Statistical Symbols | 643 | ||
A.6 Greek Alphabet | 643 | ||
B Important Excel Skills and Concepts | 644 | ||
B.1 Which Excel Do You Use? | 644 | ||
B.2 Basic Operations | 645 | ||
B.3 Formulas and Cell References | 645 | ||
B.4 Entering a Formula | 647 | ||
B.5 Formatting Cell Contents | 648 | ||
B.6 Formatting Charts | 649 | ||
B.7 Selecting Cell Ranges for Charts | 650 | ||
B.8 Deleting the “Extra” Histogram Bar | 651 | ||
B.9 Creating Histograms for Discrete Probability Distributions | 651 | ||
C. Online Resources | 652 | ||
C.1 About the Online Resources for This Book | 652 | ||
C.2 Accessing the Online Resources | 652 | ||
C.3 Details of Online Resources | 652 | ||
C.4 PHStat | 659 | ||
D. Configuring Microsoft Excel | 660 | ||
D.1 Getting Microsoft Excel Ready for Use | 660 | ||
D.2 Checking for the Presence of the Analysis ToolPak or Solver Add-Ins | 660 | ||
D.3 Configuring Microsoft Windows Excel Security Settings | 660 | ||
D.4 Opening Pearson-Supplied Add-Ins | 661 | ||
E. Tables | 662 | ||
E.1 Table of Random Numbers | 662 | ||
E.2 The Cumulative Standardized Normal Distribution | 664 | ||
E.3 Critical Values of t | 666 | ||
E.4 Critical Values of X² | 668 | ||
E.5 Critical Values of F | 669 | ||
E.6 Lower and Upper Critical Values, T₁, of the Wilcoxon Rank Sum Test | 673 | ||
E.7 Critical Values of the Studentized Range, Q | 674 | ||
E.8 Critical Values, dL and dU, of the Durbin–Watson Statistic, D (Critical Values Are One-Sided) | 676 | ||
E.9 Control Chart Factors | 677 | ||
E.10 The Standardized Normal Distribution | 678 | ||
F. Useful Excel Knowledge | 679 | ||
F.1 Useful Keyboard Shortcuts | 679 | ||
F.2 Verifying Formulas and Worksheets | 679 | ||
F.3 New Function Names | 679 | ||
F.4 Understanding the Nonstatistical Functions | 681 | ||
G. Software FAQs | 683 | ||
G.1 PHStat FAQs | 683 | ||
G.2 Microsoft Excel FAQs | 683 | ||
Self-Test Solutions and Answers to Selected Even-Numbered Problems | 685 | ||
Index | 714 | ||
A | 714 | ||
B | 714 | ||
C | 714 | ||
D | 715 | ||
E | 715 | ||
F | 715 | ||
G | 715 | ||
H | 715 | ||
I | 715 | ||
J | 715 | ||
K | 715 | ||
L | 716 | ||
M | 716 | ||
N | 717 | ||
O | 717 | ||
P | 717 | ||
Q | 718 | ||
R | 718 | ||
S | 718 | ||
T | 719 | ||
U | 719 | ||
V | 719 | ||
W | 720 | ||
X | 720 | ||
Y | 720 | ||
Z | 720 | ||
Credits | 721 |