This tool helps you generate predictions based on historical data so you can set realistic, evidence-based goals. By uploading a spreadsheet, you can apply four forecasting methods—simple exponential smoothing, Holt linear exponential smoothing, naïve random walk, and cubic spline smoothing—and compare their results.
Note: This is an educational tool. Do not use it for sensitive or confidential data.
How to Use
1. Upload your spreadsheet: Click the “Choose a spreadsheet file” button and select the file you want to analyze.
2. Select your data column: From the dropdown menu, choose the column that contains your historical data.
3. View your results: The tool will automatically generate a summary table showing high, low, and expected outcomes across five time horizons and a visualization of the forecast results.
4. Compare forecasting methods: Use the tabs at the top of the tool to explore predictions from each of the four forecasting methods.
Tips & Reminders
1. Do not upload personally identifiable information.
2. If you’re unsure whether your dataset is appropriate, consult your organization’s data policy.
3. For detailed instructions or help interpreting results, visit the Technical Directions page.
4. Try the tool with our sample dataset.
Citation
If you use this tool in your work, please cite it as:
Courtney, M. B. (2023). Forecast Explorer. Courtney Consulting LLC. (Date Accessed). https://www.freeanalyticstools.com/forecast_explorer