Sidebar Menu

Download SmartstatXL Add-In

SmartstatXL Add-In

Smart tool for statistical analysis
Statistics Application integrated in Microsoft Excel

Excel Add-In

Featured Product

SmartstatXL Add-In

Featured

Analyse Data can be done in one application, Excel. Menu Display and Dialog Box Features Complete and self exlapanatory analysis . The results of the analysis are presented in a neat, complete, clear and eye catching manner . Other excellent features: missing data calculation, automatic data transformation, data diagnostics and more.

View

 

Affordable Prices

The price is very affordable and much cheaper than other similar applications. Price options vary, depending on the type of user and the rental period. Upgrading to a higher version only adds to the previous cost shortfall. There are special prices for students, discounts up to 60%.

 

View

 

Complete Documentation

The SmartstatXL user manual is well documented. How to install, activate, and analyze data are described step by step. The tutorial starts with a case example, then describes the stages of analysis accompanied by explanations and illustrations, and finally an explanation and interpretation of the results of the analysis.

Tutorial

 

Price List (2)

Price List

Free
Free...

Rp0
-


FREE EDITION

BASIC STATISTIC
  • Descriptive statistics (*)
  • Correlation (*)
  • Uji-z
  • Uji-t Student (*)
  • Non Parametric Test (one sample)
REGRESSION
  • Simple Linear Regression
  • Regression Equation
ANOVA
  • Anova table
  • Average score table
  • Anova Assumption Test
EXPERIMENT LAYOUT
  • Automatic Treatment Randomization
  • Making Layouts/Trial Plot Layouts (RAL/RAK/RBSL)
Professional
starting from

IDR 50.000,-
(Student)


STANDARD EDITION +

All Standard Edition features plus:

AUTOMATIC TRANSFORMATION
(ANOVA and REGRESSION)
  • Search for optimal transformation type
  • Auto replace outlier data
REGRESSION
  • Optimization (Maximum & Minimum)
AFTER THIS
  • Split-Plot
  • Split-Split-Plot
  • Strip Plot
  • Multi Location/Year/Season
  • Repeated Measure
NON PARAMETRIC :
  • All Non Parametric Tests(including Kruskall-Wallis (One Way Anova), Friedman (Two Way Anova) and Cochran Q)

Download

Special Price for Students, discount up to 60%

Contact Me!

 

SmartstatXL Excel Add-In Feature

Excel Tools for Simple Statistical Analysis

SmartstatXL (Excel Add-In) is a Statistical Data processing application and Experimental Design, such as Descriptive Statistical Analysis, Correlation, Regression, T Test, Non Parametric Analysis, Experiment Layout, Anova and Advanced Test which is integrated in Excel Application. Here's the menu display and some of the SmartstatXL Add-in Application Features:

Smartstat Add-In Menu Display
Smartstat Add-In Menu Display

SmartstatXL Add-In Features - Basic Statistics

Basic Statistics
SmartstatXL Add-In Features - Basic Statistics

Basic Statistics

Descriptive Statistics

Central tendency : Mean, Median, Mode, Harm & Geom Mean
Variability or Dispersion Range , Variance, Standard Deviation, Quartile, IQR, CI 
Distribution : Skewness, Kurtosis 
Normality Test : Shapiro Wilks, Kolmogorov- Smirnov & Liliefors, Anderson Daring, D'Agostino Pearson 
Chart : Histogram & Normal P-Plot 
Group : Analysis can be split based on items/levels of certain variables


Correlation Analysis

Correlation analysis :
 - Pearson R,
 - Spearman Rho, and
 - Kendall Tau
Output:
 - Complete correlation matrix table with significant sign.
 - Pairwise correlation table (r value and p value)
 - Scatter Plot (Scatter Diagram)
Group : Analysis can be split based on items/levels of certain variables

Regression Analysis

Regression Analysis:

  • Simple Linear
  • Multiple Linear
  • Polynomial
  • Response Surface
  • Logistics: Logit, Probit, Multinomial, Ordinal

Features & Outputs:

  • Lost data calculation
  • Metode Regresi: Enter, Stepwise, Forward Selection, Backward Selection, Forward Information Criteria
  • Regression Diagnostics (Normality, Homogeneity, Residual Plot and Outlier data information)
  • Box-Cox Transformation
  • Automatic transformation
  • Automatic outlier data replacement
  • Chart:
    • 2D and 3D Graphics for Response Surfaces,
    • ROC Curve, Metrik Performance, Outcome vs. Prediction
  • Optimization (Maximum and Minimum)
  • Confusion Matrix (Classification and Metric Tables)
  • Regression Equation
  • Adjusted Regression/Goodness Statistics: R 2 , R 2 , corrected, Correlation Coefficient; AIC, AICc, BIC, RMSE, MAE, MPE, MAPE, sMAPE
  • Coef Estimation. Regression: Coefficient Value; Standard errors; t statistic, p value, Upper/Lower, VIF
  • Anova: Sequential and Partial
  • etc.

Student t-test and z-test

Student's t-test and z-test:

  • One sample z test
  • z test two independent samples
  • One sample t test
  • Two sample t-test (independent t-test):
    • Levene test for variance homogeneity test  
    • Welch's t-test (when the two variables are not homogeneous)
  • Paired t test

Features/Outputs:

  • Data layout for comparison:
    • Can compare between variables (different columns) or between levels/groups (same column, as Sample ID's)
  • Alternative Hypothesis: can be one-way () or two-way (≠)
  • Critical Areas & Conclusions

Non Parametric Analysis

Single Sample:

  • Sign Test (Single Sample)
  • Wilcoxon Signed Ranks Test (Single Sample)

Independent Sample:

  • Wilcoxon Rank Sum Test
  • Mann-Whitney U Test
  • Kolmogorov-Smirnov Test
  • Kruskal Wallis Test (One Way Anova)

Paired Sample (Dependent/Paired/Related Sample):

  • Wilcoxon Signed Ranks Test (Paired Samples)
  • McNemar Test
  • Sign Test (Paired Samples)
  • Friedman (Two Way Anova)
  • Cochran Q Test

SmartstatXL Add-In Features - ANOVA

ANOVA (Experimental Design)
SmartstatXL Add-In Features - ANOVA

ANOVA (Experimental Design)

ANOVA

Experimental Design :

  • Automated Creation of Layouts/Plot Layouts of various Experimental Designs
  • One Way Anova/Completely Randomized Design (CRD)
  • Two Way Anova/Randomized Block Design (RAK)
  • Latin Square/Latin Square Design (RBSL)
  • Factorial (Can be up to 3 factors, it's just that what is given further test notation is limited to only 3 factors)
  • Split Plot
  • Split-Spit Plot
  • Strip Plot
  • Mixed Design
    • Multi Location/Season/Year
    • Repeated Measure - Analyze multiple responses (Dependent Variables) at once
    • Between/Within
  • Sub-Sampling (Withdrawal of sample children)

Variabel Respons:

  • Analysis can be performed for multiple responses (Dependent Variables) at once

Missing Data :

  • Lost data calculation (able to calculate some missing data in each Response)

Auto Transform:

  • Searching for the optimal type of transformation automatically so that the results of the analysis of variance do not violate the ANOVA assumption.
  • In addition to transformations, SmartstatXL can also replace outlier data values automatically, either from the original data or from the transformed data. 
  • Transformation data/New data (when there is missing data/sampling) is included in the output
  • Transformation Type:
    • Square Transformation
    • Square Root Transformation
    • Log Transformation
    • Inverse Square Root Transformation
    • Reciprocal Transformation
    • Inverse Square Transformation
    • ArcSin 

ANOVA table :

  • The F-count value is colored red and is marked with an asterisk (*) for the influencing factor
  • P-Value (Sig) and F-table values at 5% and 1% significance levels
  • Value of the Coefficient of Diversity

Post Hoc :

  • LSD
  • Tukey’s HSD
  • Scheffé’s test
  • Duncan
  • Student Newman Keuls (SNK)
  • REGWQ
  • Scott Knott
  • Bonferroni
  • Check
  • Dunnet
  • Several further tests can be used to make comparisons with controls
  • Can be used for further testing of simple effects or interactions 
  • Comes with Critical Values and for the Scott-Knot test included partition summaries, Bo-Max, Lambda and Chi-Square
  • Table Average ± ERROR. The average value can be completed with a Standard Error, Standard Deviation, or Confidence Interval value

Display for Treatments Means (Table and Graph)

  • Presentation of the average value can be in the form of tables and graphs

ANOVA Diagnostics :

  • Anova Assumption Check
    • Homogeneity test (Levene test)
    • Normality Test (Shapiro Wilks, Kolmogorov-Smirnov & Liliefors, Anderson Daring, D'Agostino Pearson)
  • Residual Analysis Table
    • Predicted
    • Residual
    • Studentized Residual
    • Studentized Deleted Residual
    • etc.
  • Plot Resiual 
    • Normal plot
    • Histogram
    • Versus predicted values
    • Standard Deviation vs. Average value
  • Box-Cox Transform (finding the optimal lambda value to choose the right type of data transformation)
  • Checking outlier data and calculating missing data

Sample Output

Sample Output Analysis

The following workbook  is an example of the results of data analysis using the SmartstatXL Add-in plugin . The workbook contains several analysis output worksheets and examples of raw data. You can view the worksheets by clicking on the sheet name or you can download them by pressing the download icon at the bottom right of the Workbook.

How to Install SmartstatXL Add-In EN

How to Install SmartstatXL Add-In
Excel: How to Install SmartstatXL Add-In (Smart Tool for Statistical Analysis)