StatistiXL - statistical package for Excel

Welcome to statistiXL

StatistiXL is a powerful new data analysis package that runs as an add-in to Windows™ versions of Microsoft’s sophisticated Excel™ spreadsheet program. statistiXL has been entirely designed and written by scientists in order to meet the demanding needs of anyone requiring access to a robust, versatile statistical analysis package that is quick to learn and easy to use. You no longer need to spend hours with manuals just learning how to perform the analyses you need in order to get to the really important bit … the results.

With it’s wealth of features, Excel™ provides an ideal environment for data input, manipulation and calculation. By leveraging this familiar environment, statistiXL greatly extends this feature set to encompass high powered statistical analysis without the need to learn how to use an entirely new application from scratch. Data stored in existing Excel™ spreadsheets can instantly be subjected to a wide range of statistical tests (many frequently not seen in other analysis software) including…

• Analysis of Variance (ANOVA)
• Cluster Analysis
• Contingency Tables
• Simple, Partial, Multiple and Canonical Correlation
• Linear and Circular Descriptive Statistics
• Classification and Grouping Discriminant Analysis
• Factor Analysis
• Goodness of Fit Tests such as Binomial, Circular, Normal and Poisson
• Simple and Multiple Linear Regression
• Nonparametric Tests such as Friedman, Kruskal-Wallis and Mann-Whitney
• Principal Component Analysis (PCA)
• Univariate and Multivariate t-Tests

And because statistiXL outputs the results of its analyses straight into an Excel™ spreadsheet you can use the tools that you are already familiar with to arrange and format both textual and graphical output: changing fonts, rearranging cells, altering the scale on the axis of a graph etc etc. You can even subject  the results to further analysis using either statistiXL or Excel’s™ numerous built in functions.

Features

StatistiXL is an extremely powerful, feature rich data analysis package that runs as an add-in to Microsoft's popular Excel™ spreadsheet program. It provides access to a wide variety of both parametric and non-parametric data analysis tools and statistical tests. By working from within Microsoft Excel™, statistiXL is able to leverage the existing features of Excel™ and provide a host of additional benefits including...

• A familiar and powerful user interface for entering and manipulating data
• A wide variety of formatting options for altering the appearance of results
• The presence of a sophisticated charting package that allows both the manipulation of charts produced by statistiXL and the manual creation of new charts based on statistiXL's output.
• The ability to perform further ad hoc analysis using Excel's™ own built in functions and calculating abilities.

The data analysis features provided by statistiXL fall into the following categories:

Analysis of Variance (ANOVA) - statistiXL provides both univariate and multivariate ANOVA and ANCOVA. Full factorial and user specified models are supported as are fixed and random factors, nesting and repeated measures.

Clustering - Hierarchical clustering of binomial, quantitative and mixed datasets is supported as is clustering based on a predetermined distance matrix. A wide variety of similarity/distance estimates and clustering methods are available and the resultant clustering strategy can be graphically displayed as both a text based and/or graphical dendrogram.

Contingency Tables - Both 2-way and multi-way contingency data can be analysed.

Correlation - Simple, Partial, Multiple and Canonical correlation is supported with graphs of Canonical Variates available for the latter.

Descriptive Statistics - Descriptive Statistics are available for both linear and circular data sets. Linear descriptives include a choice of 18 statistics such as Mean, Standard Error and Mode, as well providing Box and Whisker plots and Error Bar plots for a graphical representation of the data. Circular descriptives provide 9 statistics including Mean Angle Circular Variance and Angular Variance.

Discriminant Analysis - Both Grouping and Classification methods of Discriminant Analysis are supported. For Grouping Discriminant Analysis, scatterplots of case scores can be produced for each pair of components. For Classification Discriminant Analysis, an alternate dataset can be classified based on the discriminant functions determined for the primary set.

Factor Analysis - Factor Analysis can be performed on either the correlation or covariance matrix of the raw data set. A variety of component extraction and rotation methods are supported and both scree and scatterplots of case scores can be produced.

Goodness of Fit - A wide variety of tests for the Goodness of Fit of datasets to theoretical distributions are provided including those for Binomial, Circular, Normal, Poisson and Uniform distributions. The level of fit to user specified distributions can also be calculated.

Linear Regression - Simple and Multiple Linear Regression is supported. Plots of regression models and residuals can be produced.

Nonparametric Tests - Numerous Nonparametric Tests are supported including Friedman, Kruskal-Wallis, Mann-Whitney, Mood's Median, Sign, Spearman, Wald-Wolfowitz and Wilcoxon Paired-Sample tests.

Principal Components - Principal Component Analysis is provided as a means for the reduction of large multivariate data sets into simpler structures. Scree plots and Scatterplots of case scores can be produced.

t Tests - One and two sample, univariate and multivariate t tests are supported.

Order

Home

Excel Spreadsheets