File Exchange

image thumbnail

StatisticsPlus Excel AddIn

version 1.0.0.0 (675 KB) by Laszlo Balkay
This Excel AddIn contains some Matlab functions from the Statistical Toolbox.

2 Downloads

Updated 07 Jan 2013

View License

The following functions are supported:

- chi2gof: Chi-square goodness-of-fit test
- signrank: Wilcoxon signed rank test
- signtest: Sign test
- ranksum: Wilcoxon rank sum test
- kstest2: Two-sample Kolmogorov-Smirnov test
- kruskalwallis: Kruskal-Wallis test
- friedman: Friedman's test

Not all syntaxes are supported, the available forms are described in the example excel files in the package (StatisticalTests_MatlabAddin_Examples_2003_2007.xls for Excel 2003 and 2007, StatisticalTests_MatlabAddin_Examples_2010.xlsx for Excel 2010).

This Excel AddIn also requires to install the Matlab Compiler Runtime (7.16) on your computer.

Installation:
1. Move the Matlab_StatisticsPlus_pkg.exe file to the directory where you want to install the AddIn, and run as administrator. This program will create 5 new files and register the Matlab_StatisticsPlus_2_1.dll.

2. Download and install the Matlab Compiler Runtime program (version 7.16). The appropriate version can be downloaded from here:
http://www.pet.dote.hu/~balkay/fca/matlabruntime/MCRInstaller.exe

3. Run the Excel and select the Matlab_StatisticsPlus.xla file using the AddIn menu. (http://www.addintools.com/documents/excel/where-is-add-ins.html)

4. Read the appropriate Excel example file (as mentioned above) to see the syntax and usage

Cite As

Laszlo Balkay (2020). StatisticsPlus Excel AddIn (https://www.mathworks.com/matlabcentral/fileexchange/39743-statisticsplus-excel-addin), MATLAB Central File Exchange. Retrieved .

Comments and Ratings (0)

MATLAB Release Compatibility
Created with R2011b
Compatible with any release
Platform Compatibility
Windows macOS Linux