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