Total Access Statistics runs as an add-in for Access and offers a wide range of statistical functions to analyze your data. 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.<\/p>\n
Features:<\/p>\n
\n
Supports the Access 2007 ACCDB database format and new field types\n
Supports ADP data in tables, views, stored procedures, and user defined functions\n
Calculates Running Totals and Moving Averages\n
Supports parameterized queries <\/li>\n<\/ul>\n
<\/p>\n
Total Access Statistics – Features<\/h2>\n
Total SQL Statistics provides statistical functions for Visual Basic and Visual Studio.NET developers using SQL Server data. Functions are provided for analysing data stored in SQL Server tables, views, stored procedures and user defined functions. Total SQL Statistics comprises two parts: an interactive Statistics Scenario Designer that is a standalone program for specifying which database, data, fields and analysis to perform and a DLL component that performs the analysis. Design analysis scenarios by running the standalone Scenario Designer program and run them from a program with a DLL call into a distributable run-time library. Only the structure of the scenario is saved so that analysis is always performed on the current data. It is licensed on a per developer basis and includes royalty-free re-distribution rights. Versions are available for Microsoft Access 2.0 – 2003.
New Features include:<\/STRONG>
Random, ranking and normalise analysis types
Support for Microsoft Access 2003.<\/LI><\/UL>
Features include:<\/STRONG>
Supports SQL Server 7.0 and 2000: <\/STRONG>the latest SQL Server versions
Interactive Scenario Designer: <\/STRONG>create, test and fine-tune statistical analysis interactively using a Wizard-like application. All scenarios are saved for re-use or modification
Programmatic interface: <\/STRONG>add statistical analysis of SQL Server data to Visual Basic and VB .Net projects. A hidden interface enables Total SQL Statistics to run with control over what the user sees
Accuracy: <\/STRONG>all calculations are in double precision (15 digits accuracy)
Multi-user ready: <\/STRONG>multiple users can run an application that uses Total SQL Statistics simultaneously
Royalty-Free License: <\/STRONG>each license allows a developer to include Total SQL Statistics in applications distributed to an unlimited number of customers
Small DLL: <\/STRONG>a statistics ActiveX DLL under 1 MB in size is added to applications
Data Analysis Features: <\/STRONG>
Analyse SQL Server Data: <\/STRONG>analyse data stored in SQL Server tables, views, stored procedures and user defined functions that return data
Results in SQL Server tables: <\/STRONG>Total SQL Statistics generates many values at once. Each value is stored in a separate record and field in a table making it easy for the developer to view, sort, query or display the results
Analyse Large Data Sets: <\/STRONG>multiple fields and an unlimited number of records can be analysed simultaneously
Group Data: <\/STRONG>(optional) a separate calculation is generated for every unique combination of values in the specified group fields. For instance, grouping on a State field generates separate results for each state that are stored as individual records in the output table
Ignore Values: <\/STRONG>(optional) specify specific values or ranges of values to omit. For instance, 999 is sometimes entered as an unknown value and must be ignored
Weighting Field: <\/STRONG>(optional) specify a weighting field to perform calculations such as weighted averages, weighted standard deviations, weighted regressions etc.<\/UL>
Statistical Functions: <\/STRONG>are grouped into three categories: Parametric, Group and Non-Parametric
Parametric Analysis Options: <\/STRONG>parametric analysis is performed on numeric fields that are assumed to be continuous and normally distributed. Fields are analysed individually or compared with each other
Describe: <\/STRONG>analysis of a numeric field: std. deviation, std. error, variance, coefficient of variance, skewness, kurtosis, geometric mean, harmonic mean, RMS, mode, confidence intervals, t-Test vs. mean, percentiles etc
Frequency: <\/STRONG>for each field, frequency distribution analysis for each interval (range of values): count, sum, percent of total, cumulative count, percent and sum
Percentiles: <\/STRONG>median, quartiles, quintiles, deciles and percentiles. Similar to Describe but results placed in records rather than fields (each percentile is a record)
Compare: <\/STRONG>compare two fields: mean and standard deviation of difference, correlation, covariance, R-square, paired t-Test
Matrix: <\/STRONG>similar to Compare but all fields are compared to each other creating a matrix
Regression: <\/STRONG>simple, multiple and polynomial regressions with coefficient analysis, ANOVA and residual table
Crosstab: <\/STRONG>cross-tabulation with row and column summaries and % of row, column and total for each cell. Chi-Square analysis is also available with expected value and % of expected for each cell. <\/UL>
Group Analysis Options: <\/STRONG>group analysis is the comparison of continuous, normally distributed numeric data between groups of records. A comparison field in the table defines the groups. For instance, compare data between men and women or by race. Groups are usually of different sizes (number of records) unlike the Compare feature in Describe which is for paired values
Two Sample t-Test: <\/STRONG>compares means between two groups of records. Calculations include pooled and separate t-values for the two groups
ANOVA: <\/STRONG>analysis of variance compares the means of multiple groups of records. Calculations include degrees of freedom, sum of squares within and between groups, F-value and probability
Two way ANOVA: <\/STRONG>two-way analysis of variance compares multiple fields between groups of records providing the same results a ANOVA with additional values for each additional field. Used to measure relative impact of each variable on the mean.<\/UL>
Non-Parametric Options: <\/STRONG>less powerful than parametric analysis, non-parametric analysis is used when the underlying data is not continuous for instance ordinal data or not normally distributed. Non-parametric analysis makes no assumption on the distribution of the underlying data since the results are based on the ranks of the data. Non-parametric analysis can be made for each numeric field individually, compared with each other or between groups of records (samples)
Chi-Square: <\/STRONG>one sample Chi-Square. Evaluates distribution and expected value for each unique value in a field
Sign Test: <\/STRONG>one sample sign test versus median, mean or user defined value
K-S Fit: <\/STRONG>Goodness of Fit tests to determine if a numeric field fits a uniform, normal or Poisson distribution
2 Sample: <\/STRONG>two sample tests: Wald-Wolfowitz Runs Test, Mann-Whitney U Test and Kolmogorov-Smirnov
N Fields: <\/STRONG>Friedmans two way ANOVA.<\/UL>
Probability Calculator: <\/STRONG>evaluate the probability of test values (Z, t-Test, Chi-Square and F-value) for any degrees of freedom or the inverse (test value for a given probability). <\/UL><\/p>\n
Total Access Statistics – System Requirements<\/h2>\n
Microsoft Windows XP, 2000, 98, ME or NT 4.0 with SP6 or higher
Pentium II processor or better
128 MB RAM (64 MB minimum)
10 MB of available hard disk space
Microsoft Visual Basic 5.0, 6.0 or Visual Studio .NET.
Microsoft Data Access Components (MDAC), version 2.5 or higher.<\/LI><\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"
Total Access Statistics runs as an add-in for Access and offers a wide range of statistical functions to analyze your data.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. Features: Supports the […]<\/p>\n","protected":false},"featured_media":73143,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","inline_featured_image":false},"product_brand":[10322],"product_cat":[9309,9032,2013],"product_tag":[],"class_list":{"0":"post-73140","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_brand-fms","7":"product_cat-uncategorised","8":"product_cat-components","9":"product_cat-developer-tools","11":"first","12":"outofstock","13":"shipping-taxable","14":"purchasable","15":"product-type-simple"},"acf":[],"yoast_head":"\n
Total Access Statistics - QBS Software - French<\/title>\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n