Modelling Economic Systems
A Spreadsheet-based Approach
Published on 28. March 1996
Book
Paperback/Softback
344 pages
978-0-412-70880-0 (ISBN)
Description
This work aims to enable students to use a computer as a tool to analyse, model and solve economic and business problems. It looks at the methods and problems involved in the design and construction of computer-based models of economic systems; explains the features and use of a spreadsheet package (focusing on Quattro-Pro for Windows); and examines the design, construction and use of spreadsheet-based models in several areas of economics and business. Case-studies and examples can be worked through on-screen once the underlying theory has been assimilated.
This work aims to enable students to use a computer as a tool to analyse, model and solve economic and business problems. It looks at the methods and problems involved in the design and construction of computer-based models of economic systems; explains the features and use of a spreadsheet package (focusing on Quattro-Pro for Windows); and examines the design, construction and use of spreadsheet-based models in several areas of economics and business. Case-studies and examples can be worked through on-screen once the underlying theory has been assimilated.
This work aims to enable students to use a computer as a tool to analyse, model and solve economic and business problems. It looks at the methods and problems involved in the design and construction of computer-based models of economic systems; explains the features and use of a spreadsheet package (focusing on Quattro-Pro for Windows); and examines the design, construction and use of spreadsheet-based models in several areas of economics and business. Case-studies and examples can be worked through on-screen once the underlying theory has been assimilated.
More details
Language
English
Place of publication
London
United Kingdom
Target group
College/higher education
Illustrations
166 line illustrations, further reading
Dimensions
Height: 246 mm
Width: 189 mm
Weight
333 gr
ISBN-13
978-0-412-70880-0 (9780412708800)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
Part 1 Preliminary material: hardware and software - classification of computer systems, hardware, software, using an MS-DOS microcomputer, the operating system - MS-DOS, Microsoft Windows, appendix - useful MS-DOS commands; an overview of modelling and problem-solving - design considerations - an overview, desirable features, structured techniques, case studies; model building - economic structure and reduced form, deterministic and stochastic models, static and dynamic models, analytic and simulation models, are models realistic?; simulation models - a simple multiplier model, a multiplier-accelerator model, the cobweb model. Part 2 Modelling with spreadsheets: introducing spreadsheets - features, applications, spreadsheet design, construction, sensitivity analysis, case studies; a guide to Quattro Pro for Windows - input mode, command mode, processing, command summary, function key summary, speedbars; spreadsheet graphics - creating graphs, editing a graph, graph types, case study, printing graphs; advanced spreadsheet topics - templates, macros, databases. Part 3 Spreadsheet applications: quantitative applications - descriptive statistics, the two-variable regression model, the multiple regression model, smoothing methods; computer models of the firm - a profit-maximizing monopolist, price discrimination, the Cournot model of oligopoly, Baumoi's sales maximization model; macroeconomic models - policy models, the IS/LM model, models of the UK economy; business decision support models - break-even analysis, queuing models, financial calculations - mortgages, annuities and compound interest, investment appraisal.