How to construct Pivot tables

Prepared by
A Rauf Sayed
School of Public Health, UCT

Use “Pivot Tables” in Excel to construct one-way or two-way frequency distribution tables for categorical data.

Example: Suppose you wish to construct a 2-way frequency table from your Excel data sheet (HPT data) to determine the relationship between hypertension and gender.