About the Author |
|
ix | |
About the Technical Reviewer |
|
xi | |
Introduction |
|
xiii | |
Chapter 1 The Basics of Statistics |
|
1 | (14) |
|
|
2 | (3) |
|
Measures of Central Tendency (Mean, Median, Mode) |
|
|
5 | (1) |
|
Measures of Variability (Range, Variance, Standard Deviation) |
|
|
6 | (4) |
|
Example of Standard Deviation and Variance |
|
|
8 | (2) |
|
|
10 | (3) |
|
Cleaning the Data Using Descriptive Statistics |
|
|
13 | (1) |
|
|
14 | (1) |
Chapter 2 The Normal Curve |
|
15 | (8) |
|
A Statistical Introduction |
|
|
16 | (1) |
|
An Important Theorem and a Law |
|
|
16 | (2) |
|
The Standard Normal Curve and Its Generalizability Factor |
|
|
18 | (2) |
|
How the T-Distribution Converges to the Normal Curve |
|
|
20 | (1) |
|
|
21 | (2) |
Chapter 3 Probability and Percentages, and Their Practical Business Uses |
|
23 | (14) |
|
What Percentages Tell Us, and Their Uses |
|
|
24 | (1) |
|
Hints to Use to Solve Percent Problems |
|
|
25 | (1) |
|
General Business Examples |
|
|
26 | (2) |
|
|
26 | (1) |
|
|
26 | (1) |
|
|
27 | (1) |
|
|
27 | (1) |
|
|
27 | (1) |
|
Real-Life Probability and Percent Examples: Markup |
|
|
28 | (3) |
|
|
29 | (1) |
|
|
29 | (1) |
|
|
29 | (1) |
|
|
30 | (1) |
|
|
30 | (1) |
|
|
30 | (1) |
|
|
30 | (1) |
|
|
31 | (1) |
|
Real-Life Percent Examples: Discount |
|
|
31 | (2) |
|
|
32 | (1) |
|
|
32 | (1) |
|
|
32 | (1) |
|
|
33 | (1) |
|
Real-Life Percent Examples: Profit Margin |
|
|
33 | (2) |
|
|
33 | (1) |
|
|
34 | (1) |
|
|
34 | (1) |
|
|
35 | (1) |
|
|
35 | (2) |
Chapter 4 Retail Math: Basic, Inventory/Stock, and Growth Metrics |
|
37 | (16) |
|
Financial Statements at a Glance |
|
|
39 | (1) |
|
Retail Math Basic Metrics |
|
|
40 | (7) |
|
|
47 | (4) |
|
|
51 | (1) |
|
|
52 | (1) |
Chapter 5 Financial Ratios |
|
53 | (12) |
|
Financial Ratios at a Glance |
|
|
53 | (1) |
|
|
54 | (4) |
|
|
58 | (2) |
|
|
60 | (2) |
|
|
62 | (1) |
|
|
63 | (2) |
Chapter 6 Using Frequencies and Percentages to Create Stories from Charts |
|
65 | (12) |
|
Frequencies: How to Use Percentages |
|
|
66 | (5) |
|
Simple Charts: Horizontal, Vertical, and Pie |
|
|
71 | (5) |
|
Horizontal and Vertical Bar Charts |
|
|
73 | (2) |
|
|
75 | (1) |
|
|
76 | (1) |
Chapter 7 Hypothesis Testing and Interpretation of Results |
|
77 | (6) |
|
Step 1: The Hypothesis, or Reason for the Business Question |
|
|
78 | (1) |
|
|
79 | (1) |
|
Step 3: Mathematical Operations and Statistical Formulas |
|
|
80 | (1) |
|
|
81 | (1) |
|
Step 5: Descriptive Analysis |
|
|
81 | (1) |
|
|
81 | (2) |
Chapter 8 Pearson Correlation and Using the Excel Linear Trend Equation and Excel Regression Output |
|
83 | (24) |
|
Pearson Correlation Defined |
|
|
83 | (2) |
|
Hypothesis Testing and Descriptive Steps for a Pearson Correlation |
|
|
85 | (8) |
|
Step 1: The Hypothesis, or the Reason for the Business Question |
|
|
85 | (1) |
|
|
86 | (1) |
|
Step 3: Mathematical Operations and Statistical Formula |
|
|
87 | (3) |
|
|
90 | (2) |
|
Step 5: Descriptive Analysis Interpretation of Results |
|
|
92 | (1) |
|
Three Examples Using Small Datasets |
|
|
93 | (13) |
|
Step 1: Hypotheses Are All the Same |
|
|
93 | (1) |
|
Step 2: Level of Confidence |
|
|
93 | (1) |
|
Step 3: Mathematical Operations and Statistical Formula |
|
|
94 | (11) |
|
|
105 | (1) |
|
Step 5: Descriptive Analysis |
|
|
105 | (1) |
|
|
106 | (1) |
Chapter 9 Independent T-Test |
|
107 | (8) |
|
Independent T-Test at a Glance |
|
|
107 | (1) |
|
|
108 | (1) |
|
Step 1: The Hypothesis, or the Reason for the Business Question |
|
|
109 | (1) |
|
|
109 | (1) |
|
Step 3: Mathematical Operations and Statistical Formula |
|
|
110 | (3) |
|
|
113 | (1) |
|
Step 5: Descriptive Analysis |
|
|
114 | (1) |
|
|
114 | (1) |
Chapter 10 Putting It All Together: An Email Campaign |
|
115 | (20) |
|
|
115 | (1) |
|
|
116 | (1) |
|
|
117 | (2) |
|
Type of Shopper Targeting |
|
|
118 | (1) |
|
Time of Year and Duration |
|
|
118 | (1) |
|
|
118 | (1) |
|
|
118 | (1) |
|
Steps to Assess the Success of the Email Campaign |
|
|
119 | (1) |
|
Statistics Conducted: Results and Explanations |
|
|
120 | (7) |
|
Independent T-Test 1: Conversion Rate Between Models and No Models |
|
|
121 | (1) |
|
Independent T-Test 2: Revenue Between Models and No Models |
|
|
122 | (1) |
|
Independent T-Test 3: Dresses Sold Between Models and No Models |
|
|
123 | (1) |
|
Independent T-Test 4: Orders of Dresses Between Models and No Models |
|
|
124 | (1) |
|
Pearson Correlation by Model: Relationship Between Conversion Rate and Revenue |
|
|
125 | (2) |
|
Sell-Through Rate for Model and No Model |
|
|
127 | (3) |
|
Average Order Value for Model and No Model |
|
|
128 | (1) |
|
Total Metrics on Key Performance Indicators for Email Campaign |
|
|
129 | (1) |
|
Average Click-Through Rate |
|
|
130 | (1) |
|
|
130 | (1) |
|
|
130 | (1) |
|
|
131 | (1) |
|
Summary and Discussion on Results |
|
|
132 | (1) |
|
Thoughts for Further Analyses |
|
|
132 | (1) |
|
|
133 | (2) |
Chapter 11 Forecasting: Planning for Future Scenarios |
|
135 | (8) |
|
|
136 | (1) |
|
Establishing Data Collection |
|
|
136 | (1) |
|
Predictive Analysis Using the Spreadsheet |
|
|
137 | (2) |
|
|
139 | (1) |
|
Campaign Analysis and Prediction |
|
|
140 | (1) |
|
Consumer Analysis and Prediction |
|
|
141 | (1) |
|
|
142 | (1) |
Chapter 12 Epilogue |
|
143 | (4) |
Index |
|
147 | |