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...

Full description

Bibliographic Details
Main Authors: Scott Nadler, John F Kros
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
Description
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