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 |
| _version_ | 1828080150071214080 |
|---|---|
| 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-11T03:13:42Z |
| format | Article |
| id | doaj.art-4e32a45fa5b74498b4be7b439561fc99 |
| institution | Directory Open Access Journal |
| issn | 1448-6156 |
| language | English |
| last_indexed | 2024-04-11T03:13:42Z |
| publishDate | 2007-05-01 |
| publisher | McMaster University |
| record_format | Article |
| series | Spreadsheets in Education |
| spelling | doaj.art-4e32a45fa5b74498b4be7b439561fc992023-01-02T10:51:18ZengMcMaster UniversitySpreadsheets in Education1448-61562007-05-01221038Forecasting 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.http://epublications.bond.edu.au/ejsie/vol2/iss2/5forecastingquantitativeExcel |
| spellingShingle | Scott Nadler John F Kros Forecasting with Excel: Suggestions for Managers Spreadsheets in Education forecasting quantitative Excel |
| 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 |
| topic | forecasting quantitative Excel |
| url | http://epublications.bond.edu.au/ejsie/vol2/iss2/5 |
| work_keys_str_mv | AT scottnadler forecastingwithexcelsuggestionsformanagers AT johnfkros forecastingwithexcelsuggestionsformanagers |