Analyse-it Standard Edition Add statistical analysis to Excel.

The powerful statistical analysis and regression you’d expect from an expensive statistics package. Without the complexity or the cost.

Analyse-it Standard Edition lets you describe and visualize data, discover the relationships between variables, and get answers to your questions. So you can make informed, intelligent decisions.

With Analyse-it Standard Edition, you can:

  • Describe your data with a wide range of statistics.
  • Visualize distributions, see trends and patterns, and spot outliers with powerful charts from histograms to scatter plots.
  • Infer and test hypotheses to get answers on distribution parameters, differences between populations, association between variables, and much more.
  • Discover relationships between variables and identify important factors with powerful regression and model fitting techniques.
  • Get insight into highly complex data by reducing dimensionality to get a clearer picture of the underlying structure.
  • Analyse-it has helped tremendously. Previously I used Prism and Microsoft Excel, but Analyse-it has made my life so much easier and saved so much time.
    Man Khun Chan, M.Sc., ART
    Test Development Medical Technologist
    The Hospital For Sick Children, Toronto, Canada
  • I purchased Analyse-it and I love it. Thank you so much for the superb and easy to use program. Technical support is the best I have ever seen.
    Addy Alsumidaie, MD, Ph.D.
    Director, Clinical Development
    Johnson and Johnson
  • We have incorporated Analyse-it into our real-time daily QA analysis, making us both more efficient and proactive in addressing QA issues. Analyse-it has saved us time and provides the statistics and professional reports we need.
    Dalton Seegert
    Medical Technologist QA/Ancillary Testing
    Veterans Administration
  • Using Analyse-it we have improved several of our quality control testing steps, better controlled our decision making and are still undergoing process improvements.
    Laura Smith
    Production manager
    The Binding Site
  • Although we only scratch the surface of Analyse-it’s capabilities, we have a very high volume of use for the statistics we need. It’s saved us time and the reports look professional.
    Michael Savage
    Chemistry Supervisor
    Baptist Hospital East

What Analyse-it is? Read more...

What is Analyse-it?

Analyse-it brings powerful statistical analysis and data visualisation into Microsoft Excel. All the statistical analysis you need, in an application you already know. There's no locked-in file format. No need to transfer data from one system to another. And no learning curve. Just the tools Excel is missing. The ones that make powerful analysis easier.

Capable. Not complicated.

There's no avoiding it - statistics is complicated. But that doesn't mean you should have to struggle with an unwieldy, hard to use application.

Analyse-it makes things easier, with:

  • An intuitive user interface, built on the familiar foundation of Microsoft Excel
  • A logical task-based workflow that makes sense to those of us that aren't programmers or full-time statisticians
  • Plain English documentation that's easy to understand even if your knowledge is a bit rusty
  • High quality reports and charts so you can present your findings straight away

And at the same time, Analyse-it is capable of complex analysis built on the very latest best practices and using accurate algorithms – not simple techniques intended for hand calculation.

So you can spend your brainpower where it counts - on your analysis and your findings.

Statistical analysis. Accurate and reliable.

Microsoft Excel isn't up to the job of statistical analysis. Its built-in functions just aren't built for accuracy. So we don't use a single one.

Instead, Analyse-it handles all of your calculations internally. Using reliable algorithms and IEEE 754 double floating point precision. And the results to prove it? See Analyse-it's performance against the NIST-StRD.

Validation. At every stage.

We've conducted thousands of tests to put Analyse-it through its paces. They cover all releases and service packs of Microsoft Excel 2007, 2010, and 2013.

What's more, validation tests are run automatically after every change to the software. So you can be confident your work is correct. And stays correct. See our development & validation process.

Dependable support.

No need to resort to old textbooks. Analyse-it includes detailed help that’s written in plain English. And we’re here for extra help, aiming to answer your queries within 24 hours.

See for yourself.

Take a look at these real-world examples produced using Analyse-it. Available as Adobe PDF (.PDF) and Excel workbooks (.XLSX).

Technical specification

Descriptive statistics
  • Mean, Variance, SD, Skewness, Kurtosis
  • Median, Minimum, Maximum, Range, IQR
  • Quantiles
  • Frequency table
  • Contingency table
  • Correlation coefficient
Modeling & regression Linear Fits
  • Simple linear regression
  • Polynomial regression (2nd to 6th order)
  • Logarithmic regression
  • Exponential regression
  • Power regression
  • Multiple linear regression
  • Advanced models with simple, crossed, polynomial and factorial terms, with categorical explanatory variables coded as dummy variables
Other Fits
  • Binary logistic regression
  • Leverage plot
  • Residual plot
  • Outlier and Influence plot
  • Standardized and Studentzied residuals
  • Cook's D
  • Test effect of each term
  • Test effect of model
  • Predict Y for X
  • Lack of fit test for simple regression models
  • Save model variables back to the dataset: Fitted Y, Residuals, Standardized Residuals, Studentized Residuals, Leverage, Cook's Influence.
Multivariate Correlation / Association
  • Pearson r
  • Fisher Z confidence interval for Pearson r
  • Pearson test
  • Spearman rs
  • Kendall tau
  • Samara-Randles confidence interval for Kendall tau
  • Kendall test
PCA
  • Classic Gabriel bi-plot
  • Gower-Hand bi-plot
  • Correlation mono-plot
  • Scree plot
  • Eigenvalues / Eigenvectors
Common Factor Analysis
  • Maximum likelihood factor extraction
  • Factor pattern / structure matrices
  • 12 factor rotations including Varimax, Oblimin
Hypothesis tests Location
  • Z-test (one, two, paired)
  • Student t-test (one, two, paired)
  • Welch t-test
  • Wilcoxon
  • Wilcoxon-Mann-Whitney
  • Sign
  • ANOVA
  • Repeated measured ANOVA
  • Welch ANOVA
  • Kruskal-Wallis
  • Friedman
Dispersion / Homogeneity of variance
  • X2
  • Fisher F-test
  • Bartlett
  • Levene
  • Brown-Forsythe
Normality
  • Shapiro-Wilk
  • Anderson-Darling
  • Kolmogorov-Smirnov
Proportions
  • Binomial exact
  • McNemar-Mosteller exact
  • Fisher exact
  • Pearson X2
  • Score Z
  • Likelihood ratio G2
Estimators Location
  • Mean
  • Median
  • Hodges-Lehmann pseudo-median
  • t-based confidence interval for mean
  • Z-based confidence interval for mean
  • Thompson-Savur confidence interval for median
  • Tukey confidence interval for Hodges-Lehmann pseudo-median
  • Mean difference
  • t-based confidence interval for mean difference
  • Z-based confidence interval for mean difference
  • Welch-Satterthwaite t-based confidence interval for mean difference
  • Hodges-Lehmann location shift
  • Tukey confidence interval for Hodges-Lehmann location shift
  • Multiple comparisons: Tukey-Kramer, Dunnett, Hsu (with best), Scheffe (all contrasts), Steel (non-parametric against control), Dwass-Steel-Critchlow-Fligner (non-parametric all pairs), Wilcoxon (individual comparisons)
Dispersion
  • Variance
  • X2-based confidence interval for variance
  • Variance ratio
  • F-based confidence interval for variance ratio
Proportions
  • Proportion
  • Odds
  • Clopper-Pearson exact confidence interval for proportion
  • Wilson score confidence interval for proportion
  • Proportion difference (risk difference)
  • Proportion ratio (risk ratio)
  • Odds ratio
  • Miettinen-Nurminen score confidence interval for proportion difference / proportion ratio / odds-ratio
  • Newcombe score confidence interval for proportion difference
  • Conditional exact confidence interval for odds ratio
Plots
  • Histogram
  • Dot plot
  • Box plot
  • Mean error bar plot
  • CDF plot
  • Normal Q-Q plot
  • Scatter plot
  • Scatter plot matrix
  • Difference plot
  • Mean-Mean scatter plot for visualizing multiple comparisons.
  • Frequency plot
  • Pie frequency plot
  • Mosaic plot
  • Grouped frequency plot
  • Stacked frequency plot

System requirements

  • Microsoft Excel 2007, 2010, 2013 & 2016 (32- and 64-bit)
  • Microsoft Windows XP, Vista, 7, 8, 10, Server 2003, 2008, 2012, & 2016
  • 2GB RAM minimum recommended
  • 35MB disk space