The following tables list the members exposed by Statistics.
Name | Description | |
---|---|---|
Anova |
This method performs an Anova test for two or more series of data. This analysis tool performs simple analysis of variance (anova) to test the hypothesis that means from two or more samples are equal (drawn from populations with the same mean). This technique expands on the tests for two means, such as the t-test. | |
BetaFunction |
This method returns the beta function for two given values. Calculates Beta Function | |
Correlation |
This method gets the correlation value for two series of data. This analysis tool and its formulas measure the relationship between two data sets that are scaled to be independent of the unit of measurement. The population correlation calculation returns the covariance of two data sets divided by the product of their standard deviations. You can use the Correlation tool to determine whether two ranges of data move together — that is, whether large values of one set are associated with large values of the other (positive correlation), whether small values of one set are associated with large values of the other (negative correlation), or whether values in both sets are unrelated (correlation near zero). | |
Covariance |
This method gets the covariance value for two series of data. This analysis tool and its formula return the average of the product of deviations of data points from their respective means. Covariance is a measure of the relationship between two ranges of data. You can use the Covariance tool to determine whether two ranges of data move together — that is, whether large values of one set are associated with large values of the other (positive covariance), whether small values of one set are associated with large values of the other (negative covariance), or whether values in both sets are unrelated (covariance near zero). | |
FDistribution |
This method returns the cumulative F distribution function probability. /// Returns the F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can examine test scores given to men and women entering high school and determine if the variability in the females is different from that found in the males. | |
FTest |
This method performs an F Test using F distribution, and is used to see if two samples have different variances. This analysis tool performs a two-sample F-test to compare two population variances. For example, you can use an F-test to determine whether the time scores in a swimming meet have a difference in variance for samples from two teams. | |
GammaFunction |
This method returns the gamma function value for the given variable. Calculates Gamma Function | |
InverseFDistribution |
This method returns the inverse of the F cumulative distribution. Returns the inverse of the F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x. The F distribution can be used in an F-test that compares the degree of variability in two data sets. For example, you can analyze income distributions in the United States and Canada to determine whether the two countries have a similar degree of diversity. | |
InverseNormalDistribution |
This method returns the inverse of the standard normal cumulative distribution. Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. | |
InverseTDistribution |
This method returns the t-value of the Student's t-distribution as a function of probability and degrees of freedom. Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. | |
Mean |
This method returns the average of all data points stored in the specified series. /// Returns the average (arithmetic mean) of the arguments. | |
Median |
This method returns the median of all data points in the specified series. Returns the median of the given numbers. The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less. | |
NormalDistribution |
This method returns the probability for the standard normal cumulative distribution function. Returns the normal cumulative distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing. | |
TDistribution |
This method returns the probability for the T distribution (student's distribution). Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution. | |
TTestEqualVariances |
This method performs a T Test using Students distribution (T distribution) with equal variances. Two-Sample Assuming Equal Variances - This analysis tool performs a two-sample student's t-test. This t-test form assumes that the means of both data sets are equal; it is referred to as a homoscedastic t-test. You can use t-tests to determine whether two sample means are equal. | |
TTestPaired |
This method performs a T Test using Students distribution (T distribution) with paired samples. This analysis tool and its formula perform a paired two-sample student's t-test to determine whether a sample's means are distinct. This t-test form does not assume that the variances of both populations are equal. You can use a paired test when there is a natural pairing of observations in the samples, such as when a sample group is tested twice — before and after an experiment. | |
TTestUnEqualVariances |
This method performs a T Test using Students distribution (T distribution) with unequal variances. This analysis tool and its formulas perform a two-sample student's t-test. This t-test form assumes that the variances of both ranges of data are unequal; it is referred to as a heteroscedastic t-test. You can use a t-test to determine whether two sample means are equal. Use this test when the groups under study are distinct. Use a paired test when there is one group before and after a treatment. | |
Variance |
This method returns the variance for a data group. Estimates variance based on a sample. | |
ZTest |
This method performs a Z test for two series of data. The z-test generates a standard score for x with respect to the data set, array, and returns the two-tailed probability for the normal distribution. You can use this function to assess the likelihood that a particular observation is drawn from a particular population. |