The Most Powerful Data Analysis Program for Microsoft^® Access^®

NOW AVAILABLE FOR MICROSOFT OFFICE ACCESS 2007 New Features:

Supports the Access 2007 ACCDB database format and new field types Supports ADP data in tables, views, stored procedures, and user defined functions Calculates Running Totals and Moving Averages Supports parameterized queries and more...

Microsoft Access queries offer rudimentary data analysis. For more advanced computations and real number crunching, programming is required, sometimes lots of it, or you need to export your data to another program.

Fortunately, Total Access Statistics addresses this need within Access. Designed specifically for Microsoft Access, Total Access Statistics runs as an add-in for Access and offers a wide range of statistical functions to analyze your data. Your data can be in Access tables, linked from other sources such as SQL Server, or from a query. Analyze multiple fields and an unlimited number of records at one time. You can even analyze data from multi-table select queries or crosstabs.

Best of all, the results are provided in tables which you can further analyze or add to your queries, forms, and reports. You'll be amazed at the powerful statistical analysis you can generate within Microsoft Access without being a mathematician or statistician!

Wide Range of Statistical Functions

Easily specify the fields to analyze and optional grouping fields, weighting field, and value or values to ignore. Perform a wide variety of powerful calculations:

Field Descriptives

• 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
• t-Test vs. Mean

Percentiles

Median, Quartiles, Quintiles, Deciles, Octiles, 5th percentile, Percentile, 0.5 Percentile
Here's additional information on Calculating Percentiles in Microsoft Access

Frequency Distributions

Field Comparison

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

Simple, Multiple, and Polynomial Regressions

Cross-Tabulation and Chi-Square with Expected Values

Running Totals and Moving Averages

• Cumulative or moving totals for average, sum, count, median, min, max, etc.

Group Analysis

• Two Sample T-Test
• One Way Analysis of Variance (ANOVA)
• Two Way ANOVA

Record Analysis

• Random Record Selection
• Record Rankings and Handling Ties
• Data Normalization

Non-Parametric Analysis

• One Sample Chi-Square
• One Sample Sign Test for Median, Mean, and Custom Value
• Kolmogorov-Smirnov Goodness of Fit Test
• Paired Sign Test, Spearman's Rho Correlation
• Wilcoxon Signed Rank Test for Matched Pairs
• Wald-Wolfowitz Runs Test
• Mann-Whitney U Two Sample (non-matched) Test
• Kruskal-Wallis One Way Analysis of Variance
• Friedman's Two Way Analysis of Variance

Probability Calculator

• Evaluate probability of test values: Z, t, Chi-Square, and F
• Calculate inverse probability

Additional Details of Statistical Analysis Calculations

No Programming Required

An interactive Wizard interface guides you through the process with no programming required! All results are generated in the most flexible format: Access tables. Easily display the results in your forms and reports. Your analysis settings are automatically saved so you can modify them later or run them again when your data changes.

Royalty-Free Runtime License Included

Programmers will appreciate the ability to by-pass the interactive interface to generate the results within an Access application. Amaze your users by performing advanced statistical analysis with a simple procedure call. Your users won't even know Total Access Statistics is running in the background. A royalty-free runtime license is included to let you include Total Access Statistics calculations within your applications for distribution to non-Total Access Statistics owners. Simply include our small 1.5 Meg file with your database and you'll be generating advanced statistical analysis.

Total Access Statistics is simply the best data analysis program for Access.

Demo Version Available

Download the free trial version to run Total Access Statistics against your own data to see how easy it is to generate complex calculations in Access.

Get the demo version!

New Versions

For existing customers, new versions of Total Access Statistics are now available. Click below for a list of enhancements:

• For Access 2007, Version 12 Enhancements
• For Access 2003, 2002, and 2000, Version x.7 Enhancements

Pricing