Fundamentals of Forecasting Using Excel (eBook)

Kenneth D. Lawrence, Ronald K. Klimberg, Sheila M. Lawrence (Autoren)

eBook Download: PDF

2009
300 Seiten
Industrial Press, Inc. (Verlag)
978-0-8311-9206-8 (ISBN)

Infos

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. Highlights the use of Excel screen shots, data tables, and graphs.Features Full Scale Use of Excel in Forecasting without the Use of Specialized Forecast PackagesIncludes Excel templates.Emphasizes the practical application of forecasting.Provides coverage of Special Forecasting, including New Product Forecasting, Network Models Forecasting, Links to Input/Output Modeling, and Combination of Forecasting.

Inhalt

Introduction to Forecasting Summarizing and Displaying Data in Excel Basic Time Series Analysis Forecasting Performance Measurements, Tracking Signals, and Randomness Tests Advanced Time Series Forecasting Techniques Simple Linear Regression Analysis in Forecasting Multiple Linear Regression Analysis in Forecasting Markovian Forecasting Models Diffusion Modeling and Forecasting Miscellaneous Forecasting Models

Produkt-Details

• Erscheint lt. Verlag: 1.1.2009
• Sprache: englisch
• Maße: 210 x 210 mm
• Themenwelt: Informatik ► Office Programme ► Excel
• Schlagworte: Excel, analyze data, develop forecasting models, time series-moving average, exp • Excel, analyze data, develop forecasting models, time series-moving average, exponential smoothing, trending, simple regression, multiple regression, Box-Jenkins, Special forecasting, New product forecasting, input/output modeling, combination of forecasting • Excel, analyze data, develop forecasting models, time series-moving average, exponential smoothing, trending, simple regression, multiple regression, Box-Jenkins, Special forecasting, New product forecasting, input/output modeling, combination of forecasting.
• ISBN-10: 0-8311-9206-2 / 0831192062
• ISBN-13: 978-0-8311-9206-8 / 9780831192068