by Ilker | Mar 1, 2022 | Excel Formulas
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...
by Ilker | Sep 9, 2021 | Excel Tips & Tricks
Exponential moving average option is a data smoothing approach which gives exponentially decreasing weights to values over time. In this guide, we’re going to show you how to calculate exponential moving average in Excel. Download Workbook What is exponential moving...
by Ilker | Sep 9, 2021 | Excel Tips & Tricks
Weighted moving average is a data smoothing approach that gives more weight to more recent time periods. In this guide, we’re going to show you how to calculate weighted moving average in Excel. Download Workbook What is weighted moving average (WMA)? Moving average...
by Ilker | Sep 6, 2021 | Excel Tips & Tricks
Moving average calculations is a common way of smoothing data to reduce the effects of random, short-term fluctuations. In this guide, we’re going to show you how to calculate simple moving averages in Excel using three methods. Download Workbook What is Simple Moving...
by Ilker | Jun 9, 2021 | Excel Tips & Tricks
A discrete distribution describes the probability of occurrence of a random variable that can take on only a certain number of values. Common examples for this are the probabilities in a dice roll or getting a certain card in a deck of regular cards. In this guide,...
by Ilker | Jun 8, 2021 | Excel Tips & Tricks
The PROB function is a statistical function that can calculate the probability associated with a given range. The function is useful for calculating the probability for the occurrences having discrete probabilities of an event. In this guide, we’re going to show you...
by Ilker | Jun 8, 2021 | Excel Tips & Tricks
Error bars are graphical representations of data variability in charts. You can add error bars into your Excel charts to provide a more comprehensive view of the data set. An error bar is usually a horizontal and/or vertical line drawn between lowest and highest error...
by Ilker | Jun 3, 2021 | Excel Tips & Tricks
Variance is an important metric in statistics, and it can help you calculate like the risk of an investment. In this guide, we’re going to show you how to calculate variance in Excel. Download Workbook What is variance? Variance is the average of the squared...
by Ilker | Jun 3, 2021 | Excel Formulas
The VARPA function is a statistical function that can calculate and return the variance of a population by evaluating text and logical values. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard...