Use of a Lotus 1-2-3 spreadsheet to plot the confidence and the prediction intervals in linear regression analysis
โ Scribed by Luc P. Brion
- Publisher
- Elsevier Science
- Year
- 1990
- Tongue
- English
- Weight
- 442 KB
- Volume
- 20
- Category
- Article
- ISSN
- 0010-4825
No coin nor oath required. For personal study only.
โฆ Synopsis
Computer-derived spreadsheet programs such as Lotus 1-2-3 are being used by many investigators for individualized statistical calculations. Spreadsheet templates have been described for the performance of simple statistical tests by non-statisticians with relatively limited computer experience. This paper describes a template for use with Lotus 1-2-3 for automatic graphic display of confidence and prediction intervals of simple linear regression analysis. The graph can be printed using the Lotus printgraph program. The program also allows comparison of the slope and the intercept of two regression lines.
๐ SIMILAR VOLUMES
Obtaining unknown NMR parameters from experimental spectra of exchanging systems is, from a mathematical point of view, associated with the solution of an inverse problem. Inverse problems are usually solved by iterative procedures and calculations may not always converge and the solutions are rarel