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-01-01
Series:Spreadsheets in Education
Online Access:https://sie.scholasticahq.com/article/4545-forecasting-with-excel-suggestions-for-managers
_version_ 1827119540070252544
author Scott Nadler
John F Kros
author_facet Scott Nadler
John F Kros
author_sort Scott Nadler
collection DOAJ
description 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.
first_indexed 2024-04-11T02:35:22Z
format Article
id doaj.art-32fb1ece3d19488daa959faff308d167
institution Directory Open Access Journal
issn 1448-6156
language English
last_indexed 2025-03-20T13:22:58Z
publishDate 2007-01-01
publisher McMaster University
record_format Article
series Spreadsheets in Education
spelling doaj.art-32fb1ece3d19488daa959faff308d1672024-09-12T22:43:33ZengMcMaster UniversitySpreadsheets in Education1448-61562007-01-0122Forecasting with Excel: Suggestions for ManagersScott NadlerJohn F KrosThis 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.https://sie.scholasticahq.com/article/4545-forecasting-with-excel-suggestions-for-managers
spellingShingle Scott Nadler
John F Kros
Forecasting with Excel: Suggestions for Managers
Spreadsheets in Education
title Forecasting with Excel: Suggestions for Managers
title_full Forecasting with Excel: Suggestions for Managers
title_fullStr Forecasting with Excel: Suggestions for Managers
title_full_unstemmed Forecasting with Excel: Suggestions for Managers
title_short Forecasting with Excel: Suggestions for Managers
title_sort forecasting with excel suggestions for managers
url https://sie.scholasticahq.com/article/4545-forecasting-with-excel-suggestions-for-managers
work_keys_str_mv AT scottnadler forecastingwithexcelsuggestionsformanagers
AT johnfkros forecastingwithexcelsuggestionsformanagers