by Ilker | Sep 8, 2022 | Excel Tips & Tricks
Descriptive statistics are summarizations of your dataset. This summary includes mean, median, mode, standard deviation, variance, minimum and maximum variables, kurtosis, and skewness. Excel can generate all these measures for a selected range in a proper table. In...
by Ilker | Apr 12, 2022 | Excel Formulas
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...
by Ilker | Apr 8, 2022 | Excel Tips & Tricks
Trend Analysis is an important tool for decision making, which allows you to analyze the historical patterns to predict future events. Excel is not shy about tools that help you in the process. In this guide, we’re going to show you How to perform trend analysis in...
by Ilker | Mar 11, 2022 | Excel Tips & Tricks
Big or small, all business operations need forecasting. Forecasting can be either qualitative or quantitative. In the end, you should estimate future incomes and expenses to draw up a budget. Since each business sector and the company have their own dynamics, there is...
by Ilker | Mar 8, 2022 | Excel Formulas
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...
by Ilker | Mar 4, 2022 | Excel Formulas
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)...
by Ilker | Mar 3, 2022 | Excel Tips & Tricks
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...
by Ilker | Mar 1, 2022 | Excel Formulas
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)...
by Ilker | Mar 1, 2022 | Excel Formulas
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...