Sidebar Menu

Welcome to Smartstat, since 2009

SmartstatXL Add-In
SmartstatXL Add-In

SmartstatXL Excel Add-In More

Smartstat is a leading site focused on Statistics and Experimental Design material. We present comprehensive and in-depth content, blending theory with relevant examples or case studies. In each material, we include solutions to problems both through manual calculations and the use of data processing software, ensuring a thorough understanding.

To facilitate the learning process, we also present most of the software material in separate tutorial formats. This allows users to learn at their own pace and understand the concepts better.

In 2020, Smartstat expanded into product creation, with our flagship product, SmartstatXL Add-In. This application is an Excel-based data processing solution that integrates advanced statistical functions into a user-friendly interface.

Additionally, Smartstat also provides professional data processing services for various needs, such as Theses, Dissertations, and other research. We are dedicated to providing solid statistical support, facilitating your research process, and enhancing the quality of your work.

YouTube Channel:
SMARTSTAT

Statistics

Complete Statistical materials with examples of their applications.

  • Statistical Basics
  • Descriptive Statistics
  • Data Exploration
  • Correlation
  • Student's t-Test
  • Distribution Tables
  • Regression
  • Non-Parametric

-

Statistics

Experimental Design

Complete Experimental Design materials with examples of their applications.

  • Basics of Experimental Design
  • Basic Designs:
    • CRD, RBD, LS
  • Factorial and Mixed Models
    • CRD & RBD Factorial
    • Split Plot
    • Split-Split Plot
    • Strip Plot
  • Assumptions of Analysis of Variance
  • Mean Comparisons

Slide & Tutorial

Teaching material slides and Tutorials for Statistical Software, Word, and ArcGIS

  • Slides:
    • Experimental Design
    • Mathematics
  • Tutorials:
    • SmartstatXL
    • SPSS
    • Minitab
    • Statistica
    • Microsoft Excel and Word
    • ArcGIS
Slides Tutorials

Products and Services

Excel Add-In Product from Smartstat

SmartstatXL

SmartstatXL, fully integrated with Excel, provides comprehensive features for statistical data analysis and experimental design, including handling missing data, automatic data transformation, and data diagnostics. The analysis results are presented neatly, completely, and are easy to interpret.

SmartstatXL


Smart Spell Number

Smart Spell Number is an Excel add-in that functions to convert numbers into words in both Indonesian and English. In addition, this function also provides writing flexibility by offering Letter Case options and supporting various types of currencies.

Spell Number

Smart Soil Texture

Smart Soil Texture is an Excel Add-in that serves as an innovative tool for determining soil texture classes based on the content of sand, silt, and clay, in accordance with the USDA soil texture classification system. The results can be presented in both Indonesian and English.

Smart Soil Texture

Data Processing Services

Data Processing Services

Having trouble or no time for data processing?

Smartstat offers data processing services for theses, dissertations, and research projects.

ANOVA

  • Anova Table
  • Tables and Graphs of Averages
  • Post Hoc Tests:
    • LSD, Tukey’s HSD, Scheffé's test, Duncan, Student Newman Keuls (SNK), REGWQ, Scott Knott, Bonferroni, Sidak, Dunnet
    • Critical Values
    • Simple Effects or Interactions
  • Anova Diagnostics:
    • Examination of Anova Assumptions
    • Tables and Plots of Residuals
    • Box-Cox Transformation
    • Examination of Outliers and Missing Data Calculation

CORRELATION and REGRESSION

  • Pearson, Spearman, and Kendall Correlations
  • Linear, Multiple, Polynomial, Response Curve Regression
  • Logit, Probit, Ordinal, and Multinomial Regression

NON-PARAMETRIC ANALYSIS / T-TEST & Z-TEST

  • Single Sample
  • Two or more independent and paired samples
  • Further Testing (Specifically for Friedman and Kruskal Wallis)

Contact Us

Statistics

Article Statistics
View more
28 Jul Wilcoxon Test For Paired Data

Example of manual Wilcoxon Test calculation.. Download...

05 Sep Descriptive Statistics

Statistics is a set of procedures for collecting, measuring, classifying, calculating, explaining,...

05 Sep Stemplot (Stem-and-Leaf Plot)

Another representation that is similar to a histogram is the Stamplot . Stemplot is also known as stem-and-leaf...

05 Sep Variables and Data

Variable comes from the words " vary " and " able " which means " change " and " can". So,...

Experimental Design

Experimental Design
View more
23 Aug Randomized Complete Block Design (RCBD)

Experimental units in a Completely Randomized Design (CRD) are always assumed to be homogeneous . In...

23 Aug Example of Split Block Design (Strip Plot)

Example of Application of Split Block Design (Strip Plot/Striped Grid) This sample article on...

01 Aug ANOVA Assumptions

Assumptions for hypothesis testing based on the single factor ANOVA model are actually related to...

23 Aug Strip Plot Design

Another name for Split-Block Design is Strip-Plot Design . This design is suitable for a two-factor...