ECONOMIC AND BUSINESS ANALYSIS

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.

The Instructor's manual is available upon request for all instructors who adopt this book as a course text. Please send your request to sales@wspc.com.

Contents:

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!
Basic Statistics:
- Some Useful Statistic Functions — Equations and Formulas
- Random Numbers and Frequency Distributions — Organizing a Large Data Base
- Regression Analysis — Excel Commands
Private and Public Decision Making:
- Future Value Problems — Exponential and Logarithmic Functions
- Present Value Problems — Making Financial Decisions
- Economic Policy Analysis — Vectors and Matrices
Optimization:
- Production and Utility Functions — 3D Graphics
- Constraint Optimization in the Theories of Production and Consumption — Using Excel Solver
Research Methods and Presentation:
- Research Methods — Excel Data Analysis
- Research Presentation — Sharing Excel Tables and Charts
Dynamics and Comparative Dynamics:
- An Introduction to Dynamic Analysis — Linked Cells

Readership: Upper-level undergraduate and graduate students in economics or business; quantitative researchers.

“Professor Hsiao has written a remarkable and useful book covering statistics and basic economic analysis. It unifies these usually disparate topics via a common analytical framework of Excel spreadsheets. The book is both practical and theoretically sophisticated.”

Jerry R Green
John Leverett Professor in the University
Harvard University

“As politicians know, economists have two hands. But as Professor Hsiao shows in this magisterial 'how-to' book on conquering the intricacies of spread-sheets, an extra 'helping hand' is not only useful, but necessary. This is a 'hand' worth shaking when you finish — to say 'thank you'.”

Ronald W Jones
Xerox Professor of Economics
University of Rochester

“The most powerful way to learn concepts and models in economics is to work with concrete examples, and Professor Hsiao's text teaches the spreadsheet tools necessary to implement numerous illustrations of a variety of microeconomic and macroeconomic models. Frank Hsiao has been developing these instructional materials as part of his courses at the University of Colorado for more than twenty-five years. Anyone who works through this text will learn principles of economics in depth, and also become very proficient in the use of spreadsheets for analysis and presentation in fields beyond business and economics.”

Robert McNown
Professor of Economics and Director of the Program on International Affairs
University of Colorado

672pp		Pub. date: Apr 2011
ISBN: 978-981-283-492-8 981-283-492-3		US$96 / £66

Imperial College Press \| Global Publishing \| Asia-Pacific Biotech News \| Innovation Magazine Labcreations Co \| Meeting Matters \| National Academies Press Copyright © 2012 World Scientific Publishing Co. All rights reserved. Updated on 13 February 2012