Useful Statistical Function Commands in Microsoft Excel

(Note: array represents a sample data set in excel)

Count =count(array)

Sum =sum(array)

Mean (average) =average(array)

Median =median(array)

Standard Deviation =stdev(array)

Variance =var(array)

Maximum =max(array)

Minimum =min(array)

Percentile =percentile(array,value)

e.g., to find the 95^th percentile à =percentile(array,0.95)

Slope =slope(Y array, X array)

Intercept =intercept(Y array, X array)

Correlation =correl(array 1, array 2)

Using Normal Distribution Function:

=normdist(X,mean,standard deviation, true) à returns the Prob(x<X) using the cumulative normal distribution based on the specified mean and standard deviation.

=normsdist(Z) à returns the Prob(z<Z) using the standard normal cumulative distribution (mean of zero and standard deviation of one).

=normsinv(probability) à returns the inverse of the standard normal cumulative distribution for a given probability.

Random Number Generator – rand() may be used to generate a random number between 0 and 1.