Application of Excel in Forecasting

Author: Tang Wuxiang
Publisher:
Publish Date: 2001-10-01
Features: After reading this book, readers will not only master the theoretical knowledge of various forecasting methods but also gain a comprehensive and clear understanding of the basic operations and powerful functions of Excel. It will also help them become more proficient in using Excel for various quantitative analysis and forecasting, achieving twice the result with half the effort. This book is suitable for reading by a wide range of readers in business management and economic administrative departments, as well as serving as a textbook or reference for senior undergraduate students, graduate students, and MBA students in economics and management majors at colleges and universities. This book provides an in-depth yet accessible introduction to the application of Excel, currently the most popular spreadsheet program, in forecasting. The book is divided into 10 chapters. Chapter 1 introduces the basic knowledge of the Chinese version of Excel, while Chapters 2 to 10 respectively cover the application of Excel in qualitative forecasting, regression analysis forecasting, the extension of regression models, time series smoothing forecasting, seasonal variation forecasting, Markov forecasting, input-output forecasting, discriminant analysis forecasting, and the application of simultaneous equation model parameter estimation.