Unistat Statistics Add-In for Excel

Best-practice statistical data analysis in Microsoft Excel is difficult with existing add-ins and other software tools. Unistat is different, adding the power and accuracy of a full-featured statistical package to your existing analysis and vizualization workflow.

Using UNISTAT as Excel addin is easy. All you need to do is select a block of data and then select a procedure from the UNISTAT menus. UNISTAT's procedure dialogues are intuitive to use and you will not feel as if you are dealing with another program.

By default, UNISTAT will create its output in a new Excel worksheet. You will also have the option to send the same output to Word or HTML for the web.

All numeric results from UNISTAT have up to 15-digit precision, though you can choose to display them with only the desired number of digits. This prevents the build-up of rounding errors when output from one procedure is used as input for another procedure.

Statistical analysis in Excel

• X-Y Plots
• Polar Plot
• Spectral Plot
• Fan Grid Plot
• X-Y-Z Scatter Plot
• X-Y-Z Grid Plot
• X-Y-Z Spin Plot
• Pie Chart
• Bar Chart
• Area Chart
• Ribbon Chart
• 3D Bar Chart
• High-Low-Close Chart
• Plot of Fi(X)
• Plot of F(X,Y)
• Plot & Roots of Polynomials
• Histogram
• 3D Histogram
• Log-probability Histogram
• Normal Probability Plot
• Plot of Distribution Functions
• Box/Whisker and Dot Plots
• Ladder Plot
• X-Y Pairs Plot
• Rectangular Plot
• Icon Plots
• Summary Statistics
• Confidence Intervals
• Quantiles
• Sample Statistics
• Frequency Distributions
• Stem and Leaf Diagram
• Sequence Diagram
• Scatter Diagram
• Cumulative Probability
• Critical Value
• Probabilities and Critical Values
• Expected Frequencies
• One Sample t-Test
• Separate Variance t-Test
• Paired t-Test
• F-Test
• Parametric Tests Matrix
• Hotelling's T² Test
• Pearson Correlation
• Spearman Rank Correlation
• Kendall Rank Correlation
• Point Biserial Correlation
• Tetrachoric Correlation
• Pearson-Spearman-Kendall
• Partial Correlation Matrix
• One Sample Chi-square Test
• Two Sample Chi-square Test
• One Sample K-S Test: Uniform
• One Sample K-S Test: Normal
• Two Sample K-S Test
• Shapiro-Wilk Normality Test
• Unpaired Samples
• Paired Samples
• Single Proportion
• Paired Proportions
• Kruskal-Wallis One-Way ANOVA
• Jonckheere's Trend
• Multisample Median Test
• Friedman Two-Way ANOVA
• Quade Two-Way ANOVA
• Kendall's Concordance Coeff
• Page's L Trend
• Cochran's Q
• Kappa Test Inter-Category
• Kappa Test Inter-Observer
• Contingency Table
• Cross-Tabulation
• Break-Down
• Matrix Statistics
• Linear Regression
• Polynomial Regression
• Stepwise Regression
• Nonlinear Regression
• Logit / Probit / Weibull
• Logistic Regression
• Multinomial Regression
• Poisson Regression
• Analysis of Variance
• General Linear Model
• Table of Means
• Homogeneity of Variance Tests
• Multiple Comparisons
• Regression with Replicates
• Heterogeneity of Regression
• One Sample
• Two Samples
• Variance
• Correlation
• Two Correlations
• Two Proportions
• ANOVA
• Phi Distribution
• Hierarchical Cluster Analysis
• K-th Neighbour Cluster Analysis
• K-Means Cluster Analysis
• Multiple Discriminant Analysis
• Multidimensional Scaling
• Principal Components
• Principal Components Factoring
• Principal Axis Factoring
• Canonical Correlations
• Reliability Analysis
• ARIMA
• Brown's Exponential
• Holt's Linear
• Winter's (Additive)
• Winter's (Multiplicative)
• Dixon-Grubbs-Neumann
• Variable Control Charts
• Attribute Control Charts
• Pareto Chart
• Hotelling's T² Chart
• Weibull Chart
• Life Table
• Kaplan-Meier Analysis
• Survival Comparison Statistics
• Cox Regression
• Fourier Transform
• Inverse Fourier Transform
• Completely Randomised Design
• Randomised Block Design
• Latin Squares Design
• Crossover Design
• Slope Ratio Method
• Quantal Response Method
• Combination of Assays