Total Access Statistics is the Most Powerful Data Analysis Program for Microsoft Access that runs as an add-in for Access and offers a wide range of statistical functions to analyze your data.
How does Total Access Statistics analyze my data?
Total Access Statistics analyzes the data from your table and queries (for ADPs, it supports views, stored procedures, and user defined functions). The way it analyzes data is similar to the way you run an Access/SQL query where you can optionally "Group By" fields you want to perform separate calculations on, and "Sum" on fields to analyze. Multiple fields can be grouped and analyzed at one time.
For instance, if you had demographic data, you could group by "State" and perform percentile calculations on the "Age" and "Income" fields to see the percentiles for age and income (separately) for each State. If you didn't Group By "State", you'd simply get the percentile values for all the records.
You can also designate a weighting field, or a value or ranges of values to ignore in any of the calculations.
The results are provided in tables, so you can perform further analysis on them or include them in your queries, forms, reports, and code.
Your specifications are automatically saved so you can run it again.
For more details, see the Product Guide.