Office.com results
AVERAGEA
Article Calculates the average (arithmetic mean) of the values in the list of arguments. Syntax AVERAGEA ( value1 ,value2,...) Value1, value2, ...   are 1 to 30 cells,...
Excel 2003
FORECAST
Article Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values a...
Excel 2003
TTEST
Article Important notice for users of Office 2003     To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3) . The...
Excel 2003
LINEST
Article Important notice for users of Office 2003     To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3) . The...
Excel 2003
FTEST
Article Returns the result of an F-test. An F-test returns the two-tailed probability that the variances in array1 and array2 are not significantly different. Use this ...
Excel 2003
FREQUENCY
Article Calculates how often values occur within a range of values, and then returns a vertical array of numbers. For example, use FREQUENCY to count the number of test...
Excel 2003
MIN
Article Returns the smallest number in a set of values. Syntax MIN ( number1 ,number2,...) Number1, number2, ...   are 1 to 30 numbers for which you want to find the mi...
Excel 2003
FDIST
Article Returns the F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can e...
Excel 2003
NEGBINOMDIST
Article Returns the negative binomial distribution. NEGBINOMDIST returns the probability that there will be number_f failures before the number_s-th success, when the c...
Excel 2003
FISHER
Article Returns the Fisher transformation at x. This transformation produces a function that is normally distributed rather than skewed. Use this function to perform hy...
Excel 2003
AVEDEV
Article Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set. Syntax AVEDEV ( number1 ,nu...
Excel 2003
NORMDIST
Article NORMDIST returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, inclu...
Excel 2003
NORMINV
Article Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. Syntax NORMINV ( probability , mean , standard_dev ) Pr...
Excel 2003
AVERAGE
Article Show All Hide All Returns the average (arithmetic mean) of the arguments. Syntax AVERAGE ( number1 ,number2,...) Number1, number2, ...      are 1 to 30 numeric ...
Excel 2003
MODE
Article Returns the most frequently occurring, or repetitive, value in an array or range of data. Syntax MODE ( number1 ,number2,...) Number1, number2, ...   are 1 to...
Excel 2003
STDEVP
Article Calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the...
Excel 2003
STDEVPA
Article Calculates standard deviation based on the entire population given as arguments, including text and logical values. The standard deviation is a measure of how w...
Excel 2003
STEYX
Article Returns the standard error of the predicted y-value for each x in the regression. The standard error is a measure of the amount of error in the prediction of y ...
Excel 2003
FINV
Article Returns the inverse of the F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x. The F distribution can be used in an F-test that compares the ...
Excel 2003
FISHERINV
Article Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then F...
Excel 2003
NORMSINV
Article Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one. Syntax NORMSINV ( proba...
Excel 2003
NORMSDIST
Article This function returns the standard normal cumulative distribution function. Use this function in place of a table of standard normal curve areas.
Excel 2003
EXPONDIST
Article Show All Hide All Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliv...
Excel 2003
LOGEST
Article In regression analysis, calculates an exponential curve that fits your data and returns an array of values that describes the curve. Because this function retur...
Excel 2003
Statistical functions
Article Learn what statistical functions are available in Excel and what they do.
Excel 2003
PREVNEXT
Didn't find what you were looking for?Search all of Office.com