Related Experiment Videos
Use of a spreadsheet program for Deming's linear regression analysis
Computer Methods and Programs in Biomedicine
|March 1, 1992
Abstract:
A spreadsheet program for Deming's linear regression analysis suitable for use with popular software packages such as Lotus 1-2-3 or Quattro is described. The program is controlled by an autoexecuting simple menu of operations allowing use by those with only limited experience of spreadsheet operation. Regression coefficients, identification of suspect outlying data values and confidence limits and graphical displays of fitted regression lines are provided.