Sidebar Menu

SmartstatXL Add-In

The "Tutorial Category for SmartstatXL Excel Add-In" on the Smartstat website is a valuable resource for anyone wanting to learn how to use this add-in for statistical analysis. These tutorials cover a variety of topics, such as descriptive statistical analysis and normality tests, as well as how to perform a one-factor Randomized Block Design (RBD) analysis across multiple locations or seasons. Each tutorial comes with a link to download the add-in and is presented in an easy-to-understand format, making it an extremely useful learning resource for anyone looking to improve their data analysis skills using the SmartstatXL Excel Add-In.

Smartstat XL Add-in is a plugin for statistical data analysis and experimental design added to MS. Excel. The following video describes SmartstatXL, its features, and how to install and uninstall SmartstatXL in the Microsoft Excel application.

Download SmartstatXL Add-In Free *): https://www.smartstat.info/download/category/22-excel-add-in.html 

Pearson Correlation Analysis using SmartstatXL Add-In

Download Add-In:

Downloads:
Fitur SmartstatXL Add-In
Fitur Smartstat
...
Date-107Saturday, 09 January 2021 18:15
System-107  Windows
File Size-107 2.23 MB
Download-107 12,024

Feature:

  • Correlation Analysis: Pearson, Spearman, and Kendall.
  • The output is in two form: correlation matrix and pairwise correlation.
  • Opsional: Scatter Plot, Grouping Variable

Descriptive statistical analysis and Normality Test (Shapiro Wilks, Kolmogorov-Smirnov & Liliefors, Anderson Darling, D'Agostino) using SmartstatXL Add-In.

Download Add-In: https://www.smartstat.info/download/category/22-excel-add-in.html

Feature:

    • 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 Darling, D'Agostino Chart: Histogram & Normal P-Plot

The method for analyse Randomized Complete Block Design (RCBD) Single Factor across multiple locations , years, and seasons using the SmartstatXL Add-In .

Followed by Post Hoc test for main and interaction (simple) effect  with the Post Hoc Test : Tukey , LSD , Duncan , Scott Knott , REGWQ, ets.

.