TY - BOOK AU - Hsiao,Frank S.T. TI - Economic and business analysis: quantitative methods using spreadsheets SN - 9812834923 AV - HD30.215 .H776 2011x U1 - 330.0285554 22 PY - 2010/// CY - Singapore, Hackensack, N.J. PB - World Scientific KW - Microsoft Excel (Computer file) KW - Industrial management KW - Statistical methods KW - Computer programs KW - Economics N1 - 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 ER -