Forecasting is an integral part of almost all business enterprises. This book provides readers with the tools to analyze their data, develop forecasting models and present the results in Excel. Progressing from data collection, data presentation, to a step-by-step development of the forecasting techniques, this essential text covers techniques that include but not limited to time series-moving average, exponential smoothing, trending, simple and multiple regression, and Box-Jenkins. And unlike other products of its kind that require either high-priced statistical software or Excel add-ins, this book does not require such software. It can be used both as a primary text and as a supplementary text.
About the Authors
Chapter 1 : Introduction to Forecasting Chapter 2 : Summarizing and Displaying Data in Excel Chapter 3 : Basic Time Series Analysis Chapter 4 : Forecasting Performance Measurements, Tracking Signals, and Randomness Tests Chapter 5 : Advanced Time Series Forecasting Techniques Chapter 6 : Simple Linear Regression Analysis in Forecasting Chapter 7 : Multiple Linear Regression Analysis in Forecasting Chapter 8 : Markovian Forecasting Models Chapter 9 : Diffusion Modeling and Forecasting Chapter 10 : Miscellaneous Forecasting Models