Home > Excel Business Solutions > Financial Markets > Technical Analysis > Advanced Statistics Share

Advanced Statistics

Excel advanced statistics for technical analysis

Excel Advanced Statistics

Rate this solution:
(3.2/5 from 5 votes)
Advanced Statistics screenshot
Advanced Statistics for Excel is a Microsoft Excel add-in that has been developed since 1993 to enhance the analytical capabilities of Excel. Advanced Statistics for Excel includes a wide range of technical analysis functionality covering most of the requirements for data analysis and statistics.

Some Excel utilities have also been included to facilitate charting and data manipulation. All tools can be accessed from the Advanced Statistics for Excel menu item in the Excel menu bar, or by clicking on the buttons of the Advanced Statistics for Excel toolbar. Complementary time series analysis modules are also available.

All Advanced Statistics for Excel functions have been abundantly tested against the best known statistical packages to guarantee that the results provided by Advanced Statistics for Excel are 100% reliable and compatible with what other packages would give.

Key features of Advanced Statistics for Excel include:
  • Preparing data: Data Sampling, Distribution Sampling, Discretization, Coding, Presence/Absence coding, Creating Dummy Variables, Coding by Ranks, Partition recoding, Transformation, Anamorphosis.
  • Describing data: Descriptive Statistics (including scatter grams), Histograms, Normality tests (including q-q plots and p-p plots), Contingency Table (Two-way Table), Correlations and Similarity/Dissimilarity Matrix.
  • Analyzing data: Factor analysis, Principal Component Analysis (PCA), Gabriel Biplot, Discriminant analysis (DA), Correspondence Analysis (CA), Multiple Correspondence Analysis (MCA), Multidimensional Scaling (MDS), Agglomerative Hierarchical Clustering (AHC), k-means Clustering Univariate Clustering.
  • Visualizing data: Axes Zoomer, Easy Labels, Micro Mover, Plot transformer, Scatter plots, Parallel Coordinates.
  • Modeling data and forecasting: Distribution Fitting, Linear Regression, ANOVA, ANCOVA, Logistic regression (Logit, Probit), Nonlinear regression, Nonparametric regression (Kernel and Lowess).
  • Correlation and Association tests: Tests on Contingency Tables, Correlation tests, Mantel test, Parametric tests One sample t and z tests, Two sample t and z tests, Multiple comparisons tests, Two sample comparison of variances, k samples comparison of variances, Comparison of two proportions.
  • Non parametric tests: Kolmogorov-Smirnov, Mann-Whitney, Wilcoxon's signed-ranks test and sign test, Non parametric Tests on k independent samples: Kruskal-Wallis' test, Non parametric Tests on k paired samples: Friedman's test.
  • Tools: Data Flagger, Min Max Search, Delete Invisible Sheets, Delete Hyperlinks, Numerical Codes.

Try It  Get It

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

Related Excel Solutions for Advanced Statistics

Statistical AnalysisRisk Analysis  Mac Data AnalysisForecasting and Prediction  Statistics Add-inForecasting and Prediction  Time Series AnalysisForecasting and Prediction  Technical Analysis FunctionsTechnical Analysis  Trading IndicatorsTechnical Analysis  Random SamplingTechnical Analysis  Worksheet AnalysisTime Saving  Six Sigma TemplatesProcess Management

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.