Introduction to Biostatistical Applications in Health Research with Microsoft Office Excel (eBook)

Robert P. Hirsch, PhD, is on the faculty for the Foundation for the Advanced Education in the Sciences within the Graduate School at the National Institutes of Health. He is also a retired Professor of Epidemiology and Biostatistics and Adjunct Professor of Statistics at The George Washington University. Dr. Hirsch is the author of numerous books in the field of health research and practice.

1. Thinking About Chance

1.1. Properties of Chance

1.2. Venn Equations

1.3. Intersections

1.4. Unions

1.5. Conditional Probabilities

2. Describing Populations

2.1. Distributions of Data

2.2. Gaussian Distribution

2.3. Parameter of Location

2.4. Parameter of Dispersion

2.5. Standard Normal Distribution

3. Examining Samples

3.1. Point Estimates

3.2. Sampling Distribution

3.3. Central Limit Theorem

3.4. Interval Estimates

3.5. Hypothesis Testing

4. Univariable Analysis of a Continuous Dependent Variable

4.1. Student's t Distribution

4.2. Paired t-Test

5. Univariable Analysis of an Ordinal Dependent Variable

5.1. Medians

5.2. Wilcoxon Signed-Rank Test

6. Univariable Analysis of a Nominal Dependent Variable

6.1. Prevalence and Risk

6.2. Incidence

6.3. Normal Approximations

6.4. Exact Methods

7. Bivariable Analysis of a Continuous Dependent Variable

7.1. Linear Regression

7.2. Pearson's Correlation

7.3. Student's t-Test

7.4. Homoscedasticity

8. Bivariable Analysis of an Ordinal Dependent Variable

8.1. Spearman's Correlation

8.2. Mann-Whitney Test

9. Bivariable Analysis of a Nominal Dependent Variable

9.1. Test for Trend

9.2. 2 2 Tables

9.3. Ratios and Differences

9.4. Normal Approximations

9.5. Exact Methods

10. Multivariable Analysis of a Continuous Dependent Variable

10.1. Multiple Regression Analysis

10.2. Multiple Correlation Analysis

10.3. Multicollinearity

10.4. One-Way ANOVA

10.5. Factorial ANOVA

10.6. Student-Newman-Keuls Test

10.7. Analysis of Covariance

10.8. General Linear Model

11. Multivariable Analysis of an Ordinal Dependent Variable

11.1. Kruskal-Wallis Test

11.2. Dunn's Test

12. Multivariable Analysis of a Nominal Dependent Variable

12.1. Logistic Regression

12.2. Cox Regression

12.3. Stratified Analysis

12.4. Life Table Analysis

Appendix A: Flowchart

Appendix B: Statistical Tables

Appendix C: Standard Distributions

Appendix D: Excel Primer