The FORECAST.ETS.CONFINT function returns a confidence interval for the forecast value at the specified target date. A confidence interval of …

# Category: Statistical functions

In addition to formulas, another way to conduct mathematical computations in Excel is through functions. Statistical functions apply a mathematical process to a group of cells in a worksheet. For example, the SUM function is used to add the values contained in a range of cells.

Forecast function available in excel is the simplest ever forecasting function that we could have. This function predicts the selected …

The FORECAST.ETS function calculates or predicts a future value based on existing (historical) values by using the AAA version of …

The F.DIST function returns the F probability distribution. You can use this function to determine whether two data sets have …

COVARIANCE.P function in excel is a statistical function. This function is used to find the variability of two data sets …

CORREL function is categorized as statistical functions in Excel. The CORREL formula in Excel is used to find out the …

The CHISQ.DIST function returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of …

The Excel BINOM.DIST function returns the Binomial Distribution probability for a given number of successes from a specified number of …

The Excel AVERAGEA function returns the average of a group of supplied values. Unlike AVERAGE, AVERAGEA will also evaluate the …

The Excel AVEDEV function returns the average of the absolute value of deviations from the mean for a given set of …