Electronic Proceedings of the Thirteenth Annual International Conference on Technology in Collegiate MathematicsAtlanta, Georgia, November 16-19, 2000Paper C013Regression using Excel's Solver |
Jeff GrahamDepartment of Mathematics Western Carolina University Cullowhee, NC 28723 USA Phone: (828) 227-3944 Fax: (828) 227-7240 jgraham@wcu.edu list of all papers by this author |
| Click to access this paper: |
Additional file(s) associated with this paper:
|
ABSTRACT
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