Spread-sheet analysis in pharmacokinetic simulations

A radioimmunoassay program for Lotus 1-2-3

Spreadsheet programs have become very popular as convenient ways of performing mathematical operations, as well as entering and organizing data. This paper describes how Lotus 1-2-3 can be used to calculate the results of a radioimmunoassay, a widely used technique in biomedical laboratories.

The use of LOTUS 1-2-3 in statistics

This paper describes a convenient way of performing statistical tests in biology. The recent development of powerful spreadsheet programs for microcomputers has made it possible to easily apply various statistical significance tests on biological data. Presently the following tests have been implemented in the LOTUS 1-2-3 framework: Student's t-test, chi-square test, analysis of variance (single classification random ANOVA), Student-Neumann-Kuels test, correlation analysis and analysis of linear regression (single and multilevel design). The most important advantages gained by using 1-2-3 instead of the commercial statistical software packages are the simplicity of entering data, the possibility of asking "what-if?" questions, the simple, but useful graphical presentation of data and the ease of actual building of the tests.