ELC Stats in Excel Basic Slides Setting Up
ELC Stats in Excel Basic Slides
Setting Up Logic Formulas (if, then, else) • Why? • • Case definitions Missing dates for age calculations Yes vs. Yes & Maybe Cases vs. Controls • IF/THEN in Excel • • Single Nested COUNTIF COUNTA
IF/THEN in Excel • Place holder • Thoughts (GL) – Demo some basic examples
Descriptive Summary Table and Graphs • Min, Max, Median (Age) • Age Categories via VLOOKUP • Percentage (Gender, Race, Ethnicity) • Epi Curves
Summaries in Excel • Place holder • Thoughts (GL) – spend some time really explaining VLOOKUP
Exposure Summary Table • Linking exposure data • Linking or displaying control data • Showing the stats (see next stats slide)
Exposure Data in Excel • Place holder • Thoughts (GL) – Pros and cons of how and what to link
Case-Control or Case-Case Stats • Odds Ratio (OR) • Ninety-Five Percent Confidence Interval (95% CI) • Chi-squared statistic (χ2) • p-value
Odds Ratio (OR) • Exposure Yes No Total Cases a b a+b “Controls” c d c+d Total a+c b+c a+b+c+d
OR in Excel • Place holder • Thoughts (GL) – this one should be quick
95% Confidence Interval (CI) • SD = Standard Deviation SE = Standard Error
95% CI in Excel • Place holder • Thoughts (GL) – tips to manage long formulas
χ2 statistic • Exposure Yes No Total Cases a b a+b “Controls” c d c+d Total a+c b+d a+b+c+d
χ2 in Excel • Place holder • Thoughts (GL) – reinforce tips for long formulas
P-value • Degrees of freedom (df) = (# columns-1) x (# rows-1) • For a 2 x 2 table, df = 1 • In Excel…
P-value in Excel • Place holder • Thoughts (GL) – conditional formatting, if <0. 05 then make red.
Xkcd. com
- Slides: 17