The Most Powerful Data Analysis Program for Microsoft Access

• Count and Missing (null values)
• Minimum, Maximum, Range, Sum, Sum of Squares, Mean
• Variance, Coefficient of Variance, Standard Deviation, Standard 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

Use discounted cash flows and interest rates to generate for periodic and irregular (date dependent) payments and receipts:

• Net Present Value (NPV)
• Present Value (PV)
• Future Value (FV)
• Internal Rate of Return (IRR)
• Modified Internal Rate of Return (MIRR)

Eliminate the need to use Microsoft Excel for these calculations.

• Median
• Quartiles
• Quintiles
• Octiles
• Deciles
• 5th percentile
• Percentile
• 0.5 Percentile.

Results generated in a separate table or by updating a field in your table

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

• Count and/or Percent of Occurrences
• Count or Cumulative
• Number of intervals
• Interval width and Initial Value

• Calculate Rank Values in a New Table
• Update Rank Values in a Field in the Data Table
• Assign ties to the Average, Consecutive or Cumulative Rank

• Random Record Selection
• Data Normalization (transposing records)

Calculate fitness to a line or curve. Generate the equation coefficients and residual for each data point.

• Simple, Multiple, and Polynomial Regressions
• With or without Y-Intercept
• Calculation of coefficients, R-Square, Standard Error, and ANOVA
• Residual table

Calculated cumulative or moving totals for:

• Average
• Sum
• Count
• Median
• Minimum
• Maximum
• Range, etc.

• Crosstabs with more value calculation options
• Chi-Square with Expected Values
• Percent of row, column, and total displayed as records or columns
• Analyzes multiple value fields in one pass

Generate probability of test values:

• Z-value
• t-Value based on degrees of freedom
• Chi-Square
• F-Value with two degrees of freedom

Calculate inverse probability

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

• One Sample Chi-Square
• One Sample Sign Test for Median, Mean, and Custom Value
• Kolmogorov-Smirnov Goodness of Fit Test (Uniform, Normal, Poisson)
• 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