Home > Excel Business Solutions > Business Finance > Risk Analysis > Statistical Analysis Share

Statistical Analysis

Excel statistical analysis for risk analysis


Excel Statistical Analysis

Rate this solution:
(3/5 from 4 votes)
Statistical Analysis screenshot
Statistical Analysis for Excel (statistiXL) is an extremely powerful, feature rich data analysis package that runs as an add-in to Excel. 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, Statistical Analysis for Excel 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 Statistical Analysis for Excel and the manual creation of new charts based on 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 Statistical Analysis for Excel fall into the following categories:
  • Analysis of Variance (ANOVA)
  • Clustering - Hierarchical clustering of binomial, quantitative and mixed datasets is supported.
  • Contingency Tables - Both 2-way and multi-way contingency data can be analyzed.
  • Correlation - Simple, Partial, Multiple and Canonical correlation is supported.
  • Descriptive Statistics available for both linear and circular data sets.
  • Discriminant Analysis - Both Grouping and Classification methods of Discriminant Analysis are supported.
  • Factor Analysis can be performed on either the correlation or covariance matrix of the raw data set.
  • Goodness of Fit - A wide variety of tests
  • Linear Regression - Simple and Multiple Linear Regression is supported.
  • 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 Component Analysis is provided as a means for the reduction of large multivariate data sets into simpler structures.
  • t Tests - One and two sample, uni-variate and multivariate t tests are supported.

Try It  Get It

(Pricing is available on the next page)
(Updated on 2023-02-01)

Related Excel Solutions for Statistical Analysis

Statistical Distribution FittingRisk Analysis  Multiple Regression ForecastingForecasting and Prediction  Statistics Add-inForecasting and Prediction  Time Series AnalysisForecasting and Prediction  Economic DataTechnical Analysis  Survey Data AnalysisPresentation and Reporting  Risk ModelingTraining and Tutorials  Curve FittingManufacturing and Engineering

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.