Electronic Proceedings of the Thirteenth Annual Conference on Technology in Collegiate Mathematics


Regression using Excel's Solver

Jeff Graham
Department of Mathematics
Western Carolina University
Cullowhee NC 28723
Phone: (828) 227-3944
Fax: (828) 227-7240
E-mail: jgraham@wcu.edu


Using Excel's built-in optimization tool called the Solver makes it possible to explore both alternative regressions to least squares and some lesser known regressions such as logistic regression. This paper will introduce the Solver and show how it is used to perform various regression analyses.