Use of a spreadsheet program for Deming's linear regression analysis.
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.
Confidence Intervals↗