deg_freedom1, deg_freedom2, cumulative) F.DIST.RT(x. Returns the two-tailed p-value of a z-test.ĬHISQ.DIST(x, deg_freedom, cumulative) (x, deg_freedom, cumulative) CHISQ.TEST(actual_range, expected_range) CONFIDENCE.NORM(alpha, standard_dev, size) CONFIDENCE.T(alpha, standard_dev, size) CORREL(arrayl, array2) EXPON.DIST(x, lambda, cumulative) F.DIST(x. Computes the variance of a set of data, assumed to be an entire population. Computes the variance of a set of data, assumed to be a sample.
Returns the probability associated with a t-test. Returns the two-tailed inverse of the t-distribution. Returns the left-tailed inverse of the t-distribution. Returns the two-tailed t-distribution value. Returns the left-tailed t-distribution value. Returns values along a linear trend line.
Computes the standard deviation of a set of data, assumed to be an entire population. Computes the standard deviation of a set of data, assumed to be a sample. Returns a normalized value for a distribution characterized by a mean and standard deviation. Computes the skewness, a measure of the degree to which a distribution is not symmetric around its mean. Computes the kth percentile of data in a range, inclusive. Computes the kth percentile of data in a range, exclusive. Returns the inverse of the standard normal distribution. Returns the standard normal cumulative distribution (mean = 0, standard deviation = 1). Returns the inverse of the cumulative normal distribution. Returns the normal cumulative distribution for the specified mean and standard deviation. Computes the modes (most frequently occurring values) of a set of data. Computes the median (middle value) of a set of data. Returns the cumulative lognormal distribution of x, where ln (x) is normally distributed with parameters mean and standard deviation. Returns an array that describes a straight line that best fits the data. Calculates a future value along a linear trend. Returns the left-tailed F-probability distribution value. Computes the correlation coefficient between two data sets. Returns the confidence interval for a population mean using a t-distribution.
Returns the confidence interval for a population mean using a normal distribution. Returns the test for independence the value of the chi-square distribution and the appropriate degrees of freedom. Returns the right-tailed probability of the chi-square distribution. Returns the left-tailed probability of the chi-square distribution. Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Returns the individual term binomial distribution. Useful Statistical Functions in Excel 2010ĪVERAGE(data range) BINOM.DIST(number_s, trials, probability_s, cumulative) BINOM.INV(trials, probability_s, alpha)Ĭomputes the average value (arithmetic mean) of a set of data.
0 kommentar(er)
