T O P I C R E V I E W |
AKazak |
Posted - 08/13/2021 : 4:41:30 PM OriginPro 2022 (64-bit) Beta2 9.9.0.105 Windows 7 SP1 x64
Greetings!
1) How do I calculate descriptive statistics on matrix objects in a way similar to that of columns? 2) What is the proper way to define and calculate a custom function returning a scalar value (vector) from each matrix object? For example, (max-min)/stdev?
Thank you.
--- Andrey |
3 L A T E S T R E P L I E S (Newest First) |
AKazak |
Posted - 08/14/2021 : 04:13:14 AM Dear Snow,
Got it! Thank you.
I will test and report in case of issues.
--- Andrey |
snowli |
Posted - 08/13/2021 : 5:38:48 PM Try this in Set Column Values supposing 1st column is object number.
function double test(int nObject) { range rmat = [MBook1]MSheet1!$(nObject); stats rmat; return (stats.max-stats.min)/stats.sd }
Thanks, Snow |
snowli |
Posted - 08/13/2021 : 5:26:21 PM Was 1 already discussed in https://my.originlab.com/forum/topic.asp?whichpage=1&TOPIC_ID=46963#70545
Regarding to 2, I don't see tool for it but you can run stats; //do stats on active object stats.= //see what quantities we created. stats.max=; stats.min=; stats.sd= (stats.max-stats.min)/stats.sd=;
Thanks, Snow
|