The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Descriptive Statistics on Matrix Objects		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

AKazak

Russia
1205 Posts
Posted - 08/13/2021 :  4:41:30 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

snowli

USA
1386 Posts
Posted - 08/13/2021 :  5:26:21 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

snowli

USA
1386 Posts
Posted - 08/13/2021 :  5:38:48 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
1205 Posts
Posted - 08/14/2021 :  04:13:14 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Dear Snow,

Got it!
Thank you.

I will test and report in case of issues.

---
Andrey
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000