How to calculate odds, odds ratios, relative risk, attributable risk & population attributable risk
Contingency Tables & Risk Calculations in Excel
In this video, we will cover how to create crosstab or contingency tables using several continuous data series and converting them into categorical data series. From there, from there we build a dynamic contingency table with COUNTIFS, and then calculates a full suite of risk measures: odds, odds ratios, relative risk, attributable risk, attributable risk percentage, population attributable risk, and population attributable risk percentage.
Chapters:
0:00 Introduction
0:37 What is a contingency table?
1:04 Selecting and copying the data
1:59 Converting continuous data to categorical
2:16 Removing non-responders
2:51 Creating the Bullied (exposure) variable with IF
4:30 Creating the score (event) variable with IF and AND
7:04 Building the crosstab with UNIQUE and TRANSPOSE
7:56 Filling the matrix with COUNTIFS
9:42 Adding totals and verifying
10:40 Formatting the table
11:24 The 2x2 A–D lettering system
11:41 Calculating odds
12:35 Odds ratio
13:20 Relative risk
15:26 Attributable risk
16:35 Attributable risk percentage
17:44 Population attributable risk (PAR)
19:01 Population attributable risk percentage
20:03 Dynamic recalculation
20:36 Recap
For more information on basic Excel skills, see my Microsoft Excel Basic Guide at https://lib.unb.ca/guides/microsoft-e...
Intro and outro music from Stereoalex at https://icons8.com/music/track/synthw...