ERIC Number: ED336047
Record Type: RIE
Publication Date: 1991-May
Reference Count: 0
A Spreadsheet for a 2 x 3 x 2 Log-Linear Analysis. AIR 1991 Annual Forum Paper.
Saupe, Joe L.
This paper describes a personal computer spreadsheet set up to carry out hierarchical log-linear analyses, a type of analysis useful for institutional research into multidimensional frequency tables formed from categorical variables such as faculty rank, student class level, gender, or retention status. The spreadsheet provides a concrete vehicle for presenting the general nature, as well as the computational details of a log-linear procedure. The program was prepared in Symphony but can be translated to Lotus 123 or replicated readily with other spreadsheet software. It includes 11 sections or pages: one for entering observed frequencies (the only input required), one for each of 8 applicable log-linear models, one for iteratively-derived estimates of expected values for the model for the third second-order interaction and one for summary tables. The spreadsheet could be used with non-hierarchical models by copying the page for one of the models analyzed onto an empty spreadsheet range, and then changing the formulas which calculate the expected frequencies for the added model. It would also be possible to add a section to each model page of the spreadsheet in which "standardized residuals" were displayed. Five references and five tables complement the text. (JB)
Publication Type: Speeches/Meeting Papers; Reports - Research
Education Level: N/A
Authoring Institution: N/A
Identifiers: AIR Forum; Log Linear Models; Multidimensional Models; University of Missouri Columbia
Note: Paper presented at the Annual Forum of the Association for Institutional Research (31st, San Francisco, CA, May 26-29, 1991).