Statsheet Spreadsheet | Panload

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.