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 Citations (Scopus)

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

Fingerprint

Spreadsheets
Linear regression
Regression analysis
Linear Models
Regression Analysis
Confidence Intervals
Statistical tests
Display devices
Research Personnel

Keywords

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

ASJC Scopus subject areas

  • Computer Science Applications

Cite this

@article{7b88e0aefea6425bb05d531f92d5c592,
title = "Use of a Lotus 1-2-3 spreadsheet to plot the confidence and the prediction intervals in linear regression analysis",
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.",
keywords = "Confidence interval, Linear regression analysis, Plot, Prediction interval, Spreadsheet",
author = "Brion, {Luc P.}",
year = "1990",
doi = "10.1016/0010-4825(90)90035-N",
language = "English (US)",
volume = "20",
pages = "129--134",
journal = "Computers in Biology and Medicine",
issn = "0010-4825",
publisher = "Elsevier Limited",
number = "2",

}

TY - JOUR

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

AU - Brion, Luc P.

PY - 1990

Y1 - 1990

N2 - 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.

AB - 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.

KW - Confidence interval

KW - Linear regression analysis

KW - Plot

KW - Prediction interval

KW - Spreadsheet

UR - http://www.scopus.com/inward/record.url?scp=0025046996&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0025046996&partnerID=8YFLogxK

U2 - 10.1016/0010-4825(90)90035-N

DO - 10.1016/0010-4825(90)90035-N

M3 - Article

C2 - 2364679

AN - SCOPUS:0025046996

VL - 20

SP - 129

EP - 134

JO - Computers in Biology and Medicine

JF - Computers in Biology and Medicine

SN - 0010-4825

IS - 2

ER -