Economic and business analysis : quantitative methods using spreadsheets /
Frank S.T. Hsiao.
- xxxiii, 636 pages : illustrations ; 26 cm
Includes bibliographical references (pages 619-620) and index.
I. Basic economic and business analysis -- The Excel worksheets -- Total revenue, total cost, and profits: Excel tables -- Static analysis in economics and business: Excel graphics -- Comparative static analysis: name that range! -- II. Basic statistics -- Some useful statistic functions: equations and formulas -- Random numbers and frequency distributions: organizing a large data base -- Regression analysis: Excel commands -- III. Private and public decision making -- Future value problems: exponential and logarithmic functions -- Present value problems: making financial decisions -- Economic policy analysis: vectors and matrices -- IV. Optimization -- Production and utility functions: 3D graphics -- Constrained optimization in the theories of production and consumption: using Excel Solver -- V. Research methods and presentation -- Research methods: Excel data analysis -- Research presentation: sharing Excel data and charts -- VI. Dynamics and comparative dynamics -- An introduction to dynamic analysis: linked cells.