Economic and business analysis : quantitative methods using spreadsheets /
Hsiao, Frank S. T.,
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.
9812834923 9789812834928
Microsoft Excel (Computer file)
Industrial management--Statistical methods--Computer programs
Economics--Statistical methods--Computer programs
HD30.215 / .H776 2011x
330.0285554
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.
9812834923 9789812834928
Microsoft Excel (Computer file)
Industrial management--Statistical methods--Computer programs
Economics--Statistical methods--Computer programs
HD30.215 / .H776 2011x
330.0285554