|
|
|
|
|
|
|
|
|
|
|
1.1 How This Book Differs from Other Statistics Texts. |
|
|
|
1.2 Statistical Applications in Health Policy and Health Administration. |
|
|
|
Exercises for Section 1.2. |
|
|
|
1.3 What Is the ""Big Picture""? |
|
|
|
1.4 Some Initial Definitions. |
|
|
|
Exercises for Section 1.4. |
|
|
|
1.5 Five Statistical Tests. |
|
|
|
Exercises for Section 1.5. |
|
|
|
|
|
2 Excel as a Statistical Tool. |
|
|
|
|
|
Exercises for Section 2.1. |
|
|
|
2.2 Working and Moving Around in a Spreadsheet. |
|
|
|
Exercises for Section 2.2. |
|
|
|
|
|
Exercises for Section 2.3. |
|
|
|
|
|
Exercises for Section 2.4. |
|
|
|
|
|
Exercises for Section 2.5. |
|
|
|
2.6 Sorting a String of Data. |
|
|
|
Exercise for Section 2.6. |
|
|
|
2.7 The Data Analysis Pack. |
|
|
|
2.8 Functions That Give Results in More Than One Cell. |
|
|
|
Exercises for Section 2.8. |
|
|
|
2.9 The Dollar Sign ($) Convention for Cell References. |
|
|
|
|
|
3 Data Acquisition: Sampling and Data Preparation. |
|
|
|
|
|
Exercises for Section 3.1. |
|
|
|
|
|
Exercises for Section 3.2. |
|
|
|
3.3 Data Access and Preparation. |
|
|
|
Exercises for Section 3.3. |
|
|
|
|
|
|
|
4 Data Display: Descriptive Presentation, Excel Graphing Capability. |
|
|
|
4.1 The =FREQUENCY() Function. |
|
|
|
Exercises for Section 4.1. |
|
|
|
4.2 Using the Pivot Table to Generate Frequencies of Categorical Variables. |
|
|
|
Exercises for Section 4.2. |
|
|
|
4.3 A Logical Extension of the Pivot Table: Two Variables. |
|
|
|
Exercises for Section 4.3. |
|
|
|
Appendix: Using Excel 2007 to Generate Pivot Tables with One Variable. |
|
|
|
|
|
5 Basic Concepts of Probability. |
|
|
|
5.1 Some Initial Concepts and Definitions. |
|
|
|
Exercises for Section 5.1. |
|
|
|
5.2 Marginal Probabilities, Joint Probabilities, and Conditional Probabilities. |
|
|
|
Exercises for Section 5.2. |
|
|
|
5.3 Binomial Probability. |
|
|
|
Exercises for Section 5.3. |
|
|
|
5.4 The Poisson Distribution. |
|
|
|
Exercises for Section 5.4. |
|
|
|
5.5 The Normal Distribution. |
|
|
|
|
|
6 Measures of Central Tendency and Dispersion: Data Distributions. |
|
|
|
6.1 Measures of Central Tendency and Dispersion. |
|
|
|
Exercises for Section 6.1. |
|
|
|
6.2 The Distribution of Frequencies. |
|
|
|
Exercises for Section 6.2. |
|
|
|
6.3 The Sampling Distribution of the Mean. |
|
|
|
Exercises for Section 6.3. |
|
|
|
6.4 Mean and Standard Deviation of a Discrete Numerical Variable. |
|
|
|
Exercises for Section 6.4. |
|
|
|
6.5 The Distribution of a Proportion. |
|
|
|
Exercises for Section 6.5. |
|
|
|
|
|
Exercises for Section 6.6. |
|
|
|
|
|
|
|
7 Confidence Limits and Hypothesis Testing. |
|
|
|
7.1 What Is a Confidence Interval? |
|
|
|
Exercises for Section 7.1. |
|
|
|
7.2 Calculating Confidence Limits for Multiple Samples. |
|
|
|
Exercises for Section 7.2. |
|
|
|
7.3 What Is Hypothesis Testing? |
|
|
|
Exercises for Section 7.3. |
|
|
|
7.4 Type I and Type II Errors. |
|
|
|
Exercises for Section 7.4. |
|
|
|
7.5 Selecting Sample Sizes. |
|
|
|
Exercises for Section 7.5. |
|
|
|
|
|
8 Statistical Tests for Categorical Data. |
|
|
|
8.1 Independence of Two Variables. |
|
|
|
Exercises for Section 8.1. |
|
|
|
8.2 Examples of Chi-Square Analyses. |
|
|
|
Exercises for Section 8.2. |
|
|
|
8.3 Small Expected Values in Cells. |
|
|
|
Exercises for Section 8.3. |
|
|
|
|
|
9 t Tests for Related and Unrelated Data. |
|
|
|
|
|
Exercises for Section 9.1. |
|
|
|
9.2 A t Test for Comparing Two Groups. |
|
|
|
Exercises for Section 9.2. |
|
|
|
9.3 A t Test for Related Data. |
|
|
|
Exercises for Section 9.3. |
|
|
|
|
|
|
|
10.1 One-Way Analysis of Variance. |
|
|
|
Exercises for Section 10.1. |
|
|
|
10.2 ANOVA for Repeated Measures. |
|
|
|
Exercises for Section 10.2. |
|
|
|
10.3 Factorial Analysis of Variance. |
|
|
|
Exercises for Section 10.3. |
|
|
|
|
|
11 Simple Linear Regression. |
|
|
|
11.1 Meaning and Calculation of Linear Regression. |
|
|
|
Exercises for Section 11.1. |
|
|
|
11.2 Testing the Hypothesis of Independence. |
|
|
|
Exercises for Section 11.2. |
|
|
|
11.3 The Excel Regression Add-In. |
|
|
|
Exercises for Section 11.3. |
|
|
|
11.4 The Importance of Examining the Scatterplot. |
|
|
|
11.5 The Relationship Between Regression and the t Test. |
|
|
|
Exercises for Section 11.5. |
|
|
|
|
|
12 Multiple Regression: Concepts and Calculation. |
|
|
|
|
|
Exercises for Section 12.1. |
|
|
|
12.2 Multiple Regression and Matrices. |
|
|
|
Exercises for Section 12.2. |
|
|
|
|
|
13 Extensions of Multiple Regression. |
|
|
|
13.1 Dummy Variables in Multiple Regression. |
|
|
|
Exercises for Section 13.1. |
|
|
|
13.2 The Best Regression Model. |
|
|
|
Exercises for Section 13.2. |
|
|
|
13.3 Correlation and Multicolinearity. |
|
|
|
Exercises for Section 13.3. |
|
|
|
13.4 Nonlinear Relationships. |
|
|
|
Exercises for Section 13.4. |
|
|
|
|
|
14 Analysis with a Dichotomous Categorical Dependent Variable. |
|
|
|
14.1 Introduction to the Dichotomous Dependent Variable. |
|
|
|
14.2 An Example with a Dichotomous Dependent Variable: Traditional Treatments. |
|
|
|
Exercises for Section 14.2. |
|
|
|
14.3 Logit for Estimating Dichotomous Dependent Variables. |
|
|
|
Exercises for Section 14.3. |
|
|
|
14.4 A Comparison of Ordinary Least Squares, Weighted Least Squares, and Logit. |
|
|
|
Exercises for Section 14.4. |
|
|
|
|
|
|
|
|
|
|