The Economic Approach

with Microsoft Excel

Copyright 1994 - present All versions All Rights Reserved

 

This page contains sample pdf handouts and Microsoft Excel labs. You will need Adobe Acrobat Reader (3.0 or greater) and Microsoft Excel (97 or greater) to view the sample files.

 

Chapter Readings via Adobe Acrobat pdf format

Step 1: Getting Adobe Acrobat® Reader with Search

You will need the free Adobe Acrobat® Reader application to view or print the handouts. Adobe Acrobat Reader without Search is the one most people have and it will work. But Adobe Acrobat Reader with Search enables you to take advantage of the full text searching power of Adobe Acrobat. If you do not have Adobe Acrobat® Reader with Search currently installed, you can download it from:

Acrobat.GIF
http://www.adobe.com/prodindex/acrobat/readstep.html

Step 2: Getting the handouts in pdf format

Once you have Adobe Acrobat installed, click on the files below to get an idea of the content and style of the Economic Approach with Microsoft Excel. While the links within the pdf files are not operational in these sample files and the index is not searchable (because you are downloading the pdf file and therefore separating it from the entire collection of pdf files), you can see how the readings are used in conjunction with the Excel files.

  • Chapter 0: Introduction An explanation of the motivation and goals of our work.
  • Table of Contents A listing of the topics covered.
  • Chapter 4: Single Variable Unconstrained Optimization Using Solver The companion handout to the first lab on optimization in which a lifeguard decides how far to run along the sand before jumping in the water in order to minimize the time to save a drowning victim. You can also download the Excel lab and answer key. Scroll down to see how.
  • Chapter 15: Equilibrium Profits in an Entry/Exit Model: Understanding Phase Diagrams The companion handout to a lab that illustrates the ideas behind equilibrium and introduces phase diagrams as a graphical device to understand the type of equilibration process. You can also download the Excel lab and answer key. Scroll down to see how.
  •  

    Two Sample Excel Labs

    By clicking on the Microsoft Excel files below, you will download the file to your browser's download directory. You may need to launch Microsoft Excel, then navigate to your browser's download folder to open the file.

    Different browsers handle downloads differently, but the idea is to save the file somewhere so that you can open it with Excel. For example, your browser may warn you that you are about to download a file onto your hard drive or it may ask you if you want to save the file to disk in order to protect your computer from a virus. Do pay close attention to where the file is saved so that you can easily find it from Excel. If your browser is configured with Excel as a "helper application" or "plug in," it will automatically launch Excel to view the file. This saves you the work of having to launch Excel and open the file manually.

    Make sure you choose to Enable Macros when you open the Excel file. All of the workbooks in The Economic Approach with Microsoft Excel contain macros that enable optimum viewing and provide hints for the student. If you disable the macros, the sheets will look ugly and none of the buttons or additional menu items will work.

  • Chapter 4: Single Variable Unconstrained Optimization Using Solver
  • Answers to Chapter 4: Single Variable Unconstrained Optimization Using Solver
  • Chapter 15: Equilibrium Profits in an Entry/Exit Model: Understanding Phase Diagrams
  • Answers to Chapter 15: Equilibrium Profits in an Entry/Exit Model: Understanding Phase Diagrams
  •  

    Please send questions and comments to: Bert, Frank and Kay

    Contact Us
    Description
    Samples
    Download All
    Class Home Page
    Econ Dept