Use of a Lotus 1-2-3 spreadsheet to plot the confidence and the prediction intervals in linear regression analysis

Research output: Contribution to journalArticle

4 Scopus citations

Abstract

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.

Original languageEnglish (US)
Pages (from-to)129-134
Number of pages6
JournalComputers in Biology and Medicine
Volume20
Issue number2
DOIs
StatePublished - 1990

Keywords

  • Confidence interval
  • Linear regression analysis
  • Plot
  • Prediction interval
  • Spreadsheet

ASJC Scopus subject areas

  • Computer Science Applications
  • Health Informatics

Fingerprint Dive into the research topics of 'Use of a Lotus 1-2-3 spreadsheet to plot the confidence and the prediction intervals in linear regression analysis'. Together they form a unique fingerprint.

  • Cite this