And it is now available for your iPhone as well! Download it from the app store here. 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.
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.