UNISTAT - the ultimate Excel statistics add-in

UNISTAT® Product Comparison Table

FEATURESLight
Edition
Standard
Edition
Standard
Edition +
Bioassays
Module
  Data Capacity50 x 1500* unlimited* unlimited
  Modes of Running UNISTATyesyesyes
    Stand-Alone Modeyesyesyes
    Excel Add-In Modeyesyesyes
    Background Modeyesyesyes
  Variable Optionsyesyesyes
    Categorical Data Analysisyesyesyes
    Multiple Dependent Variablesyesyesyes
    Creating Interaction Dummy and Lag/Lead Variablesyesyesyes
  Output Mediumyesyesyes
    UNISTAT Output Windowyesyesyes
    Output to Wordyesyesyes
    Output to Excelyesyesyes
    Output to Web Browseryesyesyes
    Macrosyesyes
      Recording Macrosyesyes
      Running Macrosyesyes
      Combining Macrosyesyes
      Macro Shortcut Buttonsyesyes
    Log Fileyesyes
    Helpyesyesyes
DATA PROCESSOR
  Spreadsheet Functionsyesyesyes
    Informationyesyesyes
    Transpose Matrixyesyesyes
    Column Sortyesyesyes
    Key Sortyesyesyes
    Matrix Sortyesyesyes
    Recode Columnyesyesyes
    Aggregateyesyesyes
    Range Statisticsyesyesyes
    Stack Columnsyesyesyes
    Unstack Columnsyesyesyes
    Format Columnsyesyesyes
    Select Rowyesyesyes
  Formulayesyesyes
    Mathematical Operators and Functionsyesyesyes
    Trigonometric Functions 1yesyesyes
    Trigonometric Functions 2yesyesyes
    Scalar Functionsyesyesyes
    Statistical Functionsyesyesyes
    Special Functionsyesyesyes
    Data Conversion Functionsyesyesyes
    Date and Time Functionsyesyesyes
    UNISTAT Functionsyesyesyes
    Conditional Functionsyesyesyes
    Constantsyesyesyes
DATA AND FUNCTION PLOTS
  2D Plotsyesyesyes
    X-Y Plotsyesyesyes
      Data Seriesyesyesyes
      Lineyesyesyes
      Symbolsyesyesyes
      Error Barsyesyesyes
      Point Labelsyesyesyes
      Right Y-Axesyesyesyes
      Area Enclosedyesyesyes
      Curve Fittingyesyesyes
      Means Plotyesyesyes
    Polar Plotyesyesyes
    Spectral Diagramyesyesyes
    Fan Grid Plotyesyesyes
  3D Plotsyesyesyes
    X-Y-Z Scatter Plotyesyesyes
      Viewpointyesyesyes
      Contoursyesyesyes
      X-Y-Z Pointsyesyesyes
      Planesyesyesyes
      Surface Fittingyesyesyes
    X-Y-Z Grid Plotyesyesyes
    Spin Plotyesyesyes
  Chartsyesyesyes
    Pie Chartyesyesyes
    Bar Chartyesyesyes
    Area Chartyesyesyes
    Ribbon Chartyesyesyes
    3D Bar Chartyesyesyes
    High-Low-Close Chartyesyesyes
  Plot of Functionsyesyesyes
    Plot of 2D Functionsyesyesyes
    Plot of 3D Functionsyesyesyes
    Plot and Roots of Polynomialsyesyesyes
DESCRIPTIVE STATISTICS AND DISTRIBUTIONS
  Descriptive Statisticsyesyesyes
    Summary Statisticsyesyesyes
    Confidence Intervalsyesyesyes
    Quantiles (Percentiles)yesyesyes
    Sample Statisticsyesyesyes
    Frequency Distributionsyesyesyes
    Stem and Leaf Plotyesyesyes
    Sequence Diagramyesyesyes
    Scatter Diagramyesyesyes
  Distribution Functionsyesyesyes
    Cumulative Probabilityyesyesyes
    Critical Valueyesyesyes
    Probabilities and Critical Valuesyesyesyes
    Random Numbersyesyesyes
    Expected Frequenciesyesyesyes
  Descriptive Plotsyesyesyes
    Histogramyesyesyes
    3D Histogramyesyesyes
    Log-Probability Histogramyesyesyes
    Normal Probability Plotyesyesyes
    Plot of Distribution Functionsyesyesyes
    Box and Whisker and Dot Plotsyesyesyes
      Box and Whisker Plotyesyesyes
      Dot Plotyesyesyes
      Error Bar Plotyesyesyes
    Ladder Plotyesyesyes
STATISTICAL TESTS CORRELATIONS AND TABLES
  Parametric Testsyesyesyes
    t- and F-Testsyesyesyes
      One Sample t-Testyesyesyes
      Pooled Variance t-Testyesyesyes
      Separate Variance t-Testyesyesyes
      Paired t-Testyesyesyes
      F-Testyesyesyes
      Levene's F-Testyesyesyes
    Equivalence Test for Meansyesyesyes
    Parametric Tests Matrixyesyesyes
    Hotelling's T-Squared Testyesyesyes
  Correlationsyesyesyes
    Correlation Coefficientsyesyesyes
      Pearson Product Moment Correlationyesyesyes
      Spearman's Rank Correlationyesyesyes
      Kendall's Rank Correlationyesyesyes
      Point Biserial Correlationyesyesyes
    Pearson-Spearman-Kendall Correlations Matrixyesyesyes
    Partial Correlation Matrixyesyesyes
    Intraclass Correlation Coefficientsyesyesyes
  Goodness of Fit Testsyesyesyes
    Chi-Square Testsyesyesyes
      One Sample Chi-Square Testyesyesyes
      Two Sample Chi-Square Testyesyesyes
    Kolmogorov-Smirnov Testsyesyesyes
      One Sample Kolmogorov-Smirnov Test: Uniform Distributionyesyesyes
      One Sample Kolmogorov-Smirnov Test: Normal Distributionyesyesyes
      Two Sample Kolmogorov-Smirnov Testyesyesyes
    Normality Testsyesyesyes
      Shapiro-Wilk Testyesyesyes
      Kolmogorov-Smirnov Testyesyesyes
      Cramer-von Mises Testyesyesyes
      Anderson-Darling Testyesyesyes
  Nonparametric Tests with One or Two Samplesyesyesyes
    Unpaired Samplesyesyesyes
      Mann-Whitney U Testyesyesyes
      Hodges-Lehmann Estimator (Unpaired)yesyesyes
      Wald-Wolfowitz Runs Testyesyesyes
      Moses Extreme Reaction Testyesyesyes
      Two Sample Median Testyesyesyes
    Paired Samplesyesyesyes
      Wilcoxon Signed Rank Testyesyesyes
      Hodges-Lehmann Estimator (Paired)yesyesyes
      Sign Testyesyesyes
      Table of Ranksyesyesyes
    Binomial Proportionyesyesyes
      Runs Testyesyesyes
      Binomial Testyesyesyes
      Noninferiority Testyesyesyes
      Superiority Testyesyesyes
      Equivalence Test for Binomial Proportionyesyesyes
    Unpaired Proportionsyesyesyes
      Difference Between Unpaired Proportionsyesyesyes
      Risk Ratioyesyesyes
      Odds Ratio and Relative Risksyesyesyes
    Paired Proportionsyesyesyes
      Difference Between Paired Proportionsyesyesyes
      Fisher's Exact Testyesyesyes
      McNemar Testyesyesyes
      Odds Ratio (Paired)yesyesyes
      Tetrachoric Correlationyesyesyes
  Multisample Nonparametric Testsyesyesyes
    Kruskal-Wallis One-Way ANOVAyesyesyes
      Kruskal-Wallis ANOVA Test Resultsyesyesyes
      Kruskal-Wallis ANOVA Multiple Comparisonsyesyesyes
    Jonckheere's Trendyesyesyes
    Multisample Median Testyesyesyes
      Multisample Median Test Resultsyesyesyes
      Median Multiple Comparisonsyesyesyes
    Friedman Two-Way ANOVAyesyesyes
      Friedman ANOVA Test Resultsyesyesyes
      Friedman ANOVA Multiple Comparisonsyesyesyes
    Quade Two-Way ANOVAyesyesyes
      Quade ANOVA Test Resultsyesyesyes
      Quade ANOVA Multiple Comparisonsyesyesyes
    Kendall's Concordance Coefficientyesyesyes
    Page's L Trendyesyesyes
    Cochran's Qyesyesyes
    Kappa Test for Inter-Category Variationyesyesyes
    Kappa Test for Inter-Observer Variationyesyesyes
  Tablesyesyesyes
    Contingency Tableyesyesyes
    Cross-Tabulationyesyesyes
      Scoresyesyesyes
      Tablesyesyesyes
      R x C Table Statisticsyesyesyes
      Chi-square Testsyesyesyes
      Fisher's Exact Testyesyesyes
      Measures of Associationyesyesyes
      Cochran-Armitage Trend Testyesyesyes
      Cohen's Kappayesyesyes
      2 x 2 Table Statisticsyesyesyes
      Stratified Analysisyesyesyes
      Conditional Independenceyesyesyes
      Common Odds Ratio and Relative Risksyesyesyes
      Homogeneity of Odds Ratioyesyesyes
    Break-Downyesyesyes
  Sample Size and Power Estimationyesyesyes
    One Sampleyesyesyes
      Sample Size in Estimating the Population Meanyesyesyes
      Sample Size in Tests Concerning the Meanyesyesyes
      Minimum Detectable Difference for One Sampleyesyesyes
      Power of the Test for One Sampleyesyesyes
    Two Samplesyesyesyes
      Sample Size in Estimating Two Population Meansyesyesyes
      Sample Size in Tests Concerning Two Meansyesyesyes
      Minimum Detectable Difference for Two Samplesyesyesyes
      Power of the Test for Two Samplesyesyesyes
    Varianceyesyesyes
      Sample Size for Varianceyesyesyes
      Power of the Test for Varianceyesyesyes
    Correlationyesyesyes
      Sample Size for Correlationyesyesyes
      Power of the Test for Correlationyesyesyes
    Two Correlationsyesyesyes
      Sample Size for Two Correlationsyesyesyes
      Power of the Test for Two Correlationsyesyesyes
    Two Proportionsyesyesyes
      Sample Size for Two Proportionsyesyesyes
      Power of the Test for Two Proportionsyesyesyes
    ANOVAyesyesyes
      Sample Size for ANOVAyesyesyes
      Maximum Number of Groups for ANOVAyesyesyes
      Minimum Detectable Difference for ANOVAyesyesyes
      Power of the Test for ANOVAyesyesyes
    Phi Distributionyesyesyes
      Inverse Phi Distributionyesyesyes
REGRESSION AND ANALYSIS OF VARIANCE
  Matrix Statisticsyesyesyes
  Regression Analysisyesyesyes
    Linear Regressionyesyesyes
    Polynomial Regressionyesyesyes
    Stepwise Regressionyesyesyes
    Nonlinear Regressionyesyes
    Logit / Probit / Gompityesyes
    Logistic Regressionyesyes
    Multinomial Regressionyesyes
    Poisson Regressionyesyes
    Box-Cox Regressionyesyes
  Analysis of Variance and General Linear Modelyesyesyes
    Analysis of Varianceyesyesyes
    General Linear Modelyesyesyes
      Randomised Block Designsyesyesyes
      Repeated Measures Designsyesyesyes
      Repeated Measures over all Factorsyesyesyes
      Repeated Measures over some Factorsyesyesyes
      Latin Squares Designsyesyesyes
      Graeco Latin Squares Designsyesyesyes
      Split-Plot Designsyesyesyes
      Nested Designsyesyesyes
      Crossover Designsyesyesyes
  Tests for ANOVAyesyesyes
    Table of Meansyesyesyes
    Homogeneity of Variance Testsyesyesyes
    Multiple Comparisonsyesyesyes
      Student-Newman-Keulsyesyesyes
      Tukey-HSDyesyesyes
      Tukey-Byesyesyes
      Duncanyesyesyes
      Scheffeyesyesyes
      Least Significant Difference (LSD)yesyesyes
      Bonferroni (Modified LSD)yesyesyes
      Dunnettyesyesyes
    Regression with Replicatesyesyesyes
    Heterogeneity of Regressionyesyesyes
MULTIVARIATE ANALYSIS
  Cluster Analysisyesyes
    Hierarchical Cluster Analysesyesyes
      Distance Measuresyesyes
      Distance Matrixyesyes
      Hierarchical Methodsyesyes
    K-th Neighbour Cluster Analysisyesyes
    K-Means Cluster Analysisyesyes
  Discriminant Analysisyesyes
    Multiple Discriminant Analysisyesyes
      Stepwise Discriminant Analysisyesyes
      Linear Discriminant Analysisyesyes
      Canonical Discriminant Analysisyesyes
    K-th Neighbour Discriminant Analysisyesyes
  Multidimensional Scalingyesyes
    Classical Multidimensional Scalingyesyes
    Ordinal Multidimensional Scalingyesyes
  Principal Components Analysisyesyes
  Factor Analysisyesyes
    Factoring Methodsyesyes
    Rotationsyesyes
  Canonical Correlationsyesyes
  Reliability Analysisyesyes
  Multivariate Plotsyesyes
    X-Y Matrix Plotyesyes
    X-Y Rectangular Plotyesyes
    Icon Plotsyesyes
TIME SERIES ANALYSIS
  Box-Jenkins ARIMAyesyes
    Differencing Input Optionsyesyes
    Differencing Output Optionsyesyes
    Model Fittingyesyes
      Seasonal and Nonseasonal Operatorsyesyes
      Model Fitting Parametersyesyes
    Model Output Optionsyesyes
    Forecastingyesyes
  Forecasting and Smoothingyesyes
    Exponential Weights Moving Averageyesyes
    Brown's Exponentialyesyes
    Holt's Linearyesyes
    Winter's Additive Seasonalyesyes
    Winter's Multiplicative Seasonalyesyes
    Dixon-Grubbs-Neumannyesyes
  Quality Controlyesyes
      Operating Characteristic Curveyesyes
    Variable Control Chartsyesyes
      R Chartyesyes
      S Chartyesyes
      Variance Chartyesyes
      X Bar Chartyesyes
      Moving Average Chartsyesyes
      Standard Moving Average Chartsyesyes
      Exponential Weights Moving Average Chartyesyes
      CUSUM Chartyesyes
      Table of Valuesyesyes
      X Chart (Levey-Jennings)yesyes
    Attribute Control Chartsyesyes
      C Chartyesyes
      U Chartyesyes
      Np Chartyesyes
      P Chartyesyes
    Pareto Chartyesyes
    Hotelling's T-Squared Analysisyesyes
    Weibull Analysisyesyes
      Two-Parameter Maximum Likelihood Estimationyesyes
      Two-Parameter OLS Estimationyesyes
      Three-Parameter OLS Estimationyesyes
    Process Capability Analysisyesyes
      Performanceyesyes
      Capability Indices with Overall Standard Deviationyesyes
      Capability Indices with Pooled Standard Deviationyesyes
      Nonparametric Capability Indicesyesyes
      Capability Histogramyesyes
    Data Transformationyesyes
      Johnson Transformationyesyes
      Box-Cox Transformationyesyes
    Gauge / Gage R&R Analysisyesyes
      Gage R&R Average and Range Methodyesyes
      Gage R&R ANOVA Methodyesyes
      Gage R&R Chartsyesyes
  Survival Analysisyesyes
    Survival Analysis Variable Selectionyesyes
    Life Tableyesyes
    Kaplan-Meier Analysisyesyes
      Product Limit Survival Tableyesyes
      Quantiles of Survival Functionyesyes
      Kaplan-Meier Plotsyesyes
    Survival Comparison Statisticsyesyes
      Wilcoxon Tests: Gehan (Lee Desu) Breslowyesyes
      Logrank Test: Mantel-Haenszel (Peto)yesyes
    Cox Regressionyesyes
  Fourier Analysisyesyes
    Fourier Transformyesyes
    Inverse Fourier Transformyesyes
ANALYSIS OF BIOASSAYS
  Parallel Line Methodyes
    Normality Tests for Bioassaysyes
    Homogeneity of Variance Testsyes
    Response Totals and Contrastsyes
    Validity of Assayyes
      Completely Randomised Designyes
      Randomised Block Designyes
      Latin Squares Designyes
      Twin Crossover Designyes
      Triple Crossover Designyes
    Regressionyes
    Comparison of Slopesyes
    Potencyyes
    Plot of Treatment Meansyes
  Slope Ratio Methodyes
    Normality Testsyes
    Homogeneity of Variance Testsyes
    Validity of Assayyes
    Regressionyes
    Potencyyes
    Plot of Treatmentsyes
  Quantal Response Methodyes
    Regressionyes
      Logityes
      Probityes
      Gompityes
    Validity of Assayyes
    Effective Dose (or Lethal Dose)yes
    Potencyyes
    Plot of Treatmentsyes
  Combination of Assaysyes
    Homogeneity Testsyes
    Combined Potencyyes

* unlimited: limited only by available system memory. Modern computers can generally handle very large datasets with ease.