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.
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%.
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.
All Free Edition features plus:
All Standard Edition features plus:
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:
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 :
- 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:
Features & Outputs:
Student's t-test and z-test:
Features/Outputs:
Single Sample:
Independent Sample:
Paired Sample (Dependent/Paired/Related Sample):
Experimental Design :
Variabel Respons:
Missing Data :
Auto Transform:
ANOVA table :
Post Hoc :
Display for Treatments Means (Table and Graph)
ANOVA Diagnostics :
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.
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