Econometric Analysis and Excel Application

Author: Organized and written by the Training Center of the National Development and Reform Commission
Publisher:
Publish Date: 2005-02-01
Features: Using Excel for econometric analysis is highly convenient and straightforward. First, output the data into an Excel worksheet, then use relevant functions or create custom formulas based on the analysis objectives. The computer will automatically calculate the results and generate charts. To help readers better utilize Excel for econometric analysis, including creating custom formulas and understanding calculation results, and applying the results to serve the analysis objectives, this book introduces the following topics: basic Excel operations, Excel data management functions, descriptive statistics for a single variable, statistical analysis of a single sample, descriptive statistics for multiple variables, statistical analysis methods for two or three variables, nonparametric statistical analysis, time series analysis, multiple linear regression, dummy variables, financial analysis, simultaneous equation models, and the general principles of input-output analysis. Examples are provided for key issues to illustrate calculations, allowing readers to follow the step-by-step process in the book's examples to become familiar with using Excel for econometric analysis.