9 June 2010
The material below and on this web site was originally created in 2000 and published in The Journal of Economic Education Volume 32, Number 4 / Fall 2001 Pages: 397 - 397.
The web site was originally located at Wabash College, but I have since moved to DePauw University. I have upgraded the CSWiz software as Excel has evolved. The basic code remains the same, but it is now compatible with all versions of Solver up to Excel 2010. Some of the materials below are dated, but the examples and explanation are still valid, thus I am leaving this web site as originally written, following the demarcation line below.
You should use only the latest version of the Comparative Statics Wizard, available here: CSWiz.xla
For detailed instructions on installation and use for versions of Excel from 97 to 2010, download this zip file and extract the four files in it: CSWiz.zip
The materials on this site are centered around a Microsoft Excel add-in called the Comparative Statics Wizard. The CS Wiz works with Excel's Solver to repeatedly resolve an optimization problem or equilibrium model for different values of an exogenous variable, ceteris paribus. The results are presented in a well-organized sheet where additional calculations (e.g., slope or elasticity) and graphs are easily generated.
Once installed, use the CS Wiz add-in on your own optimization problems and equilibrium models within Excel. Submit your outstanding examples so others can improve the teaching and learning of economics.
More detail on what the CS Wiz does and how it can be used.
Complete instructions on how to access the CSWiz add-in.
A few applications to get you started, from the routine demand curve and profit maximization applications to a Baumol-Tobin Cash Management Model and the Lifeguard Problem.
Department of Economics
Crawfordsville, IN 47933
[Description and Rationale] [Download and Installation] [Examples]