The SmartstatXL Add-In is an addition to Excel that provides tools for statistical data processing and experimental design directly within the Excel Application.

SmartstatXL Add-In Installation Instructions

If you have installed a previous version of the SmartstatXL Add-In, please UNINSTALL that version first before installing the latest version of the SmartstatXL Add-In.

For more detailed installation instructions, please visit: How to Install and Uninstall SmartstatXL Add-In for Microsoft Excel

How to Activate SmartstatXL Add-In

For more information about activating the SmartstatXL Add-In, please visit: SmartstatXL Activation Guide: Step-by-Step to Activate Your License.

#ChangeLog

[3.6.5.3] - 2024-06-01

Add

• Payment Method: Payments can be made via PayPal and Debit or Credit Cards
• Sub Menu for T-Test and Non-Parametric Tests: Added new sub menus for conducting T-Test and Non-Parametric Tests.
• Nested Design: Added functionality to support Nested Design analysis.
• Multisite and Repeated Measure: New menu for Multisite and Repeated Measure analysis in Factorial Design, Split Plot, and other designs.
• Missing Data: Convergence Criteria for missing data calculation

Changed

• Code Optimization: Optimized code to improve efficiency and performance.
• Save Last Options: Implemented a feature to save the last used options (combo box, check box, radio button, text field).
• Levene's Test to Bartlett's Test: Replaced Levene's Test with Bartlett's Test if Levene's Test cannot be calculated.
• PostHoc Refactoring: Refactored the PostHoc analysis module to improve code quality and analysis results.
• Output Display Improvement: Improved the display of outputs for several analyses to make them easier to read and understand.

Fixed

• Additivity Test for Subsampling: Fixed an error in the ADDITIVITY TEST for subsampling.
• Bug in RBSL Split Plot Subsampling: Fixed a bug in the analysis of RBSL Split Plot Subsampling.
• Bug in RBSL Factorial Subsampling: Fixed a bug in the analysis of RBSL Factorial Subsampling.
• Bug in RBSL Split Plot Repeated Measure: Fixed a bug in the analysis of RBSL Split Plot Repeated Measure.
• Bug in Split Split Plot RBSL: Fixed a bug in the analysis of Split Split Plot RBSL.
• Improvements in Anova RAK Repeated Measure Calculations: Fixed calculations in the Anova RAK Repeated Measure analysis.
• Fixing Several Bugs: Fixed several bugs found in the previous version.

[3.6.1.0] - 2023-11-14

Add:

• Added Assumption Test: Tukey Additivity for one-factor RAK (Test of Additivity in two-way ANOVA without replication)
• Activation:
  • Payments can be made via PayPal, e-Wallets, Banks, and Marketplaces
  • Added PayPal button
  • Currency: IDR and USD
• Referral Program: Added Referral Menu

Fixed:

• Bug in Update from Previous Version. SmartstatXL Menu did not appear (Uninstall the previous version first)
• Post Hoc (Further Tests):
  • Treatment comparison: can compare more than 100 treatments
  • Improved notation for simple effects in designs like Split Plot, Strip Plot, Split-Split Plot using Tukey's Test
• Activation Process
• Code optimization

Changed:

• Changed several Interfaces in Activation Dialog Box
• Activation: Rental time can be adjusted (1, 3, 6, 12, 120 months)

[3.5.1.0] - 2023-07-31

Add:

• Homogeneity Test in Descriptive Analysis Menu
• Partial Correlation
• Timeseries:
  • Moving Averages
    
    • Simple Moving Average
    • Centered Moving Average
    • Weighted Moving Average
    • Weighted Centered Moving Average
    • Kaufman's Moving Average
    • etc.
  • Exponential Smoothing
    
    • Simple Exponential Smoothing
    • Double Exponential Smoothing (Holt Linear Trend)
    • Triple Exponential Smoothing (Holt Winter's)
    • Damped Holt Winter's
  • Auto Correlation
  • Auto Partial Correlation
  • ARIMA
• Exploratory and Classification
  
  • Reliability Analysis
  • Principal Component Analysis (PCA)
  • Factor Analysis
  • Agglomerative Hierarchical Cluster Analysis
  • K-Means Cluster Analysis
  • Discriminant Analysis
• Offline Registration (If connection issues occur)
• Referral Program

Fixed:

• Biplot in Factor and PCA Analysis
• K-Means: String type variables can be used for initial clustering
• Activation Process

Changed:

• Changed several Interfaces of Menu, Options, Analysis Dialog Box, and Output Display
• Activation: Rental time can be adjusted (1, 3, 6, 12, 120 months)