These online workbooks are intended as a companion to Essentials of Biostatistics in Public Health, also by Lisa Sullivan. Each copy of Essentials of Biostatistics in Public Health comes packaged with an access code card that can be redeemed at: http://www.jblearning.com/accesscode .
Three workbooks illustrate statistical computing procedures using Excel. The workbooks detail procedures in Excel 2003 for the PC, Excel 2007 for the PC and Excel 2008 for the Mac. Customized Excel programs are also available to perform many of the analyses described in the textbook and these programs can be imported into any version of Excel on the PC or on the Mac. Short video clips are also available to illustrate the use of these customized programs. Instructors can make the video clips available to students so that students can work through statistical computing outside of class time and at their own pace.
The new• New chapter on nonparametric procedures (including the Mann Whitney U test, the Sign and Wilcoxon Rank Sum test, and the Kruskal Wallis test).
• New chapter on survival analysis (including estimating survival curves using the actuarial and Kaplan-Meier approaches, conducting the log rank test and producing graphical displays of survival curves).
Excel 2007 – NEW WORKBOOK!
Chapter 1 – Basics
Chapter 2 – Formulas, Functions and the Data Analysis Toolpak
Chapter 3 – Creating Tables and Graphs
Chapter 4 – Summarizing Continuous Variables in a Sample
Chapter 5 – Working with Probability Functions
Chapter 6 – Confidence Interval Estimates
Chapter 7 – Hypothesis Testing Procedures
Chapter 8 – Power and Sample Size Determination
Chapter 9 – Regression Analysis
Chapter 10 – Nonparametric Procedures
Chapter 11 – Survival Analysis
Mac 2008 – NEW WORKBOOK!
Chapter 1 – Basics
Chapter 2 – Formulas and Functions
Chapter 3 – Creating Tables and Graphs
Chapter 4 – Summarizing Continuous Variables in a Sample
Chapter 5 – Working with Probability Functions
Chapter 6 – Confidence Interval Estimates
Chapter 7 – Hypothesis Testing Procedures
Chapter 8 – Power and Sample Size Determination
Chapter 9 – Regression Analysis
Chapter 10 – Nonparametric Procedures
Chapter 11 – Survival Analysis