Share this article on:

Spreadsheet That Shows P-Value Functions

Aragaki, Corinne


University of Texas

School of Public Health, Dallas

5323 Harry Hines Boulevard V8.112

Dallas, TX 75390-9128

(address for correspondence)

To the Editor:

While visualizing the P-value function is desirable, 1 it cannot be done using standard statistical packages. I created a simple EXCEL 2000 spreadsheet to take 2 × 2 contingency table values, compute simple ratios as described in Modern Epidemiology, 2 and graph P-value functions for both the corresponding odds and risk ratios. The spreadsheet can be copied from, along with documentation. Perhaps it will aid in the instruction of epidemiology students.

Corinne Aragaki

Back to Top | Article Outline


1. Poole C. Beyond the confidence interval. Am J Public Health 1987; 77: 195–199.
2. Rothman KJ, Greenland S. Modern Epidemiology, 2nd ed. Philadelphia: Lippincott-Raven, 1998.
© 2001 Lippincott Williams & Wilkins, Inc.