Introduction: The Even You Can Learn Statistics and Analytics Owner's Manual |
|
xiii | |
|
Chapter 1 Fundamentals of Statistics |
|
|
1 | (14) |
|
1.1 The First Three Words of Statistics |
|
|
2 | (2) |
|
1.2 The Fourth and Fifth Words |
|
|
4 | (1) |
|
1.3 The Branches of Statistics |
|
|
4 | (1) |
|
|
5 | (2) |
|
|
7 | (1) |
|
1.6 Sample Selection Methods |
|
|
8 | (7) |
|
Chapter 2 Presenting Data in Tables and Charts |
|
|
15 | (30) |
|
2.1 Presenting Categorical Variables |
|
|
15 | (8) |
|
2.2 Presenting Numerical Variables |
|
|
23 | (6) |
|
|
29 | (16) |
|
Chapter 3 Descriptive Statistics |
|
|
45 | (30) |
|
3.1 Measures of Central Tendency |
|
|
45 | (4) |
|
|
49 | (5) |
|
3.3 Measures of Variation |
|
|
54 | (5) |
|
3.4 Shape of Distributions |
|
|
59 | (16) |
|
|
75 | (12) |
|
|
75 | (1) |
|
|
76 | (2) |
|
4.3 Some Rules of Probability |
|
|
78 | (3) |
|
4.4 Assigning Probabilities |
|
|
81 | (6) |
|
Chapter 5 Probability Distributions |
|
|
87 | (34) |
|
5.1 Probability Distributions for Discrete Variables |
|
|
87 | (6) |
|
5.2 The Binomial and Poisson Probability Distributions |
|
|
93 | (7) |
|
5.3 Continuous Probability Distributions and the Normal Distribution |
|
|
100 | (8) |
|
5.4 The Normal Probability Plot |
|
|
108 | (13) |
|
Chapter 6 Sampling Distributions and Confidence Intervals |
|
|
121 | (24) |
|
6.1 Foundational Concepts |
|
|
122 | (3) |
|
6.2 Sampling Error and Confidence Intervals |
|
|
125 | (3) |
|
6.3 Confidence Interval Estimate for the Mean Using the t Distribution (o Unknown) |
|
|
128 | (3) |
|
6.4 Confidence Interval Estimation for Categorical Variables |
|
|
131 | (3) |
|
6.5 Confidence Interval Estimation When Normality Cannot Be Assumed |
|
|
134 | (11) |
|
Chapter 7 Fundamentals of Hypothesis Testing |
|
|
145 | (12) |
|
7.1 The Null and Alternative Hypotheses |
|
|
145 | (2) |
|
7.2 Hypothesis Testing Issues |
|
|
147 | (2) |
|
7.3 Decision-Making Risks |
|
|
149 | (1) |
|
7.4 Performing Hypothesis Testing |
|
|
150 | (2) |
|
7.5 Types of Hypothesis Tests |
|
|
152 | (5) |
|
Chapter 8 Hypothesis Testing: Z and t Tests |
|
|
157 | (26) |
|
8.1 Test for the Difference Between Two Proportions |
|
|
157 | (6) |
|
8.2 Test for the Difference Between the Means of Two Independent Groups |
|
|
163 | (5) |
|
|
168 | (15) |
|
Chapter 9 Hypothesis Testing: Chi-Square Tests and the One-Way Analysis of Variance (ANOVA) |
|
|
183 | (28) |
|
9.1 Chi-Square Test for Two-Way Tables |
|
|
183 | (8) |
|
9.2 One-Way Analysis of Variance (ANOVA): Testing for the Differences Among the Means of More Than Two Groups |
|
|
191 | (20) |
|
Chapter 10 Simple Linear Regression |
|
|
211 | (32) |
|
10.1 Basics of Regression Analysis |
|
|
211 | (3) |
|
10.2 Developing a Simple Linear Regression Model |
|
|
214 | (7) |
|
10.3 Measures of Variation |
|
|
221 | (5) |
|
10.4 Inferences About the Slope |
|
|
226 | (3) |
|
10.5 Common Mistakes When Using Regression Analysis |
|
|
229 | (14) |
|
Chapter 11 Multiple Regression |
|
|
243 | (16) |
|
11.1 The Multiple Regression Model |
|
|
243 | (3) |
|
11.2 Coefficient of Multiple Determination |
|
|
246 | (1) |
|
|
246 | (1) |
|
11.4 Residual Analysis for the Multiple Regression Model |
|
|
247 | (1) |
|
11.5 Inferences Concerning the Population Regression Coefficients |
|
|
248 | (11) |
|
Chapter 12 Introduction to Analytics |
|
|
259 | (20) |
|
|
259 | (6) |
|
12.2 Descriptive Analytics |
|
|
265 | (4) |
|
12.3 Typical Descriptive Analytics Visualizations |
|
|
269 | (10) |
|
Chapter 13 Predictive Analytics |
|
|
279 | (20) |
|
13.1 Predictive Analytics Methods |
|
|
279 | (2) |
|
13.2 More About Predictive Models |
|
|
281 | (3) |
|
|
284 | (3) |
|
|
287 | (3) |
|
13.5 Association Analysis |
|
|
290 | (9) |
|
Appendix A Microsoft Excel Operation and Configuration |
|
|
299 | (2) |
|
A.1 Conventions for Keystroke and Mouse Operations |
|
|
299 | (1) |
|
A.2 Microsoft Excel Technical Configuration |
|
|
300 | (1) |
|
Appendix B Review of Arithmetic and Algebra |
|
|
301 | (10) |
|
|
301 | (2) |
|
|
303 | (7) |
|
|
310 | (1) |
|
Appendix C Statistical Tables |
|
|
311 | (28) |
|
Appendix D Spreadsheet Tips |
|
|
339 | (4) |
|
|
339 | (2) |
|
|
341 | (2) |
|
Appendix E Advanced Techniques |
|
|
343 | (10) |
|
|
343 | (6) |
|
|
349 | (4) |
|
Appendix F Documentation for Downloadable Files |
|
|
353 | (4) |
|
F1 Downloadable Data Files |
|
|
353 | (2) |
|
F2 Downloadable Spreadsheet Solution Files |
|
|
355 | (2) |
Index |
|
357 | |