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

Atlanta, Georgia, November 16-19, 2000

Paper C013

Regression using Excel's Solver

Jeff Graham

Department of Mathematics
Western Carolina University
Cullowhee, NC 28723
Phone: (828) 227-3944
Fax: (828) 227-7240

list of all papers by this author

Click to access this paper: paper.html
Additional file(s) associated with this paper:


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.

Keyword(s): statistics, spreadsheets