Data forecasting made easy

Data forecasting made easy

What is forecasting in the meaning of data and charts? It is the process of making predictions based on historical data. There are many forecasting methods, for example straight-line, moving average, simple linear regression, or multiple linear regression. But we are good with the moving average method at this moment.

Moving the average…

This method takes an average of a historical set of numbers in a given range while moving the range. Sounds like rocket science stuff? Not on our terms 🙂

On how to forecast

Sample AutoROICalc chart
Sample AutoROICalc chart

In the AutoROICalc Report Chart view, find the third left item at the bottom of the chart, titled “Forecast”. A simple dialog will be shown. Pick the “Moving Average” forecast method, the number of average periods of the historical data, and the number of forecast periods. See the example dialog below.

Sample forecast dialog
Sample forecast dialog

When ready, hit the “Apply” button and enjoy your new item in the chart.

Ready to wow your clients?

A forecast using a moving average could be useful in case of getting an idea of what could happen next. It is also helpful in estimating the trend cycles. To get a better understanding of your data, why not also add a trendline to your charts to wow your clients even more?

Sample AutoROICalc chart with forecast using moving average
Sample AutoROICalc chart with forecast using moving average

CareFree Data Collection, Enrichment and Reporting

  • Record and Report Crucial Business Activities.
  • From Operations to Strategies.
  • Any Business Model.
  • Open for Automation.
  • Business Intelligence Made Easy
  • Comfy Sharing & E-mail Reporting.
  • Set Once, Enjoy Forever!

Enjoy Premium features in the 30-day free trial.



Explore the Records-related tutorials:

Explore the Reports-related tutorials

Explore the Dashboards-related tutorials