Intermediate Microeconomics with Excel


During the Spring 2012 semester, I arranged to have my class lectures taped. I did not edit the video (beyond removing the beginning of class when I pass out handouts and collect homework). I certainly did not use high end equipment nor try to storyboard or follow a script. Thus, the results are quite raw -- it's a historical record of what I taught at that time. As unpolished as they are, these videos may help students understand the material and instructors to see how to use the files in class so I am making them available. They also enable flipping the classroom. Simply click on a link to view a lecture (all are under an hour).

Not all chapters in the book are covered. If you only have time for one video, see IntroSupplyDemand -- it's my favorite! (Curiously, it does not use Excel . . . )

Section Topic Description
Introduction Introduction Class intro; show an optimization problem
Theory of Consumer Behavior BudgetConstraint m = p1x1 + p2x2
  Preferences Revealed preference
  Utility U=f(x1,x2)
  IntroducingOptimalChoice Max U s.t. budget constraint with calculus and Solver
  OptimalChoicePractice Quasilinear U and perfect complements
  FoodStamps Application to food stamps
  EngelCurves x1* = f(m)
  DemandCurves x1* = f(p1)
  DemandCurvesPractice Demand with quasilinear U and perfect complements
  GiffenGoods U functions that yield Giffenness
  IncSubEffects Income and substitution effects
  IncSubEffectsPractice Inc/sub with quasilinear U (no income effect)
  EndowmentModelIntro w1x1 + w2x2 = p1x1 + p2x2
  IntertemporalChoice Borrowing/saving as optimal choice
  CharitableGiving Application to charity
  RiskandReturn Optimal portfolio theory
  SafetyRegulation Peltzman's seat belt paper
Theory of the Firm ProductionFunction Y=f(L,k)
  InputCostMin Isoquant/isocost
  EnfieldArsenal Application to British rifle making
  CostFunction Deriving cost from input cost min
  CostCurves TC, TFC, TVC, MC, ATC, AVC
  OutputProfitMaxPCSR Profit max for a PC firm in the SR
  DerivingSupply q* = f(p)
  DiffusionandTechnicalChange Shutdown rule application
  InputProfitMax Max profit by choosing L and K
  DemandforLabor Short versus long run labor demand
  Consistency All three opt problems in one workbook
  Monopoly Profit max for a monopoly
  GameTheory Cournot-Nash
Market System IntroSupplyDemand Markets as an allocation mechanism
  ConsumersProducersSurplus Optimal allocationa and deadweight loss
  TaxesDWL Tax incidence and DWL
  MonopolyDWL Monopoly and DWL
  SugarQuota Application to US TRQ on sugar
  IntroEdgeworthBox Introducing the Edgeworth Box
  EquilibriumEdgeworthBox Equilibrium in the Edgeworth Box
  ParetoOptimality First Fundamental Theorem of Welfare Economics

Screencasts (short snippets of a few minutes that I will try to create more of as time permits):

Section Topic Description

Theory of Consumer Behavior

Theory of the Firm    
MarketSystem SolvertoFindGE Using Solver in an Edgeworth Box to find equilibrium
Last Updated: 6 June 2020