|
|
|
|
2 | (1) |
|
|
3 | (2) |
|
|
5 | (1) |
|
Final Thoughts and Activities |
|
|
6 | (1) |
|
|
6 | (1) |
|
|
6 | (1) |
|
|
6 | (1) |
|
|
7 | (1) |
|
|
7 | (4) |
|
2 Introduction to Excel and Basic Charts |
|
|
11 | (36) |
|
|
11 | (1) |
|
|
11 | (1) |
|
|
12 | (13) |
|
|
25 | (2) |
|
|
27 | (3) |
|
Line Charts and Area Charts |
|
|
30 | (2) |
|
|
32 | (5) |
|
Pivot Tables (Aka Crosstabs) |
|
|
37 | (5) |
|
|
42 | (1) |
|
|
42 | (1) |
|
Final Thoughts and Activities |
|
|
42 | (1) |
|
|
42 | (1) |
|
|
43 | (1) |
|
|
43 | (1) |
|
|
43 | (1) |
|
|
43 | (4) |
|
3 Summarizing Data: Descriptive Statistics and Histograms |
|
|
47 | (32) |
|
|
47 | (1) |
|
|
47 | (3) |
|
|
50 | (1) |
|
|
50 | (1) |
|
|
50 | (1) |
|
|
50 | (7) |
|
|
57 | (15) |
|
|
72 | (3) |
|
Final Thoughts and Activities |
|
|
75 | (1) |
|
|
75 | (1) |
|
|
76 | (1) |
|
|
76 | (1) |
|
|
76 | (1) |
|
|
77 | (2) |
|
|
79 | (38) |
|
|
79 | (1) |
|
|
79 | (3) |
|
|
82 | (31) |
|
|
113 | (1) |
|
Final Thoughts and Activities |
|
|
113 | (1) |
|
|
113 | (1) |
|
|
113 | (1) |
|
|
114 | (1) |
|
|
114 | (1) |
|
|
114 | (3) |
|
|
117 | (26) |
|
|
119 | (1) |
|
|
120 | (1) |
|
|
120 | (1) |
|
|
120 | (1) |
|
|
121 | (2) |
|
|
123 | (4) |
|
|
127 | (3) |
|
|
130 | (1) |
|
Errors in Survey Question Creation |
|
|
131 | (2) |
|
Errors in Survey Data Collection |
|
|
133 | (2) |
|
|
135 | (1) |
|
|
135 | (4) |
|
Final Thoughts and Activities |
|
|
139 | (1) |
|
Practice Problems and Case Studies |
|
|
139 | (1) |
|
|
140 | (1) |
|
|
140 | (1) |
|
|
140 | (1) |
|
|
141 | (2) |
|
|
143 | (18) |
|
|
145 | (1) |
|
|
146 | (2) |
|
|
148 | (2) |
|
|
150 | (1) |
|
Problem Type: Infinite Mean |
|
|
150 | (2) |
|
Practice Problem for Infinite Mean |
|
|
152 | (1) |
|
Problem Type: Infinite Proportion |
|
|
153 | (2) |
|
Practice Problem for Infinite Proportion |
|
|
155 | (1) |
|
Finite Population Correction Factor (fpc) |
|
|
156 | (1) |
|
Final Thoughts and Activities |
|
|
157 | (1) |
|
|
157 | (1) |
|
|
157 | (1) |
|
|
157 | (1) |
|
|
158 | (1) |
|
|
158 | (3) |
|
|
161 | (22) |
|
|
161 | (1) |
|
|
161 | (4) |
|
|
165 | (1) |
|
|
165 | (1) |
|
|
165 | (4) |
|
|
169 | (1) |
|
|
169 | (1) |
|
|
169 | (2) |
|
Confidence Intervals with Proportion Inference |
|
|
171 | (1) |
|
|
171 | (1) |
|
|
171 | (7) |
|
Final Thoughts and Activities |
|
|
178 | (1) |
|
Practice Problems and Case Studies |
|
|
178 | (1) |
|
|
178 | (1) |
|
|
179 | (1) |
|
|
179 | (1) |
|
|
179 | (4) |
|
|
183 | (22) |
|
|
183 | (1) |
|
|
183 | (3) |
|
|
186 | (1) |
|
|
187 | (2) |
|
|
189 | (1) |
|
Finding Probabilities Using Normal Distributions |
|
|
189 | (6) |
|
Calculating Combinations and Permutations |
|
|
195 | (4) |
|
Finding Probabilities Using the Binomial Distribution |
|
|
199 | (2) |
|
|
201 | (1) |
|
Final Thoughts and Activities |
|
|
202 | (1) |
|
|
202 | (1) |
|
|
202 | (1) |
|
|
203 | (1) |
|
|
203 | (1) |
|
|
203 | (2) |
|
|
205 | (16) |
|
|
205 | (1) |
|
|
205 | (4) |
|
|
209 | (1) |
|
|
210 | (1) |
|
|
210 | (1) |
|
Correlation: One r Value or Correlation Matrix |
|
|
210 | (5) |
|
|
215 | (1) |
|
Final Thoughts and Activities |
|
|
215 | (1) |
|
|
215 | (1) |
|
|
216 | (1) |
|
|
216 | (1) |
|
|
217 | (1) |
|
|
217 | (4) |
|
10 Simple Linear Regression |
|
|
221 | (28) |
|
|
221 | (1) |
|
|
221 | (5) |
|
Residuals and Tests for Linearity |
|
|
226 | (2) |
|
Standardized Residuals and Outliers |
|
|
228 | (1) |
|
|
229 | (1) |
|
Scatterplot: Compute the Regression Line and the Coefficient of Determination |
|
|
230 | (4) |
|
Regression Function: Compute the Regression Model |
|
|
234 | (2) |
|
Compute Residual Plots Using the Regression Function |
|
|
236 | (2) |
|
Using Excel's Regression Tool to Test for Normality of the Distribution of Residuals |
|
|
238 | (1) |
|
Using Excel's Regression Tool to Test for Constant Variance of Residuals |
|
|
239 | (2) |
|
Summary of Regression Analysis Process |
|
|
241 | (1) |
|
|
242 | (1) |
|
Final Thoughts and Activities |
|
|
242 | (1) |
|
|
242 | (1) |
|
|
243 | (1) |
|
|
243 | (1) |
|
|
244 | (1) |
|
|
244 | (5) |
|
11 Significance Tests Part 1 |
|
|
249 | (60) |
|
|
249 | (1) |
|
|
249 | (1) |
|
|
250 | (7) |
|
|
257 | (1) |
|
|
258 | (25) |
|
|
283 | (19) |
|
|
302 | (1) |
|
Final Thoughts and Activities |
|
|
302 | (1) |
|
Practice Problems and Case Studies |
|
|
302 | (1) |
|
|
303 | (1) |
|
|
303 | (1) |
|
|
303 | (1) |
|
|
304 | (5) |
|
12 Significance Tests Part 2 |
|
|
309 | (46) |
|
|
309 | (1) |
|
|
309 | (1) |
|
|
309 | (1) |
|
|
310 | (11) |
|
|
321 | (22) |
|
|
343 | (1) |
|
Final Thoughts and Activities |
|
|
343 | (1) |
|
Practice Problems and Case Studies |
|
|
343 | (2) |
|
|
345 | (1) |
|
|
345 | (1) |
|
|
345 | (1) |
|
|
345 | (10) |
|
|
355 | (16) |
|
|
355 | (1) |
|
|
355 | (3) |
|
|
358 | (7) |
|
Step 1 Fit the Model with Selected Independent Variables |
|
|
358 | (1) |
|
Step 2 Does Multicollinearity Exist? Run a Correlation Matrix |
|
|
358 | (3) |
|
Step 3 Run Regression Model |
|
|
361 | (2) |
|
Step 4 Are the Assumptions of Regression Satisfied? |
|
|
363 | (1) |
|
Step 5 Test Overall Model Significance (F-Test) |
|
|
364 | (1) |
|
Step 6 Check p-Values for Independent Variables Meet Significance Criteria (t-Test) |
|
|
364 | (1) |
|
Step 7 Run Model for Prediction and Estimation |
|
|
364 | (1) |
|
|
365 | (1) |
|
Final Thoughts and Activities |
|
|
366 | (1) |
|
|
366 | (1) |
|
|
367 | (1) |
|
|
367 | (1) |
|
|
367 | (4) |
|
|
371 | (20) |
|
|
371 | (1) |
|
|
371 | (1) |
|
|
371 | (1) |
|
|
372 | (1) |
|
|
373 | (1) |
|
|
374 | (1) |
|
|
375 | (1) |
|
Create the Trendline Graphs |
|
|
376 | (5) |
|
Using the Non-linear Regression Trendline for Prediction |
|
|
381 | (3) |
|
|
384 | (1) |
|
Final Thoughts and Activities |
|
|
385 | (1) |
|
Practice Problems and Case Studies |
|
|
385 | (1) |
|
|
386 | (1) |
|
|
386 | (1) |
|
|
387 | (1) |
|
|
387 | (4) |
|
|
391 | (23) |
|
|
394 | (1) |
|
|
395 | (5) |
|
Useful Hints and Phrases for the Report |
|
|
400 | (1) |
|
Effective PowerPoint Presentations with Excel |
|
|
400 | (1) |
|
|
401 | (1) |
|
|
402 | (1) |
|
Sampling Plan and Survey Creation |
|
|
402 | (1) |
|
|
403 | (4) |
|
Conclusions and Recommendations |
|
|
407 | (1) |
|
Final Thoughts and Activities |
|
|
408 | (1) |
|
Practice Problems and Case Studies |
|
|
408 | (2) |
|
|
410 | (1) |
|
|
410 | (1) |
|
|
410 | (1) |
|
|
410 | (1) |
|
|
411 | (1) |
|
Background and Objectives |
|
|
411 | (1) |
|
|
412 | (1) |
|
|
412 | (1) |
|
Conclusions and Recommendations |
|
|
413 | (1) |
Bibliography |
|
414 | (1) |
Appendix 1 |
|
414 | (1) |
Index |
|
415 | |