Microeconomics using Excel

Integrating Economic Theory, Policy Analysis and Spreadsheet Modelling

By Gerald Schwarz, Kurt Jechlitschka, Dieter Kirschke

© 2007 – Routledge

244 pages | 164 B/W Illus.

Purchasing Options:
Paperback: 9780415417877
pub: 2007-07-26
US Dollars$72.95
x
Hardback: 9780415417860
pub: 2007-08-02
Currently out of stock
US Dollars$190.00
x

Comp Exam Copy

About the Book

Using Microsoft Excel, the market leading spreadsheet package, this book combines theory with modelling aspects and spreadsheet analysis. Microeconomics Using Excel provides students with the tools with which to better understand microeconomic analysis.

It focuses on solving microeconomic problems by integrating economic theory, policy analysis and spreadsheet modelling. This unique approach facilitates a more comprehensive understanding of the link between theory and problem solving.

It is divided into four core parts:

  • analysis of price policies
  • analysis of structural policies
  • multi-market models
  • budget policy and priority settings.

The theory behind each problem is explained and each model is solved using excel. Each model is also available online and can be used as a prototype for analysis and specific needs.

Microeconomics using Excel will be of great interest to students studying economics as well as to professionals in economic and policy analysis.

Table of Contents

Introduction Part A: Analysis of Price Policies 1. Supply, Demand and Price Policies 2. Welfare and Distributional Effects 3. Price Policy Instruments 4. Iso-Elastic Supply and Demand Functions 5. Policy Formulation and Trade-Offs 6. External Effects 7. Integrated Markets 8. World Market and Third Country Effects Part B: Analysis of Structural Policies 9. Shifts of the Supply Curve 10. Implications of Structural Policies over Time 11. Optimal Structural Policies Part C: Multi-Market Models 12. Interdependencies of Markets 13. Microeconomic Foundations 14. Formulation of a 4-Market Model 15. Model Framework for a 12-Market Model Part D: Budget Policy and Priority Setting 16. Optimization Approach 17. Multiple Objectives 18. Parametric Analysis

Subject Categories

BISAC Subject Codes/Headings:
BUS000000
BUSINESS & ECONOMICS / General
BUS044000
BUSINESS & ECONOMICS / Economics / Microeconomics
COM032000
COMPUTERS / Information Technology