Teaching Comparative Statics with Microsoft Excel

All rights reserved.


 

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.

Description and Rationale

More detail on what the CS Wiz does and how it can be used.

Download and Installation

Complete instructions on how to access the CSWiz add-in.

Examples

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.

 

Contact the Author

Humberto Barreto

Department of Economics

Wabash College

Crawfordsville, IN 47933

 

Email: barretoh@wabash.edu

Phone: 765.361.6315

FAX: 765.361.6277

 

[Description and Rationale] [Download and Installation] [Examples]