table-valued function to calculate one or many percentile values from a single dataset
Read moreEstimate variance based on a sample, or use VAR to estimate the population variance from a sample of N elements with an unknown mean (the mean being calculated from the sample itself).
Read moreEstimate variance based on a sample, or use VAR_S to estimate the population variance from a sample of N elements with an unknown mean (the mean being calculated from the sample itself).
Read moreCalculate the predicted value for a dependent variable using the coeffiecients from a previously run mutlivariate exponential regression.
Read morethe point at which a line will intersect the y-axis by using existing x-values and y-values
Read moreCalculate the point at which a line will intersect the y-axis by using existing x-values and y-values.
Read morethe Ordinary Least Squares (OLS) solution for a series of x-values and y-values including a tolerance parameter for collinearity
Read moreCalculate the predicted value for a dependent variable using the coefficients from a previously run multivariate linear regression.
Read moreCalculate the probability that Y = 1 given a set of coefficients from a logistic regression
Read morethe Pearson product moment correlation coefficient through data points in known-y’s and known-x’s
Read moreReturn the Pearson product moment correlation coefficient through data points in known-y’s and known-x’s.
Read moreslope of the linear regression through the data points in the known x-values and y-values
Read moreCalculate the slope of the linear regression through the data points in the known x-values and y-values.
Read moreCalculate a weighted least squares (WLS) solution for a series of x- and y-values and their associated weights.
Read moreCalculate a weighted least squares (WLS) solution for a series of x- and y-values and their associated weights.
Read moreCalculate the probability density function or the lower cumulative distribution function of the Cauchy distribution.
Read moreCalculate the lower cumulative distribution function of the non-central chi-square distribution.
Read moreCalculate the inverse of the lower cumulative distribution function of the non-central chi-square distribution.
Read moreCalculate the inverse of the right-tailed probability of a chi-squared distribution.
Read moreCalculate a value that you can use to construct a confidence interval for a population mean.
Read moreCalculate a confidence interval when you don't know the population standard deviation and are using the sample standard deviation instead.
Read moreCalculate the smallest value for the cumulative binomial distribution that is greater than or equal to a criterion value.
Read moreCalculate the probability density function or the upper cumulative distribution function of the Exponential distribution.
Read moreCalculate the inverse of the cumulative distribution function of the exponential distribution.
Read moreCalculate an exponential distribution that is equivalent to the function used in EXCEL.
Read moreCalculate the inverse of the cumulative distribution function of the geometric distribution.
Read moreCalculate the inverse of the cumulative distribution function of the hypergeometric distribution.
Read moreCompute the complementary cumulative probability P[Dn>= x] of the Kolmogorov-Smirnov distribution with sample size n at x.
Read moreCompute the cumulative probability P[Dn>= x] of the Kolmogorov-Smirnov distribution with sample size n at x.
Read moreCalculate the inverse of the Kolmogorov-Smirnov (KS) cumulative distribution function.
Read moreCalculate the complementary Kolmogorov-Smirnov (KS) cumulative distribution function, Qks= 1 - Pks.
Read moreCalculate the inverse of the complementary Kolmogorov-Smirnov (KS) cumulative distribution function, Qks= 1 - Pks.
Read moreCalculate the probability density function or the lower cumulative distribution function of the Laplace distribution.
Read moreCalculate the inverse of the lognormal cumulative distribution function of x where ln(x) is normally distributed within the parameters mean and standard deviation.
Read moreCalculate the probability density function or the lower cumulative distribution function of the logistic distribution.
Read moreCalculate the inverse lower cumulative distribution of the logistic distribution.
Read moreCalculate the inverse of the lognormal distribution function of x, when ln(x) is normally distributed with parameters µ and s.
Read moreCalculate the lognormal cumulative distribution function of x where ln(x) is normally distributed within the parameters mean and standard deviation.
Read moreCalculate the lower cumulative distribution function of the non-central F distribution.
Read moreCalculate the inverse of the lower cumulative distribution function of the non-central F distribution.
Read moreCalculate the probability density function of the non-central chi square distribution.
Read moreCalculate the lower cumulative distribution function of the non-central T distribution.
Read moreCalculate the inverse of the lower cumulative distribution function of the non-central T distribution.
Read moreCalculate the probability density function or the lower cumulative distribution function of the standard normal distribution in SQL Server.
Read morenormalized value from a distribution for a specified mean and standard deviation
Read moreCalculate the probability density function and the left-tailed cumulative probability distribution of Student's t-distribution.
Read moreCalculate the two-tailed cumulative probability distribution of Student's t-distribution.
Read moreCalculate the right-tailed cumulative probability distribution of Student's t-distribution.
Read moreCalculate the probability for the Studentt-distribution where a numeric value (x) is a calculated value oftfor which the probability is to be computed.
Read moreCalculate the probability density function or the lower cumulative distribution function of the uniform distribution.
Read moreCalculate the inverse of the lower cumulative distribution of the uniform distribution.
Read moreCalculate Cohen’s kappa () or weighted kappa as an index of inter-rater agreement between 2 raters.
Read moreCalculate Cohen’s kappa () or weighted kappa as an index of inter-rater agreement between 2 raters.
Read moreCalculate Fleiss’ kappa () as an index of inter-rater agreement betweenmraters on categorical data.
Read moreCalculate Fleiss’ kappa () as an index of inter-rater agreement between m raters on categorical data.
Read moreCalculate Kendall’s tau (t), a non-parametric measure of association based on the number of concordances and discordances in paired observations.
Read moreCalculate Kendall’s tau (t), a non-parametric measure of association based on the number of concordances and discordances in paired observations.
Read moreCalculate Kendall’s coefficient of concordance (w) as an index of inter-rater reliability for ordinal data.
Read moreCalculate Kendall’s coefficient of concordance (w) as an index of inter-rater reliability for ordinal data.
Read morePerform McNemar’s chi-squared test for symmetry of rows and columns in a two-dimensional contingency table.
Read morePerform McNemar’s chi-squared test for symmetry of rows and columns in a two-dimensional contingency table.
Read moreCalculate the Pearson chi-square test for independence on data in third-normal form.
Read moreCalculate the Pearson chi-square test for independence on data in third-normal form.
Read moreCalculate the Pearson chi-square test for independence on data in third-normal form.
Read moreCalculate the Pearson chi-square test for independence on data in third-normal form.
Read morePerform the two-sample Kolmogorov-Smirnov test to compare the distributions of the values in two samples.
Read morePerform the two-sample Kolmogorov-Smirnov test to compare the distributions of the values in two samples.
Read more