Title
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.
Year
DOI
Venue
2008
10.1080/03610910802154241
COMMUNICATIONS IN STATISTICS-SIMULATION AND COMPUTATION
Keywords
DocType
Volume
computational efficiency, hat matrix, leverage, PRESS, prediction intervals, statistical computing
Journal
37
Issue
ISSN
Citations 
8
0361-0918
0
PageRank 
References 
Authors
0.34
0
3
Name
Order
Citations
PageRank
Frank G. Landram1193.84
Robert J. Pavur2494.82
Bahram Alidaee343935.91