A Visual Basic Program for Estimating Missing Cell Frequencies in Chi Square Tests for Association
by Richard G. Graf, Edward F. Alf, Jr., Steve Williams, and Ifeanyi Okolo
It is usually easy to calculate the chi square test for association in a table with r rows and c columns; but if the
frequency data are missing for one or more cells in the table, the analysis can be complicated. One class of such tables arises
in the analysis of transaction flows (Savage & Deutsch, 1960), such as the analysis of export/import data, emigration data, or
psychological interaction data, where the diagonal entries in the table are missing. Goodman (1968) presents an excellent
summary of methods for analyzing contingency tables with missing elements, including missing diagonals. Wagner (1970)
develops a maximum likelihood solution for estimating expected cell frequencies when the diagonal elements are missing. We
offer a slightly different solution to this problem. Each missing cell frequency is replaced with the value that would be
expected if the null hypothesis of no association between rows and columns were true. In this way, the missing cells make no
contribution to the resulting chi square. Further, replacing the missing values with their expectations yields the same
maximum likelihood solution given by Wagner (1970). A computer program for performing the analysis can be downloaded
Chi Square, Missing Cells
Edward Alf, Jr.,
Hector F. Coronel-Brizio,
READING THE ARTICLE: You can read the article in
portable document (.pdf) format (123151 bytes.)
NOTE: The content of this article is the intellectual property of the authors, who retains all rights to future publication.
This page has been accessed 2772 times since July 24, 2006.
Return to the Home Page.