A feature that creates a visual forecast chart based on historical time-series data with a single click.
جرّبه بالذكاء الاصطناعيThe Forecast Sheet tool uses the Exponential Smoothing (ETS) algorithm to predict future values based on existing time-based data. It automatically generates a new worksheet containing a chart and a table that includes confidence intervals to show the range of potential outcomes.
If you have monthly sales data for the past two years, you can select the data and use the Forecast Sheet to project sales for the next six months.
You need a two-column data set: one column containing time-based entries (dates or times) and another containing the corresponding numerical values.