Discover more about your data with powerful statistical analysis and data visualization.
Analyse-it runs entirely in Microsoft Excel. No data transfer to another application, leaving your data locked in a separate application.
And no learning curve because you never leave the familiar Excel environment. Prepare your data in Excel: type it in, import it from a database, download it live from a manufacturing process, or receive from a colleague it by e-mail. Then Analyse-it!
The only limit is the size of a worksheet – if you call over 1 million rows a limitation!
Statistical analysis is iterative. You start analysis and then discover an observation to exclude, that analysis should focus on a subset where an effect is present, that the latest data from a live process needs to be added, or that a different model should be used. Or simply it’s time to go home and rest your brain.
Whatever the reason, you can pick-up any statistical analysis where you left off. Recalculate an analysis to see how changes in the data, filter, and excluded observations affect the statistics and plots. Or edit an analysis to add or remove statistics and plots.
Statistical analysis is time consuming enough without wasting your time formatting the output for presentation.
Analyse-it saves you the effort. Statistics are presented to a sensible number of decimal places relative to your data. Plots are standard Excel charts, not static images, with important data points highlighted and labelled so you can easily find them. And page breaks are included so plots and tables don’t split across pages. Just click Print.
Save analyses in an Excel workbook just like any other Excel worksheet. Then, anyone with Microsoft Excel can view your analysis. Anyone with Analyse-it can recalculate or change your analysis. And anyone can use your analysis as a template for a future analysis -- unburdening the statistician and helping colleagues easily run common analyses.
If you need a custom report or presentation, simply copy and paste statistics, tables and plots into Word, PowerPoint or any other Windows application.
Analyse-it provides a wide range of statistics and plots for descriptive statistics, exploratory and confirmatory data analysis.
Get concise numerical insight into your data. All the standard statistics are included for central location, dispersion, distribution shape, and association so you can describe data.
Often you need to test a hypothesis, estimate a parameter or effect size, or both.
Estimate and test hypotheses about location, dispersion, association, differences in means and proportions, homogeneity of variances, and more.
Hypotheses and the conclusion of tests test are stated in clear simple language. And p-values are automatically calculated, using exact distributions for small-sample sizes where possible, so you won’t need to dust-off your old reference books. What's more, every estimate includes a confidence intervals computed using the latest methods (not found in most packages!), to express the uncertainty in the estimate.
Uncover simple and complex relationships between variables with model fitting and regression analysis. Fit linear regression, polynomial regression, logarithmic, exponential, power and binary logistic regression models quickly. Or build your own complex multiple regression models from simple, crossed, factorial and polynomial terms.
All backed up with plots and tests that let you verify model assumptions and check the model fit. What's more you can use your newly found knowledge to make future predictions.
See model fitting & regression analysis
See full technical specification
Visualization is essential in any analysis. But the basic charts provided in Microsoft Excel and other add-ins just don’t cut it.
Analyse-it changes that. Visualize the distribution, see patterns, and spot outliers in your data with univariate statistical plots including box-whisker plots, dot plots, mean plots and histograms. See changes with difference plots. And scatter plots and matrices are included so you can identify bivariate relationships.
Statistics is a complex subject. Why make it harder? Analyse-it’s logical task-based workflow and intuitive user interface means you don’t need to be a statistician or programmer to use it.
If your statistics knowledge is a rusty you’ll love the plain-English hypotheses and conclusions, the galleries for quick access to common statistical plots, and the context help that tells you the purpose and assumptions for every command.
Why put up with software still stuck in the 1970’s? As processing power improves you need software that follows.
Analyse-it uses the most accurate algorithms, not simple techniques intended only for hand calculation. It heeds latest advice from statistical publications. And obsolete historic techniques are omitted in favour of the latest best practices, saving you time researching what to use and when.
When you’re using statistical software to make decisions about your business, or decisions that affect the life of patients, you need software you can trust. The statistics have to be correct.
Analyse-it is used by over 25,000 customers, in more than 105 countries around the world. It’s cited in 1,000’s of peer-reviewed articles published in a wide-range of respected journals. And it’s used in all kinds of applications; for making decisions in business & industry, for analysing clinical & medical research, and in teaching and education.
Join the thousands of others that trust and rely on Analyse-it everyday.
Some people say Microsoft Excel isn’t suitable for statistical analysis. The built-in statistical and distribution functions maybe aren’t. That’s why Analyse-it doesn’t use any of them – not even one!
Instead everything is calculated by Analyse-it, using reliable algorithms and IEEE 754 double floating-precision. That’s effectively 15 significant digit precision. Then we test and validate...
All statistics and plots in Analyse-it are validated. The validation tests run automatically after every change and before every release to ensure everything is correct and stays correct.
So far we have more than 1,000 test cases. And those tests run across all supported releases and service packs of Microsoft Excel 2007, 2010, 2013 & 2016. Are other Excel add-ins this well tested?
Read more about our Development and Validation process.
Analyse-it is the leading statistics software for Microsoft Excel.
First released in 1997, Analyse-it surpasses traditional statistical software in ease of use, features and price. Over 25,000 customers now rely on Analyse-it for in-depth statistical analysis and visualization in Excel.