Excel Statistical Functions

This section will learn  how to use Excel’s  Statistical Functions such as: Avedev, Average, AverageA, AverageIF, AverageIFS, etc.

AVEDEV – returns the average of the absolute deviations of the numbers that you provided.

AVERAGE – returns the average of the numbers that you provided

AVERAGEA – returns the average of its arguments, including numbers, text, and logical values.

AVERAGEIF – returns the average of all numbers in a range of cells that meet a given criteria.

AVERAGEIFS – returns the average of all numbers in a range of cells that meet multiple criteria.

BETA.DIST – calculate the cumulative beta distribution or beta probability density function.

BETADIST – returns the cumulative beta probability density function.

BETA.INV – returns the inverse of the beta cumulative probability density function.

BETAINV – returns the inverse of the beta cumulative probability density function.

BINOM.DIST – returns the individual term binomial distribution probability.

BINOM.INV – returns the inverse of the Cumulative Binomial Distribution that is greater than or equal to a criterion value.

BINOMDIST – returns the individual term binomial distribution probability.

x
How to Create Dynamic Interactive Charts in Excel

CHIDIST – returns the right-tailed probability of the chi-squared distribution.

CHIINV – returns the inverse of the right-tailed probability of the chi-squared distribution.

CHITEST – returns the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.

COUNT – counts the number of cells that contain numbers, and counts numbers within the list of arguments.

COUNTA – counts the number of cells that are not empty in a range.

COUNTBLANK – use to count the number of empty cells in a range of cells.

COUNTIF – count the number of cells in a range that meet a given criteria.

COUNTIFS -returns the count of cells in a range that meet one or more criteria.

COVAR – returns covariance, the average of the products of deviations for each data point in two given sets of values.

FORECAST – used to calculate or predict a future value by using existing values.

FREQUENCY – calculates how often values occur within a range of values.

GROWTH – calculates the predicted exponential growth based on existing data.

INTERCEPT – calculates the point at which a line will intersect the y-axis by using existing x-values and y-values.

LARGE -returns the largest numeric value from the numbers that you provided. Or returns the largest value in the array.

LINEST – calculates the statistics for a line by using the “least squares” method to calculate a straight line that best fits your data, and then returns an array that describes the line.

MAX – returns the largest numeric value from the numbers that you provided.

MAXA – returns the largest numeric value from a range of values.

MEDIAN – returns the median of the given numbers.

MIN – returns the smallest numeric value from the numbers that you provided.

MINA -returns the smallest numeric value from the numbers that you provided, while counting text and the logical values.

MODE – returns the most frequently occurring number found in an array or range of numbers.

MODE.MULT – returns a vertical array of the most frequently occurring number found in an array or range of numbers.

MODE.SNGL -returns the most frequently occurring number found in an array or range of numbers.

PERCENTILE -returns the kth percentile from a supplied range of values.

PERCENTRANK – returns the rank of a value in a set of values as a percentage of the set.

PERMUT – returns the number of permutations for a given number of items.

QUARTILE – returns the quartile from a supplied range of values.

RANK – returns the rank of a given number in a supplied range of cells.

SLOPE – returns the slope of the linear regression line through data points in known_y’s and know_x’s.

SMALL -returns the nth smallest numeric value from the numbers that you provided.

STDEV – returns the standard deviation of a population based on a sample of numbers.

STDEVA – returns the standard deviation of a population based on a sample of numbers, text, and logical values.

STDEVP – returns the standard deviation of a population based on an entire population of numbers.

STDEVPA – returns the standard deviation of a population based on an entire population of numbers, text or logical values.

VAR – returns the variance of a population based on a sample of numbers.

VARA – returns the variance of a population based on a sample of numbers, text, or logical values.

VARP – returns the variance of a population based on an entire population of numbers.

VARPA – returns the variance of a population based on an entire population of numbers, text, or logical values.

 

 

Related Posts

How to Average Ignore Zero Number
How to Average Ignore Zero Number 5

AVERAGE function is a frequently used function in our office work. Except this basic function, Excel also provides some other Average related functions like AVERAGEIF, AVERAGEIFS. In this article, we will show you applying AVERAGEIF function to get average with ...

How to Calculate Average If Criteria Not Blank/Ignore Blank Cell
How to Calculate Average If Criteria Not Blank 11

In daily work we often need to calculate the average of some numbers based on given conditions or criteria. To calculate average with criteria, we can apply AVERAGEIF of AVERAGEIFS function. AVERAGEIFS function can handle more than one group of ...

How to Calculate Average Ignore Non-Numeric Values and Errors
How to Calculate Average Ignore Non-Numeric Values and Errors 8

In daily work we often need to calculate the average of some numbers in a range for further analysis. Thus, we need to know some basic functions of calculate average in Excel. From now on, we will introduce you some ...

How to Average and Ignore Errors in Excel
average and ignore errors2

This post will guide you how to average a list of values and ignoring any errors in the given range in Excel 2013/2016 or Excel office 365. You can use the AVERAGEIF function or AGGREGATE function to calculate the average ...

How to Calculate Average Ignore Blank and Zero Cells in Excel
How to Calculate Average Ignore Blank and Zero Cells in Excel8

Sometimes we need to calculate the average for a list or a range of numbers, but blank cells and zero cells may be also included in the selected range, so if these invalid cells are included, we often get error ...

How to Average Absolute Values in Excel
How to Average Absolute Values in Excel5

We can use AVERAGE function to calculate average of certain values. We can use ABS function to get absolute values for both positive number and negative number. If we want to get the average absolute values, we need to combine ...

How to Calculate Average among Multiple Different Worksheets in Excel
Calculate Average among Multiple Different Worksheets 8

If we want to calculate the average for all numbers from multiple worksheets, how can we do calculate? Currently we may know the way to calculate the average for a selected range on one worksheet, this article will introduce you ...

How to Count the Average Between Two Dates in Excel
Count the Average Between Two Dates 11

In our daily work, we usually have the problem of counting the average of a period. If the given dates are continuous, we can handle this situation very well, and if the dates are discontinuous, how do we count the ...

How to Round the Calculated Average result in Excel
round average function3

This post will guide you how to use average and round functions at the same time to average a given range, and then round off the last result in Excel. How to use Round function to round the calculated average ...

How to Ignore Error Values When Calculating the Average in Excel
average cells ignore error3

This post will guide you how to ignore error values when getting average for a range of cells in Excel. How do I average a range of cells ignoring error values, such as: #div/0!. Assuming that you have a list ...

Sidebar