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 Table of Statistical Distribution

A collection of distribution tables (critical values) that are often used in statistical analysis:...

06 Sep Central Tendency: Mean - Median - Mode

One of the most important aspects to describe the distribution of data is the value of the...

23 Aug Independent T-Test for Two Samples (Equal Variance)

In one sample t-test we only compare a population with a certain value, but in reality cases using...

05 Sep Scales of Variable Measurement

Variable measurement is the process of assigning values or attributes to an object. There are four...

Experimental Design

Experimental Design
View more
23 Aug Tukey HSD - Post Hoc Test

Tukey's test is often also called the honestly significant difference test ( HSD ), introduced by...

23 Aug Latin Square Design (LSD)

4.1. Introduction Randomized Complete Block Design (RCBD) is generally used to improve the ability to...

23 Aug Example of CRD Factorial

This article is a continuation of the Completely Randomized Design (CRD) Factorial. Suppose there is...

23 Aug Scheffe - Post Hoc Test

Scheffe's test is compatible with the analysis of variance test, where this test never states a...