Code covered by the BSD License  

Be the first to rate this file! 15 Downloads (last 30 days) File Size: 675 KB File ID: #39743

StatisticsPlus Excel AddIn

by

 

This Excel AddIn contains some Matlab functions from the Statistical Toolbox.

| Watch this File

File Information
Description

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

MATLAB release MATLAB 7.13 (R2011b)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.

Contact us