Technical Fact Sheet

Total VB Statistics offers a wide range of statistical functions for Visual Basic programmers using Microsoft Jet Engine databases. Any Access/Jet table or linked table such as SQL Server, dBase, or Paradox table can be analyzed.  Multi-table Select Queries can also be analyzed. An unlimited number of records can be analyzed.

Developed specifically for Visual Basic programmers, Total VB Statistics eliminates the need to export your data to other programs for statistical analysis. You can perform a wide range of statistical functions with all results in Microsoft Access tables. View, sort, query, or display the results. You can also add it to reports just like any other table.

Total VB Statistics includes two parts. The first is an interactive Statistics Scenario Designer. This standalone program lets you easily specify the database, data, fields, and analysis to perform. The second part is an ActiveX DLL component that performs the analysis. This file, under 1 Meg, is the only file you need to include with your VB applications to add statistical analysis.

The Total VB Statistics Scenario Designer

Features

• Statistically analyze data from any Jet Database or linked table
• Analyze multi-table Select queries
• Analyze an unlimited number of records
• All output in Jet tables
• No programming required to specify the analysis to perform
• Analysis settings are saved as "scenarios" which can be run again in the future
• Analyze multiple fields at one time
• Use data grouping fields to analyze groups of records (optional)
• Weight data based on a weighting field's value (optional)
• Ignore a numeric value or range of values (optional)
• Programmatic interface to add statistical analysis to your applications
• Includes a royalty-free runtime license
• Scenarios are compatible with Total Access Statistics. Scenarios created in either program can be run by the other.

Calculations available in Total VB Statistics

•  Field Analysis
• Percentile and Frequency Distributions
• Field Comparison
• Regression
• Cross Tabulation and Chi-Square
• Group Analysis
• Non-Parametric Analysis
• Probability Calculator

Field Analysis

• Count, Missing (blanks), Mean.
• Minimum, Maximum, Range, Sum, Sum of Squares.
• Variance, Coefficient of Variance, Std. Deviation, Std. Error.
• Geometric Mean, Harmonic Mean, Root Mean Square.
• Skewness, Kurtosis.
• Mode, Mode Count.
• t-Test versus Mean (test for null hypothesis).
• Confidence Intervals (t and Normal tests). 95% and user-specified levels.

• Percentiles: median, quartiles, deciles, and percentiles.
• Frequency distribution with user-specified group width, initial value and number of intervals. Display count, percent of total, sums and cumulative values.

• Mean difference
• Standard Deviation of difference
• Covariance
• Correlation
• R-Square
• Paired t-Test
• Probability (1 or 2 tails).

• Simple, Multiple and Polynomial (up to 9th order).
• With Y-Intercept or Zero-Intercept.
• Count, Missing, R-Square, Std. Error of Est., and ANOVA
• Coefficient analysis: P Std. Error, Beta, t-Value and Probability.
• Residual calculation for each data point.

• 10 types: Count, Sum, Average, Minimum, Maximum, Range, Variance, Coefficient of Variance, Std. Deviation, Std. Error.
• Count crosstabs for Text and Date value fields.
• Row total and Column sub-totals.
• Percent of Column, Row and Total.
• Sorted column fields with special handling for blank values.
• Chi-Square Analysis: Chi-Square, Probability, Cramer's V, Phi-Coefficient, Coefficient of Contingency.

• Two-Sample t-Tests (pooled and separate variance tests).
• ANOVA (Analysis of Variance) with sum of squares, F-Value and probability.

One Sample Sign Test for Median

• Two Sample Sign Test for Equal Median.
• Wald-Wolfowitz Sign Test for Equal Median.
• Wilcoxon Test for Matched Pairs.
• Mann-Whitney Two Sample (non-matched) Test.
• Kolmogorov-Smirnov Two Sample Test.
• Correlations: Spearman's Rho and Kendall's Tau.
• Kruskal-Wallis One Way Analysis of Variance.
• Friedman's Two Way Analysis of Variance.

• Evaluate probability of test values: Z, t, Chi-Square, and F.
  Enter the test value and degrees of freedom to see the corresponding probability.
• Calculate inverse probability. Enter a probability and calculate the equivalent Z, t, Chi-Square, and F value.
• Eliminate interpolating values in reference tables.

Total VB Statistics is available on a per developer basis and includes unlimited, royalty free distribution rights for that developer. It supports VB 5.0 and 6.0. A discounted five-developer package is also available. To place an order, click here.

Total VB Statistics Pricing for Visual Basic 6.0 (VB6)
Licenses
	Single	$599
	5 Seat	$1,799
Owners of Total Access Statistics can upgrade to Total VB Statistics at a discounted price
	Upgrade Single	CALL
	Upgrade 5 Seat	CALL
Premium Support Subscription
	Single License	$299
	5 Seat License	$999
	More Information
Also Available as part of:
	Total VB Enterprise Suite
Runtime/Redistributable Version
Royalty-free runtime rights are included in the purchase price.
Licensing Information
Total VB Statistics is licensed on a per developer basis. Each developer who uses or redistributes the program must have a license.

* Pricing and specifications are subject to change without notice.