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

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.