Calculation and display of p-value - a Matlab application that can be run as Excel add-in

Can somebody guide me how can be something like this: Calculation and display of p-value - a Matlab application that can be run as Excel add-in be done? For every help i would be thankfull.

Answer 1

[Shivang]

Hi,

I understand that you wish to create an Excel add-in using MATLAB that can compute and display the p-value of a statistical test.

To begin with, you need to write a function in MATLAB to calculate the p-value based on your specific statistical test or analysis. This function should take input data and return the calculated p-value. There are various built-in functions in MATLAB that can calculate the p-value corresponding to a particular test. Refer to this documentation page for more details: https://mathworks.com/help/stats/hypothesis-tests-1.html

After writing a MATLAB function, you can use the MATLAB Compiler to generate an Excel add-in. Follow the workflow described in this article to create, install and test your Excel add-in. https://mathworks.com/help/compiler/excel/create-an-excel-application-from-matlab-code.html

Hope this helps.

-Shivang