Building on the industry-standard spreadsheet, Analyse-it integrates into Microsoft
Excel to provide you with a wide-range of statistics and charts for visualising,
describing and testing hypotheses.
Work within the familiar Excel environment
Why learn how to use a complex statistics package? Analyse-it integrates into Excel
’97 to 2007 and provides a toolbar of dataset management and statistical tests so
you can analyse data directly from your worksheet. Staying in
the familiar Excel environment means there is virtually no learning curve!.
You don't have to export your data to another package and you won't end up with
your data locked into an in-accessible, proprietary, file format.
Analyse-it integrates into Excel, providing a wide-range of statistics and charts
for you to explore your data and test hypotheses -- all without leaving Excel.
Explore, visualise and test sample distribution
Analyse-it provides extensive descriptive statistics and insightful charts for exploring
samples. Statistics include the mean, median & standard deviation, all with
confidence intervals, plus many non-parametric measures such as quartiles &
percentiles.
box-whisker plots, mean-plots, percentile and standard deviation plots let you see
how observations are distributed and spot outliers. A frequency histogram, with
optional normal curve overlay, provides an alternative view of the sample distribution
. Histogram bins can be determined automatically by Analyse-it or you can enter
your preferred bins.
Tests and charts include:
- 1-sample z-test
- 1-sample t-test
- Binomial test
- Runs test

Analyse-it provides many charts for exploring and visualising your data. Frequency
histogram and dot- and box-whisker plot, with notch indicating median confidence
interval, are shown.
Verify pre-test assumptions of normality
Tests and charts are included for verifying a sample is normally distributed --
a necessary step when using parametric statistics. Hypothesis tests are included
so you can formally test normality, or you can use the normal quantile plot and
frequency histogram (with normal overlay) to make a visual assessment.
Tests and charts include:
Find changes & differences between groups and samples
Parametric procedures including the t-test and ANOVA, with post-hoc comparisons,
are provided so you can test whether groups/samples change due to a factor or over
time. For non-normal and categorical data non-parametric procedures are provided,
including Mann-Whitney, Kruskal-Wallis, Fisher exact, and Chi-Square.
Side-by-side dot-plots, box-whisker plots, & mean-plots, let you visually compare
samples. Interaction plots, with connected means, let you easily see whether samples
or groups differ or change.
Tests and charts include:
Analyse-it interaction plot connecting means of four samples to show the change
over time. Error bars of the mean +/- 2 SDs (standard deviations) are also shown
to see the variation.
Identify trends and relationships to make predictions
For bivariate data, Analyse-it lets you explore potential trends with Pearson, Spearman,
and Kendall correlation, and compare categorical ratings with Chi-square & Kappa.
Where definite trends exist, the variables predicting the response can be identified
with multiple linear regression and polynomial regression. Goodness of fit statistics
and residual plots tell you how well the chosen variables predict the response.
The equation to predict future observations is also shown.
Analyse-it linear regression coefficients table and scatter plot showing the linear
fit, confidence bands for the fit, and prediction bands.
Publication-quality print-ready reports
Analyse-it's perfectly formatted reports mean you can print the
analysis immediately, without wasting time tidying them up for presentation.
You can also copy-paste charts and statistics directly into your own documents and
presentations. Chart look is based on the most popular formats used in published
research, so charts are immediately ready for inclusion into research papers.
Save, exchange and update your analyses
Once analysed, your Analyse-it analyses can be saved in a standard Excel workbook,
published to your intranet, or e-mailed to colleagues. Colleagues with Excel can
open and print workbooks containing Analyse-it analyses, without needing Analyse-it.
At any time you, or colleagues with Analyse-it, can update the analysis reports,
repeating the analysis to reflect changes or additions to the source data.
A proven reliable product
We've sold and developed Analyse-it for over 11 years
now, and it's used by over 15,000 customers world-wide
(see selected customer list). It's widely
respected by researchers and cited in well over 1,500 published
peer-reviewed papers in internationally recognised journals. As a company
we've developed statistical software for over 16 years, developed custom statistical
software for two of the world's largest pharmaceutical companies and have worked
in the software industry for over 25years (read more
about us).
Some statistical software providers might try convince you Excel is unsuitable for
rigorous statistical analysis. With Analyse-it those fears are unfounded. Analyse-it
doesn't use any of the built-in Excel functions. Instead all Analyse-it's statistical
tests are written in C++ for lightening fast calculation, then
rigorously tested to ensure they are accurate. In
our testing Analyse-it is at least as accurate, and often more accurate, than published
results from the most well-known statistical packages (testing was against the respected
NIST StRD (National Institute of Standards
and Technology, Statistical Reference Datasets datasets).
Full support and help along the way
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
When you buy Analyse-it, you're not on your own. All major upgrades to Analyse-it,
released within 12 months of your purchase, are available to you free of charge.
Bug fixes and minor updates are always available free of charge, for the lifetime
of the product.
If you need help or advice on using Analyse-it, the full help and tutorials included
with Analyse-it provide easy-to-understand, plain English instructions
to guide you through using Analyse-it. Help on choosing a suitable statistical test,
then using, interpreting, and understanding the statistics is included. Of course
should you get stuck, our widely-praised customer support are
ready to help, with most queries are answered within a few, and almost
all within 24, hours.