"Total
Access Statistics performs a wide range of data analysis right inside
Access. The product includes a Statistics Wizard to perform parametric,
group, non-parametric, record analysis and more. The results are placed
in Access tables that you can integrate into your forms and reports."
Alison Balter, Author
More Reviews
|
|
SHIPPING VERSION FOR MICROSOFT ACCESS 2010
New Features:
|
- Supports Access 2010's 32 and 64 bit versions
- New financial calculations for cash flow analysis
including PV, NPV, FV, IRR, MIRR, XIRR, XMIRR, etc.
- Supports all Access database formats used by Access 2010
including ACCDB, MDB, and ADPs
- Improved user interface
- Updated help file
- details...
New X.8 Version for
MS Access 2007, 2003, 2002, and 2000
|
The Most Powerful Data Analysis Program for Microsoft Access
Microsoft Access queries offer basic 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, the Microsoft Access community has relied on Total Access
Statistics for almost two decades for advanced number crunching 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 and Missing (null values)
- Minimum, Maximum, Range, Sum, Sum of Squares, Mean
- 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
 Financial Cash Flow Calculations
NEW!
Use discounted cash flows and interest rates to generate Net Present Value (NPV), Present Value
(FV), Future Value (FV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR)
for periodic and irregular (date dependent) payments and receipts. Eliminate
the need to use Microsoft Excel® for these calculations. Additional
details on Financial Cash Flow Calculations
in Microsoft Access
Percentiles
- Median, Quartiles, Quintiles, Deciles, Octiles, 5th percentile,
Percentile, 0.5 Percentile.
- Results generated in a separate table or by updating a field in your
existing table
- Additional details on Calculating Percentiles in Microsoft Access
Running Totals and Moving Averages
Field Comparison
- Mean difference, Standard Deviation of difference
- Covariance, Correlation, R-Square
- Paired t-Test, Probability (1 or 2 tails)
Frequency Distributions
Regressions
Cross-Tabulation and Chi-Square with Expected Values
Group Analysis
- Two Sample t-Test
- One Way Analysis of Variance (ANOVA)
- Two Way ANOVA
Record Analysis
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 Rank 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
VBA 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 distribute our small library (under 2.5 MB) with your database and
you'll be generating advanced statistical analysis. Here's more information on
adding statistical analysis to Microsoft
Access using VBA.
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!
Pricing and Versions
Total Access Statistics runs as an Access add-in which is dependent on
your version of Access. Each version can support all the database types
supported by that Access version. For instance, Total Access Statistics 2010
can run on all ACCDB and ADP databases, and MDB database formats since
Access 2000.
Upgrade Versions
For existing customers, new versions of Total Access Statistics are
now available. Click below for a list of enhancements:
|
|
All Our Microsoft Access Products
Single
