Microeconomics With Spreadsheets
eBook - ePub

Microeconomics With Spreadsheets

  1. 220 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Microeconomics With Spreadsheets

About this book

Microeconomics studies the choices made by individuals under conditions of scarcity of resources and time and the interaction between different decision makers. Scarcity forces economic actors to choose one opportunity among many. Microeconomics with Spreadsheets starts with the mathematical preliminaries and covers consumer theory, producer theory, general equilibrium, game theory, market structure and economics of information.

The reader will use numerical tools to analyse problems that cannot be analysed analytically. There is a natural synergy between rigorous proofs and numerical methods, since before using a numerical method one should also prove that a solution exists and analyse whether it is unique, and therefore be able to interpret properly the output of a program.


0 Readership: Third year undergraduate and honours students along with postgraduate students taking advanced courses and modules on microeconomics.
Microeconomics, Game Theory, Producer Theory, Consumer Theory, Economics of Information, Basics of Industrial Organization, Excel, The Solver0

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Microeconomics With Spreadsheets by Suren Basov in PDF and/or ePUB format, as well as other popular books in Economía & Teoría económica. We have over one million books available in our catalogue for you to explore.

Information

Publisher
WSPC
Year
2016
eBook ISBN
9789813143975

PART I

Mathematical Preliminaries

Overview
In this part, I am going to present the main mathematical tool that we will use during the course: constraint optimization. While presenting this material, I will assume that the students are familiar with calculus, matrix algebra, basic logic and set theoretic notations. However, for the reader not familiar with any of these techniques, they, together with some other techniques used in this course, are presented in the Mathematical Appendix in the last part of the book.

Chapter 1

Constraint Optimization

This chapter introduces reader to constraint optimization technique that is used through the book.
1.1 Constraint optimization with equality constraints
Often in economics, you are asked to maximize or minimize an objective function subject to some constraints. For example, consumers are assumed to maximize their utility given their budget and prices, firms often have to find an optimal way to produce a given quantity of products, which leads to minimizing cost of production taking the level of production, technology, and factor prices as given, etc. One can always turn a constraint minimization into a constraint maximization by changing the sign of the objective function. Therefore, we will formulate all results for constraint maximization problems. Ubiquity of constraint optimization problems in economics comes from the central assumption that economic agents act rationally in pursuing their self-interest. Main mathematical result that allows one to deal with the constraint optimization problems is summarized in the following theorem.
Theorem 1. Let f : X → R be a real-valued function and g : X → Rm be a mapping, where X ⊂ Rn. Let us consider the following optimization problem:
Image
Assume that the solution is achieved at x0 and vectors (∇g1(x0),...,∇gm(x0)) are linearly independent non-degenerate constraint qualifications (NDCQ). Then
Image
Intuitively, if (1.3) does not hold, one can find point x0 + δx such that
Image
Recall that
Image
Therefore, for x0 to be the optimumf(x0) · δx should be zero. Now, note that locally the surface g(x) = θ looks like a hyperplane and (∇g1(x0),...,∇gm(x0)) forms a basis (by NDCQ) in its orthogonal complement. Therefore,
Image
for some λ1,... , λm.
Proof. Note that NDCQ implies that m ≤ n. If m = n, then vectors (∇g1(x0),...,∇gm(x0)) form a basis in Rn and expansion (1.4) can be found for any vector, including ∇f(x0). Therefore, from now on, we will assume that m< n. NDCQ is equivalent to the statement that the Jacobian matrix J, defined by
Image
has full rank at x0. Therefore, it must have m independent rows. Without loss of generality, we will assume that first m rows of the Jacobian matrix, evaluated at x0, are independent.1 Therefore, Eq. (1.3) can be made to hold for
Image
by choosing
Image
where Jm is an m × m matrix formed by the first m rows of matrix J and
Image
To prove that Eq. (1.3) also holds for
Image
for the same choice of λ, recall that by the Implicit Function Theorem,2 there exist a neighborhood3 U of point x0 and continuously differentiable functions
Image
,
Image
such that
Image
for all x ∈ U . Moreover,
Image
where nm denotes vector of partial derivatives with respect to variables
Image
Note that x0 delivers an unconstraint local maximum to function
Image
Using the first-order condition for unconstraint optimization and the chain rule, one can write the following:
Image
Note that in matrix notation,
Image
which completes the proof.
Image
1.2 Constraint optimization with inequality constraints
Sometimes, relevant constraints are represented by inequalities rather than equalities. For example, a consumer may be offered a menu of choices. Relevant incentive constraints, which we will discuss later in this course, will specify that she should like the item designed for her at least as much as any other item on the menu. Generalization of the above theorem for the case of inequality constraints is given by the following theorem.
Theorem 2. Let f : X → R be a real-valued functional and g : X → Rm be a mapping, where X ⊂ Rn. Let us consider the following optimization problem:
Image
Assume that the solution is achieved at x0 and vectors (∇g1(x0),...,∇gm(x0)) are linearly independent (NDCQ).Then
Image
This statement is known as the Kunh–Tucker theorem. Intuitively, the first-order conditions state that the gradient of the objective function should look in a direction in which all the constraints are increasing, since otherwise one can move in a direction that will leave the choice variable x within the constraint set, but increase the value of the objective. I will not give the complete proof of this theorem. However, it is quite easy to see intuitively why it is true. Indeed, if a certain constraint does not...

Table of contents

  1. Cover Page
  2. Title
  3. Copyright
  4. Preface
  5. Author Biography
  6. Contents
  7. Part I Mathematical Preliminaries
  8. Part II Market Interactions
  9. Part III Strategic Interactions
  10. Part IV The Economics of Information
  11. Part V Mathematical Appendix
  12. Index