【實用生產應用app】Statsheet - Statistics Spreadsheet|最夯免費app-綠色工廠好玩App

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 deviationSTDDEV - Find the standard deviationNORMDIST - Find the normal distribution (x,mean,stddev,cumulative)NORMSDIST - Returns the standard normal cumulative distribution function. With a mean=0, stddev=1ZTEST - 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.