Abstract
An original LOTUS 1-2-3 spreadsheet has been developed to perform quantitative structure activity/structure property relationship analysis using stepwise multiple parameter regression analysis method. 1-2-3's advanced macro commands have been used to prepare the spreadsheet to perform this statistical treatment of the data. Linear as well as parabolic relationships can be searched using the spreadsheet. The results can be directed to a text file and graphs can be plotted using an automatic graphing macro. Correlation matrix can also be obtained using a separate macro.
