Commercial packages to implement modern QSAR (quantitative structure-activity relationship) techniques are highly priced; however, the essence of QSAR can be taught without them. Microsoft Excel was used to analyze published data on anticancer activities of estradiol analogs by a QSAR approach. The resulting QSAR equations highly correlate the structural features and physicochemical properties of the analogs with the observed biological activities by multiple linear regression.
Supplement
A sample workbook (Microsoft Excel file) is available in this issue of JCE Online. The workbook contains the data, the correlation matrix, the regression outputs, and the manual on how to use the Louts tool and the Excel add-in for multiple regression.
Our Secondary School editors work hard to distill all the JCE materials to produce a fraction of particular interest to high school teachers. We call it CLIC.
In recent years we have worked hard to better match our advertisers with our readers. When shopping for chemistry education materials, visit our advertisers' WWW sites first.
Take JCE along on your outreach missions. Copies of the Journal, guest access to JCE Online, our publications catalog, and more are available for your participants.