Biomaterial Database

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

L P Brion

Department of Pediatrics, Albert Einstein College of Medicine, Bronx, New York.

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.

UI	MeSH Term	Description	Entries
D008432	Mathematical Computing	Computer-assisted interpretation and analysis of various mathematical functions related to a particular problem.	Statistical Computing,Computing, Statistical,Mathematic Computing,Statistical Programs, Computer Based,Computing, Mathematic,Computing, Mathematical,Computings, Mathematic,Computings, Mathematical,Computings, Statistical,Mathematic Computings,Mathematical Computings,Statistical Computings
D011381	Programming Languages	Specific languages used to prepare computer programs.	Language, Programming,Languages, Programming,Programming Language
D012044	Regression Analysis	Procedures for finding the mathematical function which best describes the relationship between a dependent variable and one or more independent variables. In linear regression (see LINEAR MODELS) the relationship is constrained to be a straight line and LEAST-SQUARES ANALYSIS is used to determine the best fit. In logistic regression (see LOGISTIC MODELS) the dependent variable is qualitative rather than continuously variable and LIKELIHOOD FUNCTIONS are used to find the best relationship. In multiple regression, the dependent variable is considered to depend on more than a single independent variable.	Regression Diagnostics,Statistical Regression,Analysis, Regression,Analyses, Regression,Diagnostics, Regression,Regression Analyses,Regression, Statistical,Regressions, Statistical,Statistical Regressions
D003196	Computer Graphics	The process of pictorial communication, between human and computers, in which the computer input and output have the form of charts, drawings, or other appropriate pictorial representation.	Computer Graphic,Graphic, Computer,Graphics, Computer
D012984	Software	Sequential operating programs and data which instruct the functioning of a digital computer.	Computer Programs,Computer Software,Open Source Software,Software Engineering,Software Tools,Computer Applications Software,Computer Programs and Programming,Computer Software Applications,Application, Computer Software,Applications Software, Computer,Applications Softwares, Computer,Applications, Computer Software,Computer Applications Softwares,Computer Program,Computer Software Application,Engineering, Software,Open Source Softwares,Program, Computer,Programs, Computer,Software Application, Computer,Software Applications, Computer,Software Tool,Software, Computer,Software, Computer Applications,Software, Open Source,Softwares, Computer Applications,Softwares, Open Source,Source Software, Open,Source Softwares, Open,Tool, Software,Tools, Software
D016001	Confidence Intervals	A range of values for a variable of interest, e.g., a rate, constructed so that this range has a specified probability of including the true value of the variable.	Confidence Interval,Interval, Confidence,Intervals, Confidence
D016014	Linear Models	Statistical models in which the value of a parameter for a given value of a factor is assumed to be equal to a + bx, where a and b are constants. The models predict a linear regression.	Linear Regression,Log-Linear Models,Models, Linear,Linear Model,Linear Regressions,Log Linear Models,Log-Linear Model,Model, Linear,Model, Log-Linear,Models, Log-Linear,Regression, Linear,Regressions, Linear

Related Publications

L P Brion

VSTRGRSN: a LOTUS 1-2-3 spreadsheet for variance-stabilized linear regression applied to the analysis of drugs in biological fluids.

October 1991, Journal of pharmaceutical sciences,

L P Brion

Use of a spreadsheet program for Deming's linear regression analysis.

March 1992, Computer methods and programs in biomedicine,

L P Brion

Confidence intervals vs reference intervals for regression analysis: which one to use?

August 2018, Ultrasound in obstetrics & gynecology : the official journal of the International Society of Ultrasound in Obstetrics and Gynecology,

L P Brion

Use of Lotus 1-2-3 spreadsheet software for managing and analyzing genetic backcross data.

January 1988, BioTechniques,

L P Brion

A Comparative Investigation of Confidence Intervals for IndependentVariables in Linear Regression.

January 2016, Multivariate behavioral research,

L P Brion

Fast Bootstrap Confidence Intervals for Continuous Threshold Linear Regression.

January 2019, Journal of computational and graphical statistics : a joint publication of American Statistical Association, Institute of Mathematical Statistics, Interface Foundation of North America,

L P Brion

Confidence and prediction intervals for generalised linear accident models.

March 2005, Accident; analysis and prevention,

L P Brion

Confidence intervals for estimates based on linear regression in forensic anthropology.

September 1988, Journal of forensic sciences,

L P Brion

The use of LOTUS 1-2-3 in statistics.

January 1987, Computers in biology and medicine,

L P Brion

Tips and techniques. Use of Lotus 1-2-3 for budget analysis.

January 1987, Current concepts in hospital pharmacy management,