Excel in the Application of Economics and Mathematical Statistics

Author: Sun Zhigang Yang Cong
Publisher:
Publish Date: 2004-01-01
Features: Excel 2002 is an excellent office software, highly suitable for data analysis and processing in fields such as economics, mathematical statistics, and scientific data processing. This book introduces the application of Excel in statistics primarily through practical examples. The book is divided into five main parts:
Part 1: Basics
This section comprehensively and systematically introduces the basic knowledge of Excel 2002, including its new features, operations on cells, worksheets, and data, the creation and editing of statistical charts, the use of formulas and functions, as well as methods for classification summarization and data analysis.
Part 2: Statistics
This section details how to use Excel to solve statistical problems. It primarily covers descriptive statistics, common discrete and continuous distributions, hypothesis testing and interval estimation methods, correlation analysis and analysis of variance, regression analysis, and time series analysis.
Part 3: Economics
This section introduces, through specific examples, how to use Excel's data processing capabilities to address fundamental problems in economics.
Part 4: Advanced Topics
This section introduces the basics of VBA (Visual Basic for Applications) and its application in statistics. It provides detailed examples of VBA application development methods and processes.
The book is rich in content, examples, and illustrations, with a clear structure. It is suitable for a wide range of Excel users and self-learners, particularly for accounting and finance professionals who frequently conduct statistical analysis, as well as for management workers and business statisticians involved in economic data analysis. It is also suitable for researchers who need to analyze large amounts of complex scientific research data, and can serve as a reference book for college students studying basic statistical calculations.