12月5日的Statsheet Spreadsheet应用程序分析

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.