Excel TREND Function

Excel TREND Function

TREND The TREND function is a Statistical function that can return values along a linear trend line through a given set of dependent and, optionally, independent values. In this guide, we’re going to show you how to use the TREND function and go over some tips and...
Excel FORECAST.ETS.STAT Function

Excel FORECAST.ETS.STAT Function

The FORECAST.ETS.STAT function is a Statistical function that returns a statistical information based on time series forecasting. This function can be used with FORECAST.ETS function to see the statistical values of forecasting. In this guide, we’re going to show you...
Excel FORECAST.ETS.CONFINT Function

Excel FORECAST.ETS.CONFINT Function

The FORECAST.ETS.CONFINT function is a Statistical function that calculates a confidence interval for a forecasted value by using existing values with a seasonal pattern. The function is using the AAA version (additive error, additive trend and additive seasonality)...
FORECAST.ETS.SEASONALITY

FORECAST.ETS.SEASONALITY

The FORECAST.ETS.SEASONALITY function is a Statistical function that predicts the length of the season in a repetitive pattern, for a given specified time series. The function returns the same season length which is calculated by the FORECAST.ETS function...
Excel FORECAST.ETS Function

Excel FORECAST.ETS Function

The FORECAST.ETS function is a Statistical function that predicts a future value by using existing values with a seasonal pattern. The function is using the AAA version (additive error, additive trend, and additive seasonality) of the Exponential Smoothing (ETS)...
Excel FORECAST.LINEAR Function

Excel FORECAST.LINEAR Function

The FORECAST.LINEAR function is a Statistical function that predicts a future value by using existing values along a linear trend (linear regression). You can use a forecasting function to predict future sales, inventory requirements, or consumer trends. In this...
Excel FORECAST Function

Excel FORECAST Function

FORECAST The FORECAST function is a Statistical function that predicts a future value by using existing values along with a linear trend (linear regression). You can use the forecasting function to predict future sales, inventory requirements, or consumer trends. In...
Excel AMORLINC Function

Excel AMORLINC Function

The AMORLINC function is a Finance function used in French accounting system that returns the depreciation for each accounting period, on a prorated basis. The prorated depreciation is considered when an asset is purchased in the middle of the accounting period. In...
Excel AMORDEGRC Function

Excel AMORDEGRC Function

The AMORDEGRC function is a Finance function used in French accounting system that returns the depreciation for each accounting period, on a prorated basis. The prorated depreciation is considered when an asset is purchased in the middle of the accounting period. In...