Statsheet Spreadsheet 1.5

Statsheet is your Statistics Spreadsheet, with all the statistics functions you would expect to find in an expensive stats package.

Like a very sophisticated calculator, this is a great way to practise statistics, and analyse stats.

These are some of the functions you will find fully supported:

AVEDEV - Find the average deviation
STDDEV - Find the standard deviation
NORMDIST - Find the normal distribution (x,mean,stddev,cumulative)
NORMSDIST - Returns the standard normal cumulative distribution function. With a mean=0, stddev=1
ZTEST - one-tailed probability-value of a z-test (array,μ0,sigma)
COMBIN - Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.
BINOMDIST - Returns the individual term binomial distribution probability. BINOMDIST(number_s,trials,probability_s,cumulative)
CORREL - Returns the correlation coefficient of the array1 and array2 cell ranges. Use the correlation coefficient to determine the relationship between two properties.
CONFIDENCE - Returns a value that you can use to construct a confidence interval for a population mean.