Statistical Functions in Excel
List of Statistical Functions in Excel
When you are performing data analysis, statistics is what you make the most use of to meaningfully arrive at logical conclusions. MS Excel provides a number of statistical functions useful for data analysis.
Top Statistical Functions in excel discussed here are -
- AVERAGE function in Excel
- COUNT and COUNTIF function in excel
- Correlation function in excel
AVERAGE Excel Function
The AVERAGE function in Excel gives the arithmetic mean of the supplied set of numeric values. It is categorized as a Statistical Function in Excel.
CORREL Excel Function
CORREL formula in Excel is used to find out the correlation coefficient between two variables. CORREL in Excel returns the correlation coefficient of the array1 and array2.
COUNT Excel Function
COUNT function in Excel is a statistical function which is used to count the number of cells containing numbers within the given range. COUNT in Excel returns an integer number.
COUNTIF Excel Function
COUNTIF in Excel is an advanced version of COUNT a built-in Excel function which counts the numeric values present in the given range of cells.
FREQUENCY Excel Function
FREQUENCY function in Excel calculates the number of times data values occur within a given range of values.
MAX Excel Function
Excel MAX Formula is used to find out the maximum value from a given set of data/ array. MAX function in Excel returns the highest value from a given set of numeric values.
MEDIAN Excel Function
Median function in Excel gives the median of any given set of numbers and is categorized as a Statistical Function.
SLOPE Function in Excel
In mathematical term, the SLOPE returns the slope of a line between given data points in known y’s values and known x’s values.