17 years helping Israeli businesses
choose better software
Analyse-it
What Is Analyse-it?
Analyse-it integrates into Microsoft Excel to provide the powerful statistical analysis you'd expect from an expensive statistics package - but without the complexity or cost. Four editions meet different customer needs, from traditional statistical research including hypothesis testing, model fitting, ANOVA, & PCA, to statistical process control (SPC) and quality improvement, to analytical and diagnostic method validation for laboratories to meet regulatory compliance.
Who Uses Analyse-it?
Aimed at researchers in clinical, medical, manufacturing, and engineering fields.
Not sure about Analyse-it?
Compare with a popular alternative
Analyse-it
Reviews of Analyse-it
Analyse-it
Comments:
I do research in imaging/neuroradiology field and I use Analyse-it for my statistical analysis used for meetings presentation and publication.
I like the integration with Excel and it's user-friendly approach to statistical analysis methods, particularly to ROC curve analysis that I use often in my research.
Pros:
ROC Curve Analysis made easy with Analyse-it
Cons:
I hope to be able to do cluster analysis with Analyse-it in the future
Best Excel based stats program. Easy to use, powerful, and accurate. Have used it for 15 years.
Comments: It makes my routine stats analyses a breeze. My analyses are available immediately without waiting for other departments. It is powerful enough so I can "play with the data", which helps me to truly understand the results.
Pros:
Over the years I have tried several statistics programs, some Excel based, some not. But I always came back to Analyse-It, which is powerful enough for my purposes (level of knowledge) but the easiest to use. Analyse-It integrates seamlessly with Excel, so I don't have to learn a new software. Data are prepared and organized in Excel the way I am used to without having to learn a new program. Unwieldy data sets can be calculated and organized using standard Excel tools such as links, formulas, and Pivot Tables. Once properly organized, column headings become variables, and analysis becomes a "click of the button". Subgroup analyses are as simple as the column filter settings in Excel. Analyse-It automatically loads upon startup of Excel adding a new menu entry to the ribbon. The software offers a wide selection of statistical analyses, from Descriptives to T-Tests, ANOVA, Non-Parametric tests, Regression Analysis, etc.. Outputs often include standard graphs, such as X-Y charts or line-charts with optional "jitter" (dots representing individual data points) or confidence bands; Box-And-Whisker Plots maybe my favorites. Numeric outputs include all the standard items such as mean, median, stand. dev., stand. error, etc. etc. etc. Working with professional statisticians running SAS I have NEVER found a discrepancy between results.
Cons:
Outputs are created on a new tab. Customizing the output as, for example, formatting graph axes or relabeling titles are lost upon recalculation. The same goes for custom graphs based on the tabular output. Also, while the latest version now lists the filters applied to the data set on the output tab, it does not re-apply the filters on recalculation. That can be a problem when several analyses are based on the same data set and new data is added.
review
Pros:
great add-on, good and friendly UI, powerful and accurate
Cons:
price/functionality ratio, bit pricy for small companies
Simple and functional application that maximizes the statistical analysis I need.
Pros:
It allows me to have a large amount of tests and statistical analysis of low and medium complexity within a database such as excel which saves time associated with eventual data imports from other sources, that the data to be analyzed can be calculated and organized using standard Excel tools, such as links, formulas and dynamic tables.
Cons:
If one wants to customize the output format, associated for example to the titles of the axes of a graph, they are lost if one does a recalculation. The same goes for associated outputs histograms, for example. I have not been able to find two-way ANOVA solutions in particular, but suddenly it is asking too much of a non-specialized application like this one.
Analyse-it Software Response
7 years ago
Thank you very much for taking the time to review Analyse-it. Actually, since version 4.80, Analyse-it does support 2-way (and higher level, e.g. 3, 4, 5-way) ANOVA (with multiple comparisons) in the Fit Model analysis. Unfortunately though it does not maintain customizations you make to the analysis output when recalculating, as it regenerates the output.
Indespensable
Comments: I use Excel to analyze, validate, and sumarize volumes of data every day. Since Analyse-It is always right there on my Excel ribbon, I go to it regularly. The correlation matrix is a great data validation tool because so much of my data is inter-related and a value that is within range for a certain field, but not in relation to another field can be quickly identified. The tests under Compare Groups and Compare Pairs let me evaluate significance before publishing data. I am not a professional statistician, but Analyse-It gives me all of the tools in an easy to use package that lets me focus on understanding my data.
Pros:
It is always on the ribbon of Excel so when I need to run a quick analysis, it is there.