Excel in Statistics

Author: Wang Weihong
Publisher:
Publish Date: 2004-09-01
Features: This series of teaching materials is characterized by being based on the "Basic Requirements" and "Training Specifications" for writing, with comprehensive content, a well-structured layout, and concise language. It adopts a "problem (task) driven" writing approach, making it easier to stimulate learning interest. Selected examples are used to integrate knowledge points, enhancing readability, operability, and practicality. It includes hands-on guidance and practical training tutorials, facilitating student practice and improvement. Electronic teaching plans and program source codes are provided to meet the needs of multimedia teaching for instructors. As an excellent spreadsheet software, Excel's applications are not limited to table calculations; it is widely used in fields such as management, accounting, statistics, finance, and public finance. This book primarily introduces the application of Excel in statistics. The book is divided into two parts: the first part covers basic Excel knowledge and simple operations; the second part introduces the application of Excel in statistics, including the collection and organization of statistical data, descriptive statistics, probability distributions and sampling distributions, parameter estimation, hypothesis testing, analysis of variance, regression analysis, time series analysis and forecasting. This book is suitable as a teaching material for economic and management majors in higher vocational schools, higher colleges, adult colleges, and secondary vocational colleges of undergraduate universities, as well as for reference books for economic management and statistical analysis professionals. Free electronic teaching plans are provided for instructors of this book, which are created in PowerPoint and can be modified as needed. Interested parties can download them from the China Water Conservancy and Electric Power Press website www.waterpub.com.cn.