Steve Erfle's Excel files used in Managerial Economics

The files listed below are referred to in the paper: "Excel as a Teaching Platform for Managerial Economics:
The Experience at Dickinson College," January 2001. A revised version of this paper has been accepted for publication in Social Science Computer Review, Winter 2001. As described in that paper, files are generally of two types: 1. Excel lab exercises appropriate for students; and 2. Excel programs for use during lectures. These are listed below in the order they are used throughout the semester. Also included are links to a recent syllabus (text file); student guide to the class (text file); and day-by-day outline (Excel file).

Excel LAB EXERCISES Excel PROGRAMS FOR LECTURES

Introduction to Excel Labs 1 and 2 (Showboat)

Introduction Lab 3 (Should you go to College)

Statistics Lab (How did you do on midterm 1)

Regression Lab (Rlab) 1 (estimating demand)

RLab 2 (cross-sectional modeling)

RLab 3 (time series modeling)

RLab 4 (cost analysis I)

RLab 5 (cost analysis II)

RLab 6 (profit maximization)

Regression lecture (RLec) 1 (univariate analysis)

RLec 2 (multivariate analysis)

RLec 3a (significance vs. magnitude)

RLec 3b (introduction to residual analysis)

RLec 4a (dummy variables)

RLec 4b (multicollinearity)

RLec 5a (serial correlation)

RLec 5b (more on serial correlation)

RLec 6a (growth rates)

RLec 6b (seasonality)

RLec 7a (more on seasonality, using RLab 3)

RLec 7b (calculating seasonal indices)

Production functions

Cost Estimation 1

Cost Estimation 2

Return to Steve's home page.