If you spend time on your Excel Project and you feel it can be done some other way, you may contact our Excel Help Team to help you with your Excel Project or use our Excel Question page.
More practical features can be found in our Excel Utility.
Excel's Statistical Functions can be used to analysis the data in a spreadsheet. For example, they can be used to tell you the number of data entries you have or the average value of your data.
Download our FREE Excel Utility
Provide many features and shortcuts to your Excel use
StDevPA function returns the standard deviation of...
AveDev
In Excel, the AveDev function returns the average of the absolute deviations of the numbers provided. The syntax for the AveDev function is: AveDev( number1, number2, ... number_n ) number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
In Excel, the BetaDist function returns the cumulative beta probability density function. The syntax for the BetaDist function is: BetaDist( x, alpha, beta, lower_bound, upper_bound ) x is the value between A and B. alpha is a distribution parameter. beta is a distribution parameter. lower_bound is optional. It is the lower bound to the interval of x. If this parameter is omitted, the BetaDist assumes that lower_bound is 0 and upper_bound is 1. upper_bound is optional. It is the upper bound to the interval of x. If this parameter is omitted, the BetaDist assumes that lower_bound is 0 and upper_bound is 1. Note: If x < lower_bound, the BetaDist function will return the #NUM! error. if x > upper_bound, the BetaDist function will return the #NUM! error. If alpha <= 0, the BetaDist function will return the #NUM! error. If beta <=0, the BetaDist function will return the #NUM! error. For example: Let's take a look at an example: =BetaDist(3, 7.5, 9, 1, 4) would return 0.960370937 =BetaDist(7.5, 8, 9, 5, 10) would return 0.598190307
In Excel, the BetaInv function returns the inverse of the cumulative beta probability density function. The syntax for the BetaInv function is: BetaInv( probability, alpha, beta, lower_bound, upper_bound ) probability is the probability for the beta distribution. alpha is a distribution parameter. beta is a distribution parameter. lower_bound is optional. It is the lower bound to the interval of x. If this parameter is omitted, the BetaDist assumes that lower_bound is 0 and upper_bound is 1. upper_bound is optional. It is the upper bound to the interval of x. If this parameter is omitted, the BetaDist assumes that lower_bound is 0 and upper_bound is 1. Note: If x < lower_bound, the BetaDist function will return the #NUM! error. if x > upper_bound, the BetaDist function will return the #NUM! error. If alpha <= 0, the BetaDist function will return the #NUM! error. If beta <=0, the BetaDist function will return the #NUM! error. For example: Let's take a look at an example: =BetaInv(0.3, 7.5, 9, 1, 4) would return 2.164759636 =BetaInv(0.75, 8, 9, 5, 10) would return 7.761240005
In Excel, the BinomDist function returns the individual term binomial distribution probability. The syntax for the BinomDist function is: BinomDist( number_success, number_trial, prob_success, cumulative ) number_success is the number of successes in the trials. number_trial is the number of independent trials. prob_success is the probability of success for each trial. cumulative is either TRUE or FALSE. With a value of TRUE, the BinomDist function returns the cumulative distribution function. With a value of FALSE, the BinomDist function returns the probability mass function. For example: Let's take a look at an example: =BinomDist(3, 8, 0.35, TRUE) would return 0.706399436 =BinomDist(3, 8, 0.35, FALSE) would return 0.278585779 =BinomDist(50, 125, 0.4, TRUE) would return 0.538748205
In Excel, the Covar function returns the covariance, the average of the products of deviations for two data sets. The syntax for the Covar function is: Covar( array1, array2 ) array1 and array are two ranges or arrays of integer values. For example: Let's take a look at an example: =Covar({1,2;3,4}, {5,6;7,8}) The above example would return 1.25.
In Excel, the Forecast function returns a prediction of a future value based on existing values provided. The syntax for the Forecast function is: Forecast( x-value, known_y_values, known_x_values ) x-value is the x-value used to predict the y-value. known_y_values is the known y-values used to predict the y-value. known_x_values is the known x-values used to predict the y-value. Note: If x-value is not a numeric value, the Forecast function will return the #VALUE! error. If known_y_values and known_x_values contain different numbers of elements, the Forecast function will return the #N/A error
In Excel, the Growth function returns the predicted exponential growth based on existing values provided. The syntax for the Growth function is: Growth( known_y_values, known_x_values, new_x_values, constant ) known_y_values is the known y-values used to predict the exponential growth. known_x_values is optional. It is the known x-values used to predict the exponential growth. If this parameter is omitted, the Growth function uses {1,2,3,...} as the known_x_values parameter. new_x_values is optional. It is the x-values that are used by the Growth function to return the corresponding y-values. If this parameter is omitted, the Growth function uses {1,2,3,...} as the new_x_values parameter. constant is either a TRUE or FALSE value. TRUE means that the constant b is calculated normally. FALSE means that the constant b is set to 1. If this parameter is omitted, the Growth function assumes a constant parameter of TRUE.
In Excel, the Intercept function returns the y-axis intersection point of a line using x-axis values and y-axis values. The syntax for the Intercept function is: Intercept( known_y_values, known_x_values ) known_y_values is the known y-values used to calculate the intersect. known_x_values is the known x-values used to calculate the intersect. Note: If the known_y_values and known_x_values parameters contain different numbers of elements, the Intercept function will return the #N/A error.
In Excel, the Median function returns the median of the numbers provided. The syntax for the Median function is: Median( number1, number2, ... number_n ) number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
In Excel, the Percentile function returns the nth percentile from a set of values. The syntax for the Percentile function is: Percentile( array, nth_percentile ) array is a range or array from which you want to return the nth percentile. nth_percentile is the percentile value. It can be a value between 0 and 1. Note: If nth_percentile is not a numeric value, the Percentile function will return the #VALUE! error. If nth_percentile is a value greater than 1 or less than 0, the Percentile function will return the #NUM! error.
In Excel, the PercentRank function returns the rank of a value in a set of values as a percentage of the set. The syntax for the PercentRank function is: PercentRank( array, value, significant_digits ) array is a range or array from which you want to return the rank. value is the value that you wish to find the rank for. significant_digits is optional. It is the number of significant digits to return the rank for. If this parameter is omitted, the PercentRank returns a value that has 3 significant digits (ie: 0.xxx%). Note: If significant_digits is less than 1, the PercentRank function will return the #NUM! error. If value does not exist in the array, the PercentRank function will interpolate to return a percentage rank
In Excel, the Permut function returns the number of permutations for a specified number of items. The syntax for the Permut function is: Permut( number, chosen ) number is the number of items. chosen is the number of items in each permutation.
In Excel, the Quartile function returns the quartile from a set of values. The syntax for the Quartile function is: Quartile( array, nth_quartile ) array is a range or array from which you want to return the nth quartile. nth_quartile is the quartile value that you wish to return. It can be one of the following values: Value Explanation 0 Smallest value in the data set 1 First quartile (25th percentile) 2 Second quartile (50th percentile) 3 Third quartile (75th percentile) 4 Largest value in the data set Note: If nth_quartile is not an integer, it will be truncated.
In Excel, the Rank function returns the rank of a number within a set of numbers. The syntax for the Rank function is: Rank( number, array, order ) number is the number to find the rank for. array is a range or array of numbers to use for ranking purposes. order is optional. It specifies how to rank the numbers. If order is 0, it ranks numbers in descending order. If order is not 0, it ranks numbers in ascending order. If the order parameter is omitted, the Rank function assumes order is 0 (descending order
In Excel, the StDev function returns the standard deviation of a population based on a sample of numbers. The syntax for the StDev function is: StDev( number1, number2, ... number_n ) number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
In Excel, the StDevA function returns the standard deviation of a population based on a sample of numbers, text, and logical values (ie: TRUE or FALSE). The syntax for the StDevA function is: StDevA( value1, value2, ... value_n ) value1, value2, ... value_n are the sample values. They can be numbers, text, and logical values. Values that are TRUE are evaluated as 1. Values that are FALSE or text values are evaluated as 0. There can be up to 30 values entered.
In Excel, the StDevP function returns the standard deviation of a population based on an entire population of numbers. The syntax for the StDevP function is: StDevP( number1, number2, ... number_n ) number1, number2, ... number_n are the population numbers. There can be up to 30 numbers entered
In Excel, the StDevPA function returns the standard deviation of a population based on an entire population of numbers, text, and logical values (ie: TRUE or FALSE). The syntax for the StDevPA function is: StDevPA( value1, value2, ... value_n ) value1, value2, ... value_n are the population values. They can be numbers, text, and logical values. Values that are TRUE are evaluated as 1. Values that are FALSE or text values are evaluated as 0. There can be up to 30 values entered
