Econometric Analysis and Excel Application

Author: Training Center of the National Development and Reform Commission
Publisher:
Publish Date: 2005-02-01
Features: Performing econometric analysis using Excel 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 interpreting calculation results, applying the results to serve the analysis objectives, this book introduces the following: 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 important issues to illustrate calculations, allowing readers to follow the step-by-step process in the book's examples to familiarize themselves with using Excel for econometric analysis.