User:Sqltool/sidexsidenavframetest
This is to test putting collapsable navframes in a side-by-side configuration, rather than stacked.
Alternatively
[edit]"infobox NavFrame" style="width:310px;text-align:left;">
[[ 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 ]]
[[ 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 ]]