Microeconomics using Excel : Integrating Economic Theory, Policy Analysis and Spreadsheet Modelling book cover
1st Edition

Microeconomics using Excel
Integrating Economic Theory, Policy Analysis and Spreadsheet Modelling

ISBN 9780415417877
Published September 12, 2007 by Routledge
256 Pages 164 B/W Illustrations

FREE Standard Shipping
USD $69.95

Prices & shipping based on shipping country


Book Description

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.

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

Publisher’s Note

The publisher has gone to great lengths to ensure the quality of this book but regrets to inform the customer that previously available online resources are no longer available with this title.

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


View More



Kurt Jechlitschka and Dieter Kirschke are at the Humboldt University of Berlin, and Gerald Schwarz is at the Macaulay Institute, Aberdeen.