Computer Application in Economic Management - Excel Data Analysis, Statistical Forecasting and Decision Simulation (Financial and Economic Management and Computer Application)

Author: Liu Lanjuan
Publisher:
Publish Date: 2006-10-01
Features: The book consists of 5 parts and 9 chapters. Part 1, Chapter 1, is an introduction that mainly introduces the origin, characteristics, and basic content of the course on computer applications in economic management. Part 2, on the organization, querying, and classification summary analysis of economic management data, is composed of Chapters 2 and 3, which mainly introduce the basic concepts of databases, methods of data querying using Microsoft Query, four data classification summary analysis methods, the application methods of pivot tables and D functions, and methods of generating time series. Part 3, on time series forecasting and regression analysis in economic management data, is composed of Chapters 4 and 5, which mainly introduce the concept and composition of time series, methods of establishing various time series forecasting models, indicators for measuring forecasting accuracy, the basic principles of regression analysis, including the statistical testing of regression models, the use of regression analysis tools such as Solver and regression analysis reports, and methods for analyzing univariate and multivariate linear regression problems as well as nonlinear regression problems. Part 4, on the analysis of economic management decision models, is composed of Chapters 6, 7, and 8, which mainly introduce decision-making analysis methods for cost models such as break-even analysis, cost decision analysis, and economic order quantity analysis, the concept and solution methods of optimization problems, modeling methods for linear programming and nonlinear programming problems as well as other common planning problems, the establishment of investment decision models based on net present value, and the establishment of project investment evaluation models and investment risk analysis models. Part 5, on the simulation analysis of economic management data, which is Chapter 9 on simulation models, mainly introduces the basic steps of the simulation process, methods of generating random numbers and analyzing simulation results, the establishment and risk analysis of Monte Carlo simulation models, and the establishment of activity scanning system simulation models, represented by inventory simulation. This book can be used as a textbook for undergraduate and graduate students in economic management majors, as well as for MBA students, in courses such as information technology applications, quantitative methods in management, and management models and decision-making. It can also serve as a reference for economic management personnel to solve problems related to data processing, forecasting analysis, decision-making modeling, and decision-making simulation.