An Algorithm for Enhancing Spreadsheet Regression with Out-of-Sample Statistics

Abstract

An innovative algorithm is developed for obtaining spreadsheet regression measures used in computing out-of-sample statistics. This algorithm alleviates the leave-one-out computational simulation complexity and memory size problems perceived in computing these statistics. Hence, the purpose of this article is to describe a computationally enhanced algorithm that gives spreadsheet users advanced regression capabilities thereby adding a new dimension to spreadsheet regression operations. These statistics include diagonals of the hat matrix, legitimate forecasting intervals, and PRESS residuals. These computational innovations promote learning while eliminating spreadsheet inadequacies thereby making spreadsheet regression attractive to academicians in teaching and practitioners in acquiring further application competence.

Keywords:

• Computational efficiency
• Hat matrix
• Leverage
• PRESS
• Prediction intervals
• Statistical computing

Mathematics Subject Classification:

• 62JXX, Linear inference, Regression
• 62J05, Linear regression
• 62J20, Diagnostics