NotesFAQContact Us
Search Tips
ERIC Number: ED336047
Record Type: Non-Journal
Publication Date: 1991-May
Pages: 21
Abstractor: N/A
Reference Count: N/A
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
Audience: Researchers
Language: English
Sponsor: N/A
Authoring Institution: N/A