# Statistical Analysis

## Excel Statistical Analysis for Risk Analysis

 Submit an Excel Solution Submit Solution [Guide]

 Find Excel Solutions:
Select suggested text to load results or icon to view solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity

 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.

Price: USD 75.00

 Related Excel Solutions: Multiple Regression Forecasting (Forecasting and Prediction) | Data Mining (Technical Analysis) | Quantitative Econometric Functions (Technical Analysis) | Business Statistics (Process Management) | Statistical Distribution Fitting (Risk Analysis) | Statistics Add-in (Forecasting and Prediction) | Curve Fitting (Manufacturing and Engineering) | Financial Modeling Add-ins (Financial Analysis) | Time Series Analysis (Forecasting and Prediction) | Risk Modeling (Training and Tutorials) | Survey Data Analysis (Presentation and Reporting)