Economics with Microsoft Excel at Wabash College

 All rights reserved.

 

The Economics Department at Wabash College makes extensive use of Microsoft Excel and Visual Basic. Below are some of the projects that we have developed.

Additional Resources
Debugging and Help

 

HISTORY OF ECONOMICS

HOTResources.xls (click to download)

Barreto

Supporting Excel workbook for "The ABCS of HOT" paper, includes links for books, syllabi, and other HOT resources. The paper provides resources—sample syllabi, information on texts, and advice on HOT course construction—for the non-historian of economics. A working paper version is available at SSRN: History of Economics

GENERAL ECONOMIC THEORY

The Economic Approach with Microsoft Excel

Barreto/Howland/Widdows

A series of Excel workbooks that comprise a 1/2 semester sophomore-level course on optimization, equilibrium, and comparative statics.

Teaching Comparative Statics with the Comparative Statics Wizard Add-in

Barreto

Comparative statics analysis using the Excel-based Comparative Statics Wizard add-in. A set of example applications are included. This link goes to DePauw University, where Dr. Barreto is now teaching.

MACROECONOMICS

Macroeconomics with Microsoft Excel

Barreto

Excel workbooks for an undergraduate Intermediate Macro course. Files that demonstrate the Solow Growth Model are available as an example.

ECONOMETRICS

Econometrics with Microsoft Excel

Barreto/Howland

Textbook using Microsoft Excel and Monte Carlo simulation to teach introductory econometrics.

Several Excel add-ins available, including: Bootstrap, Dummy Dependent Variable (Probit and Logit) with Excel's Solver and without (using a Gauss Newton algorithm), Monte Carlo simulation, Monte Carlo simulation with Solver, P Value Calculator, Histogram, and Regression.

Least Median of Squares and Regression Through the Origin

Barreto and Maharry

Explains LMS regression, in general, and focuses on LMS with a zero intercept. Shows that the popular PROGRESS code won't work with the intercept suppressed and offers an exact algorithm for the bivariate case (y = mx).

Box Model.xls

Right-click the link above and Save Target As or Download Link to your hard drive, then open the file from Excel.

Howland

Finds exact probability histogram for various chance processes and does Monte Carlo simulation.

CORPORATE FINANCE

RetirementSimulation.xls

StockSimulations.xls

CorpFinanceNestEggTalk.doc

Right-click the links above and Save Target As or Download Link to your hard drive, then open the file from Excel for the .xls files and Word for the .doc file.

Howland

Worksheets with Monte Carlo simulations of saving for retirement (Retirment.xls) and the growth of a portfolio invested in stocks and the risk-free asset (StockSimulations.xls). Also, a Word document (NestEggTalk.doc) describing and applying these simulations. The Word document is a preliminary version, which needs some editing.

Last updated: 18 October 2001

Just For Fun

Baseball Monte Carlo Simulation

Right-click the link above and Save Target As or Download Link to your hard drive, then open the file from Excel. Baseball.xls is a 250K Excel workbook.

Barreto

How many wins is a 0.350 hitter worth? Where should the best hitter bat? How about power hitters--how many wins do they get you? Play thousands of games (fast) to answer these questions.

Football Economics

Download the 46MB zipped file by clicking the link above. Extract all files, then open FootballEconomics.ppt. View the slide show--links from ppt open the other files. (Do not run the ppt from the zipped file, you must extract the files first for the links to work.)

Barreto

Why do teams pass more in the Modern Era? Why do left tackles make so much money?

Data on NFL teams from 1970-2005 and on player salaries for the 2005 season.

 


Additional Resources

Mathtools.net a free portal for links to Excel and VBA


Debugging and Help

Having problems with one of these workbooks? Please visit the Debugging page or contact us.


Contact Information

 

Humberto Barreto

Frank Howland

Department of Economics

Department of Economics

Depauw University

Wabash College

Greencastle, IN 46135

Crawfordsville, IN 47933

Email:

Email: howlandf@wabash.edu

Phone: 765-658-4531

Phone: 765.361.6317

FAX:

FAX: 765.361.6277

Last Updated: 11 Apr 2007