| CONTINUOUS DATA |
| LOCATION |
| AVERAGE |
Average (arithmetic mean) |
| AVERAGE_q |
Average (arithmetic mean) |
| COUNT |
Number of rows in a table that contain numbers |
| COUNT_q |
Number of rows in a table that contain numbers |
| GEOMEAN |
Geometric mean for a dataset containing positive numbers |
| GEOMEAN_q |
Geometric mean for a dataset containing positive numbers |
| GEOMEAN - 2008 |
Geometric mean for a dataset containing positive numbers 2008 only |
| HARMEAN |
Harmonic mean of a dataset containing positive numbers |
| HARMEAN_q |
Harmonic mean of a dataset containing positive numbers |
| HARMEAN - 2008 |
Harmonic mean of a dataset containing positive numbers 2008 only |
| MEDIAN |
Calculate the median value in a dataset |
| MEDIAN_q |
Calculate the median value in a dataset |
| MEDIAN - 2008 |
Calculate the median value in a dataset 2008 only |
| MODE |
Calculate the most common value in a dataset |
| MODE_q |
Calculate the most common value in a dataset |
| MODE - 2008 |
Calculate the most common value in a dataset 2008 only |
| TRIMMEAN |
Calculate the mean of the interior of a dataset |
| TRIMMEAN_q |
Calculate the mean of the interior of a dataset |
| TRIMMEAN - 2008 |
Calculate the mean of the interior of a dataset 2008 only |
| |
|
| DISPERSION |
| AVEDEV |
Average of the absolute deviations |
| AVEDEV_q |
Average of the absolute deviations |
| AVEDEV - 2008 |
Average of the absolute deviations 2008 only |
| COVAR (new aggregate format) |
Covariance |
| COVAR_q |
Covariance |
| COVAR - 2008 |
Covariance 2008 only |
| DEVSQ (new aggregate format) |
Sum of the squares of deviations |
| DEVSQ_q |
Sum of the squares of deviations |
| DEVSQ - 2008 |
Sum of the squares of deviations 2008 only |
| IPR - 2008 |
Calculate the inter-percentile range of a dataset 2008 only |
| IQR - 2008 |
Calculate the inter-quartile range of a dataset 2008 only |
| LARGE |
Calculate the kth largest value in a dataset |
| LARGE_q |
Calculate the kth largest value in a dataset |
| LARGE - 2008 |
Calculate the kth largest value in a dataset 2008 only |
| PERCENTILE |
Calculate the kth percentile of value in a dataset |
| PERCENTILE_q |
Calculate the kth percentile of value in a dataset |
| PERCENTILE - 2008 |
Calculate the kth percentile of value in a dataset 2008 only |
| PERCENTILE_EXC - 2008 |
Calculate the kth percentile of value in a dataset 2008 only |
| PERCENTRANK |
Calculate rank of a value in a dataset as a percentage of the dataset |
| PERCENTRANK_q |
Calculate rank of a value in a dataset as a percentage of the dataset |
| PERCENTRANK - 2008 |
Calculate rank of a value in a dataset as a percentage of the dataset 2008 only |
| PERCENTRANK_EXC - 2008 |
Calculate rank of a value in a dataset as a percentage of the dataset 2008 only |
| QUARTILE |
Calculate the quartile of a dataset |
| QUARTILE_q |
Calculate the quartile of a dataset |
| QUARTILE - 2008 |
Calculate the quartile of a dataset 2008 only |
| QUARTILE_EXC - 2008 |
Calculate the quartile of a dataset 2008 only |
| RANGE - 2008 |
Calculate the difference between the min and max of a dataset 2008 only |
| RANK |
Calculate the rank of a number in a list of numbers |
| RANK_q |
Calculate the rank of a number in a list of numbers |
| RANK - 2008 |
Calculate the rank of a number in a list of numbers 2008 only |
| RANKAVG - 2008 |
Calculate the average rank of a number in a list of numbers 2008 only |
| SMALL |
Calculate the kth smallest value in a dataset |
| SMALL_q |
Calculate the kth smallest value in a dataset |
| SMALL - 2008 |
Calculate the kth smallest value in a dataset 2008 only |
| STDEV |
Standard deviation |
| STDEV_q |
Standard deviation |
| STDEV - 2008 |
Standard deviation 2008 only |
| STDEVP |
Standard deviation for an entire population |
| STDEVP_q |
Standard deviation for an entire population |
| STDEVP - 2008 |
Standard deviation for an entire population 2008 only |
| |
|
| SHAPE |
| KURT (new aggregate format) |
Calculate the kurtosis of a dataset |
| KURT_q |
Calculate the kurtosis of a dataset |
| KURT - 2008 |
Calculate the kurtosis of a dataset 2008 only |
| SKEW (new aggregate format) |
The degree of asymmetry of a distribution |
| SKEW_q |
The degree of asymmetry of a distribution |
| SKEW - 2008 |
The degree of asymmetry of a distribution 2008 only |
| VAR |
Variance |
| VAR_q |
Variance |
| VAR - 2008 |
Variance 2008 only |
| VARP |
Variance for an entire population |
| VARP_q |
Variance for an entire population |
| VARP - 2008 |
Variance for an entire population 2008 only |
| |
|
| STATISTICAL INFERENCE |
| SPECIFIC TESTS |
| CHISQ |
Chi-square statistic |
| CHISQ2 |
Chi-square statistic (user-specified expected range) |
| CHISQ_q |
Chi-square statistic |
| CHISQ2_q |
Chi-square statistic (user-specified expected range) |
| CHISQN |
Chi-square statistic on normalized tables |
| CHISQN_q |
Chi-square statistic on normalized tables |
| CHISQN - 2008 |
Chi-square statistic on normalized tables 2008 only |
| CHISQN2 |
Chi-square statistic on normalized tables (user-specified expected range) |
| CHISQN2_q |
Chi-square statistic on normalized tables (user-specified expected range) |
| CHISQN2 - 2008 |
Chi-square statistic on normalized tables (user-specified expected range) 2008 only |
| CHITEST |
Pearson chi-square test for independence |
| CHITEST2 |
Pearson chi-square test for independence (user-specified expected range) |
| CHITEST_q |
Pearson chi-square test for independence |
| CHITEST2_q |
Pearson chi-square test for independence (user-specified expected range) |
| CHITESTN |
Pearson chi-square test for independence on normalized tables |
| CHITESTN_q |
Pearson chi-square test for independence on normalized tables |
| CHITESTN - 2008 |
Pearson chi-square test for independence on normalized tables 2008 only |
| CHITESTN2 |
Pearson chi-square test for independence on normalized tables (user-specified expected range) |
| CHITESTN2_q |
Pearson chi-square test for independence on normalized tables (user-specified expected range) |
| CHITESTN2 - 2008 |
Pearson chi-square test for independence on normalized tables (user-specified expected range) 2008 only |
| FTEST |
Determine whether two samples have different variances |
| FTEST_q |
Determine whether two samples have different variances |
| FTEST - 2008 |
Determine whether two samples have different variances 2008 only |
| TTEST |
Calculate the probability associated with Student’s t-test |
| TTEST_q |
Calculate the probability associated with Student’s t-test |
| TTEST - 2008 |
Calculate the probability associated with Student’s t-test 2008 only |
| ZTEST (new aggregate format) |
Calculate the one-tailed probability of a Z-test |
| ZTEST_q |
Calculate the one-tailed probability of a Z-test |
| ZTEST - 2008 |
Calculate the one-tailed probability of a Z-test 2008 only |
| |
|
| CORRELATION AND REGRESSION ANALYSIS |
| CORRELATIONS |
| CORREL (new aggregate format) |
Correlation coefficient |
| CORREL_q |
Correlation coefficient |
| CORREL - 2008 |
Correlation coefficient 2008 only |
| PEARSON (new aggregate format) |
Pearson correlation coefficient |
| PEARSON_q |
Pearson correlation coefficient |
| PEARSON - 2008 |
Pearson correlation coefficient 2008 only |
| PROB |
Calculate probability that values in a range are between two limits |
| PROB_q |
Calculate probability that values in a range are between two limits |
| PROB - 2008 |
Calculate probability that values in a range are between two limits 2008 only |
| RSQ (new aggregate format) |
Pearson product moment correlation coefficient |
| RSQ_q |
Pearson product moment correlation coefficient |
| RSQ - 2008 |
Pearson product moment correlation coefficient 2008 only |
| |
|
| LINEAR REGRESSIONS |
| FORECAST (new aggregate format) |
Calculate a future value |
| FORECAST_q |
Calculate a future value |
| FORECAST - 2008 |
Calculate a future value 2008 only |
| GROWTH (new aggregate format) |
Predicted exponential growth |
| GROWTH_q |
Predicted exponential growth |
| GROWTH - 2008 |
Predicted exponential growth 2008 only |
| GROWTHMX New! |
Calculate values along an exponential trend for multiple x values |
| GROWTHMX_q New! |
Calculate values along an exponential trend for multiple x values |
| INTERCEPT (new aggregate format) |
Calculate the point at which a line will intersect the y-axis |
| INTERCEPT_q |
Calculate the point at which a line will intersect the y-axis |
| INTERCEPT - 2008 |
Calculate the point at which a line will intersect the y-axis 2008 only |
| LINEST New! |
Calculate the straight line that fits a series of X and Y values |
| LINEST_q New! |
Calculate the straight line that fits a series of X and Y values |
| LOGEST New! |
Calculate the exponential curve tha fits a series of X and Y values |
| LOGEST_q New! |
Calculate the exponential curve that fits a series of X and Y values |
| SLOPE (new aggregate format) |
Slope of linear regression |
| SLOPE_q |
Slope of linear regression |
| SLOPE - 2008 |
Slope of linear regression 2008 only |
| TREND (new aggregate format) |
Calculate the values along a linear trend |
| TREND_q |
Calculate the values along a linear trend |
| TREND - 2008 |
Calculate the values along a linear trend 2008 only |
| TRENDMX New! |
Calculate the values along a linear trend for multiple x values |
| TRENDMX_q New! |
Calculate the values along a linear trend for multiple x values |
| |
|
| DATA COLLECTION |
| SAMPLING |
| STEYX (new aggregate format) |
Standard error |
| STEYX_q |
Standard error |
| STEYX - 2008 |
Standard error 2008 only |
| |
|
| DISTRIBUTIONS |
| BETADIST |
Beta cumulative probability density |
| BETAINV |
Inverse of the beta cumulative probability density |
| BETAPDF |
Beta distribution (pdf) |
| BINOMDIST |
Binomial distribution |
| BINOMINV |
Inverse (quantile) of the binomial distribution |
| BIVAR |
Bivariate normal probabilities |
| CAUCHY |
Cauchy distribution (cdf or pdf) |
| CAUCHYINV |
Inverse (quantile) of the Cauchy distribution (cdf) |
| CHI2NC |
Non-Central Chi-square distribution |
| CHI2NCINV |
Inverse of the Non-Central Chi-square distribution |
| CHIDIST |
Chi-square distribution |
| CHIINV |
Inverse of the Chi-square distribution |
| CONFIDENCE |
Confidence interval |
| CRITBINOM |
Criterion value for the cumulative binomial distribution |
| EXPDIST |
Exponential distribution (cdf or pdf) |
| EXPONDIST |
Exponential distribution - Excel version |
| EXPINV |
Inverse (quantile) of the exponential distribution |
| FDIST |
F probability distribution |
| FINV |
Inverse of the F probability distribution |
| FPDF |
F distribution (pdf) |
| FISHER |
Fisher transformation |
| FISHERINV |
Inverse of the Fisher transformation |
| GAMMADIST |
Gamma distribution |
| GAMMAINV |
Inverse of the cumulative gamma distribution |
| GAMMAP |
Regularized gamma function P(a, x) |
| GAMMAQ |
Regularized gamma function Q(a, x) |
| GEOMETRIC |
Geometric distribution (cdf or pdf) |
| GEOMETRICP |
Cumulative distribution function of the Geometric distribution |
| GEOMETRICINV |
Inverse (quantile) of the Geometric distribution |
| HYPGEOMDIST |
Hypergeometric distribution |
| HYPGEOMDISTP |
Hypergeometric distribution P-tail |
| HYPGEOMDISTPINV |
Inverse of the pdf of the Hypergeometric distribution |
| HYPGEOMDISTQ |
Hypergeometric distribution Q-tail |
| INVGAMMAP |
Inverse of the incomplete gamma function P(a,x) |
| LAPLACE |
Laplace distribution (cdf or pdf) |
| LAPLACEINV |
Inverse (quantile) of the Laplace distribution |
| LOGINV |
Inverse of the lognormal cumulative distribution |
| LOGISTIC |
Logistic distribution (cdf or pdf) |
| LOGISTICINV |
Inverse (quantile) of the logistic distribution |
| LOGNORMDIST |
Lognormal cumulative distribution |
| LOGNORMPDF |
Lognormal distribution (pdf) |
| NCFCDF |
Non-central F distribution (cdf) |
| NCFINV |
Inverse (quantile) of the Non-central F distribution |
| NCFPDF |
Non-central F distribution (pdf) |
| NCHISQPDF |
Non-central chi square distribution (pdf) |
| NCTCDF |
Non-central T distribution (cdf) |
| NCTINV |
Inverse (quantile) of the Non-central T distribution |
| NCTPDF |
Non-central T distribution (pdf) |
| NEGBINOMDIST |
Negative binomial distribution |
| NEGBINOMDISTP |
Negative binomial distribution (pdf) |
| NEGBINOMINV |
Inverse (quantile) of the Negative binomial distribution |
| NORMAL |
Probability density function for the standard normal distribution |
| NORMDIST |
Normal distribution |
| NORMINV |
Inverse of the normal cumulative distribution |
| NORMSDIST |
Standard normal cumulative distribution |
| NORMSINV |
Inverse of the standard normal cumulative distribution |
| POISSON |
Poisson distribution |
| POISSONINV |
Inverse (quantile) of the Poisson distribution |
| STANDARDIZE |
Normalized value from a distribution |
| STUDENTST |
Student's t-distribution |
| TDIST |
Probability for the Student t-distribution |
| TINV |
Value of the Student's t-distribution |
| UNIFORM |
Uniform distribution (cdf or pdf) |
| UNIFORMINV |
Inverse (quantile) of the Uniform distribution |
| WEIBULL |
Weibull distribution |
| WEIBULLINV |
Inverse (quantile) of the Weibull distribution |
| |
|
| COMBINATORICS |
| BETA |
Beta |
| BETAI |
Incomplete beta |
| BICO |
Binomial coefficient |
| FACTLN |
Natural logarithm of a factorial |
| GAMMA |
Complete gamma function |
| GAMMAINC |
Incomplete gamma |
| GAMMALN |
Natural logarithm of the complete gamma |
| PERMUT |
Permutations |
| |
|
| XLDB_STATISTICS_VERSION |
Version Information |
| |
|
| XLDB Statistics Sample Data |
|