Forecasting with Excel: Suggestions for Managers
This article provides readers and more especially business managers with an overview of moving average, exponential smoothing, trend analysis, and linear regression approaches to forecasting. The authors then provide specific examples for each approach and the Excel formulas necessary to develop eff...
Main Authors: | , |
---|---|
Format: | Article |
Language: | English |
Published: |
McMaster University
2007-05-01
|
Series: | Spreadsheets in Education |
Subjects: | |
Online Access: | http://epublications.bond.edu.au/ejsie/vol2/iss2/5 |
Summary: | This article provides readers and more especially business managers with an overview of moving average, exponential smoothing, trend analysis, and linear regression approaches to forecasting. The authors then provide specific examples for each approach and the Excel formulas necessary to develop effective forecasts. This is an important contribution to the literature because it demonstrates that businesses with limited resources can develop reliable and accurate forecasts in a timely and cost effective manner using readily available software. |
---|---|
ISSN: | 1448-6156 |