by Frank S T Hsiao (University of Colorado, Boulder, USA)

This textbook introduces the computer skills necessary for modern-day undergraduate and graduate students to succeed in economic and business analysis. This self-contained book features innovative applications of Excel commands, equations, formulas, and graphics. In addition, the exposition of the basic concepts, models, and interpretations are presented intuitively and graphically without compromising the rigor of analysis.

The book contains numerous engaging and innovative examples and problem sets. Practical applications are also highlighted, including the introduction and discussion of key concepts. They show how Excel can be used to solve theoretical and practical problems. This book will be of interest to students, instructors, and researchers who wish to find out more about the applications of Excel in economics and business.

• Basic Economic and Business Analyses:
  • The Excel Worksheets
  • Total Revenue, Total Cost, and Profits — The Excel Tables
  • Static Analysis in Economics and Business — Excel Graphics
  • Comparative Static Analysis — Name That Range
• Economic and Business Statistics and Mathematics:
  • Economic Statistics and Regression Analysis — Equations and Formulae
  • Random Numbers and Frequency Distribution — A Large Data Base
  • Future and Present Value Problems with or without Annuity — Decision Problems
  • Linear Algebra and Economic Policy Analysis — Vectors and Matrices
• Optimization:
  • Production Functions — 3D Graphics
  • Optimization with a Constraint — The Excel Solver
• Large Data Bases:
  • The State of the World — Sorting, Filtering, Subtotaling, and Pivot Tables
  • Online Resources — The Text Import Wizard
  • Structure of Economics — Flow Charts and Slide
• Dynamics:
  • Business Cycles and Dynamic Models-Linked Cells
  • Chaos in Classroom — Butterfly Effects