This is to test putting collapsable navframes in a side-by-side configuration, rather than stacked.
XLeratorDB
Function Packages
Alternatively
edit"infobox NavFrame" style="width:310px;text-align:left;">
XLeratorDB
FUNCTION PACKAGES
FINANCIAL
[[ http://www.westclintech.com/Products/XLeratorDBfinancial/XLeratorDBfinancialDocumentation/tabid/64/Default.aspx | XLeratorDB/Financial Documentation ]]
|
|
[[ http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/XLDB_FINANCIAL_VERSION/Default.aspx | XLDB/FIN Release Version Information ]]
STATISTICS
[[ http://www.westclintech.com/Products/XLeratorDBstatistics/XLeratorDBstatisticsDocumentation/tabid/159/Default.aspx | XLeratorDB/Statistics Documentation ]]
Statistical Functions
| AVEDEV | average of the absolute deviations |
| AVEDEV_q | average of the absolute deviations |
| AVERAGE | average (arithmetic mean) |
| AVERAGE_q | average (arithmetic mean) |
| CHISQ | Chi-square statistic |
| CHISQ_q | Chi-square statistic |
| CHISQN | Chi-square statistic on normalized tables |
| CHISQN_q | Chi-square statistic on normalized tables |
| CHITEST | Pearson chi-square test for independence |
| CHITEST_q | Pearson chi-square test for independence |
| CHITESTN | Pearson chi-square test for independence on normalized tables |
| CHITESTN_q | Pearson chi-square test for independence on normalized tables |
| CORREL | correlation coefficient |
| CORREL_q | correlation coefficient |
| COUNT | Number of rows in a table that contain numbers |
| COUNT_q | Number of rows in a table that contain numbers |
| COVAR | Covariance |
| COVAR_q | Covariance |
| DEVSQ | sum of the squares of deviations |
| DEVSQ_q | sum of the squares of deviations |
| FORECAST | calculate a future value |
| FORECAST_q | calculate a future value |
| FTEST | determine whether two samples have different variances |
| FTEST_q | determine whether two samples have different variances |
| GEOMEAN | geometric mean for a dataset containing positive numbers |
| GEOMEAN_q | geometric mean for a dataset containing positive numbers |
| GROWTH | predicted exponential growth |
| GROWTH_q | predicted exponential growth |
| HARMEAN | harmonic mean of a dataset containing positive numbers |
| HARMEAN_q | harmonic mean of a dataset containing positive numbers |
| INTERCEPT | 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 |
| KURT | calculate the kurtosis of a dataset |
| KURT_q | calculate the kurtosis of a dataset |
| LARGE | calculate the kth largest value in a dataset |
| LARGE_q | calculate the kth largest value in a dataset |
| MEDIAN | calculate the median value in a dataset |
| MEDIAN_q | calculate the median value in a dataset |
| MODE | calculate the most common value in a dataset |
| MODE_q | calculate the most common value in a dataset |
| PEARSON | Pearson correlation coefficient |
| PEARSON_q | Pearson correlation coefficient |
| PERCENTILE | calculate the kth percentile of value in a dataset |
| PERCENTILE_q | calculate the kth percentile of value in a dataset |
| 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 |
| 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 |
| QUARTILE | calculate the quartile of a dataset |
| QUARTILE_q | calculate the quartile of a dataset |
| 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 |
| RSQ | Pearson product moment correlation coefficient |
| RSQ_q | Pearson product moment correlation coefficient |
| SKEW | the degree of asymmetry of a distribution |
| SKEW_q | the degree of asymmetry of a distribution |
| SMALL | calculate the kth smallest value in a dataset |
| SMALL_q | calculate the kth smallest value in a dataset |
| STDEV | standard deviation |
| STDEV_q | standard deviation |
| STDEVP | standard deviation for an entire population |
| STDEVP_q | standard deviation for an entire population |
| STEYX | standard error |
| STEYX_q | standard error |
| TREND | calculate the values along a linear trend |
| TREND_q | calculate the values along a linear trend |
| TRIMMEAN | calculate the mean of the interior of a dataset |
| TRIMMEAN_q | calculate the mean of the interior of a dataset |
| TTEST | calculate the probability associated with Student’s t-test |
| TTEST_q | calculate the probability associated with Student’s t-test |
| VAR | variance |
| VAR_q | variance |
| VARP | variance for an entire population |
| VARP_q | variance for an entire population |
| ZTEST | calculate the one-tailed probability of a Z-test |
| ZTEST_q | calculate the one-tailed probability of a Z-test |
Probability Functions
| FUNCTION LIKE PER | description |
[[ http://www.westclintech.com/Products/XLeratorDBstatistics/XLeratorDBstatisticsDocumentation/tabid/159/topic/XLDB_STATISTICS_VERSION/Default.aspx | XLDB/Stats Release/Version Information ]]
MATH
and it has a caption
ENGINEERING
and it has a caption
UNIT CONVERSIONS
and it has a caption
STRINGS
and it has a caption