Forecasting functions can be used to predict future values based on historical data. These functions use advanced machine learning algorithms, such as Exponential Triple Smoothing (ETS).

This article describes the formula syntax and usage of the FORECAST.LINEAR and FORECAST functions in Microsoft Excel. Note: In Excel 2016, the FORECAST function was replaced with …

Use your existing data in Excel 2016 to predict and chart future values much faster and easier than using the various Forecast functions with one click. This article also contains information on the …

You can use this function to predict future sales, inventory requirements, or consumer trends. This function requires the timeline to be organized with a constant step between the different points.

Release CONTROL , and the mouse button, and then on the contextual menu, click Growth Trend. Excel automatically calculates the growth trend and continues the series in the selected cells. Tip: To …

Although the timeline requires a constant step between data points, FORECAST.ETS.STAT will aggregate multiple points which have the same time stamp. The aggregation parameter is a numeric …

Returns a confidence interval for the forecast value at the specified target date. A confidence interval of 95% means that 95% of future points are expected to fall within this radius from the result …

While it can also be used independently of FORECAST.ETS, the functions are tied since the seasonality detected in this function is identical to the one used by FORECAST.ETS, considering the same input …

These functions aren't available in earlier versions. Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 …

The TREND function returns values along a linear trend. It fits a straight line (using the method of least squares) to the array's known_y's and known_x's. TREND returns the y-values along that line for the …