The Origin Forum
File Exchange
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Descriptive Statistics of matrix object

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
AKazak Posted - 07/21/2021 : 12:24:06 PM
OriginPro 2021b (64-bit) SR2 9.8.5.212
Windows 10 21H1 x64

Greetings!

How do I run Descriptive Statistics for a matrix object without conversion to XYZ data on a worksheet?

Thank you.

---
Andrey
21   L A T E S T    R E P L I E S    (Newest First)
AKazak Posted - 09/08/2021 : 11:53:36 PM
quote:
Originally posted by snowli

Also FYI, Statistics on Column toolbar button is enabled with matrix window so you don't have to activate a workbook first to choose it from menu


Thanks, Snow



Dear Snow,

Got it!
Works like a charm.

Please do not remove this useful feature from Origin.

---
Andrey
snowli Posted - 09/08/2021 : 2:42:11 PM
Also FYI, Statistics on Column toolbar button is enabled with matrix window so you don't have to activate a workbook first to choose it from menu


Thanks, Snow
snowli Posted - 09/08/2021 : 12:11:18 PM
Hi Andrey,

You saw the error because on Output tab of the dialog, not all output are set to output to regular workbook.

E.g. please set
Report Tables -> Book as <new> //this will create new workbook for the report
Quantities -> Book as <report> //this will put quantities to same book as report book

Then you will not see that error and you can use this dialog fine next time without need to restart Origin.

In the dialog, U can click > button next to Dialog Theme and choose Save as <default>. Then when you open the dialog in the future, u don't need to set output again.


Thanks, Snow
AKazak Posted - 09/07/2021 : 10:36:49 PM
quote:
Originally posted by snowli

To me, u have to click inside in matrix object.
Clicking object in thumbnail view or click the matrix sheet tab will not do any thing.

Thanks, Snow



Dear Snow,

In my case, it works only once after Origin started.
If I call the dialog for the second time it doesn't want to select MO.
Can you check this, please?

Also, in my case, it gives the following error after I push OK button: Calling members of unattached wrapper class.

What could be the problem?


---
Andrey
snowli Posted - 09/07/2021 : 2:10:24 PM
To me, u have to click inside in matrix object.
Clicking object in thumbnail view or click the matrix sheet tab will not do any thing.

Thanks, Snow
AKazak Posted - 09/07/2021 : 12:49:04 PM
quote:
Originally posted by snowli

Hi Andrey,

I can still click any cell in matrix window to select that matrix object. It shows what i selected in the "Select from worksheet window".

Thanks, snow



Hm...
If I do a click, then nothing appears in the box.

---
Andrey
snowli Posted - 09/07/2021 : 11:43:22 AM
Hi Andrey,

I can still click any cell in matrix window to select that matrix object. It shows what i selected in the "Select from worksheet window".

Thanks, snow
AKazak Posted - 09/07/2021 : 10:49:50 AM
quote:
Originally posted by minimax

Hi Andrey,

You can try following:
...

2. Click the interactive selection button (on the left side of the right-triangle button) for Data Range node to click inside the matrix window.
--> You will notice for example [MBook1]MSheet1!1 is picked up in the small "Select from Worksheet" popup window.

...




Seems that I cannot do this anymore in:
OriginPro 2022 (64-bit) Beta2 9.9.0.105
Windows 10 21H1 x64

Please check.
Can you reproduce the issue?

---
Andrey
minimax Posted - 07/22/2021 : 9:10:53 PM
quote:
Matrix objects from 1 to end?

Yes.
As CP mentions, it is a general notation in Origin since 2021b.
You can also use it some other tools which support multiple columns input, like
[Book1]Sheet1!1:0 means all columns in Sheet1.

quote:
Expand "Report Tables" branch, change Book combo from <source>MBook1 to be <new>.
Expand "Quantities" branch, change Book combo to be <report>


My step should already configure the output of both Report Tables and Quantities to the same workbook.
AKazak Posted - 07/22/2021 : 09:14:38 AM
quote:
Originally posted by cpyang

quote:


Can you also explain the following syntax: [MBook1]MSheet1!1:0 used in the dialog, please?




0 = <end>, similar to Python. This was implemented in 2021b as a general thing in Origin.

CP




OK, but what does [MBook1]MSheet1!1:0 reference to?
Matrix objects from 1 to end?
Or something else?

---
Andrey
cpyang Posted - 07/22/2021 : 06:53:20 AM
quote:


Can you also explain the following syntax: [MBook1]MSheet1!1:0 used in the dialog, please?




0 = <end>, similar to Python. This was implemented in 2021b as a general thing in Origin.

CP
AKazak Posted - 07/22/2021 : 05:45:47 AM
quote:
Originally posted by minimax

Hi Andrey,

You can try following:
1. With a workbook window active, select Statistics menu - Descriptive Statistics - Statistics on Columns to open dialog.

2. Click the interactive selection button (on the left side of the right-triangle button) for Data Range node to click inside the matrix window.
--> You will notice for example [MBook1]MSheet1!1 is picked up in the small "Select from Worksheet" popup window.

3. Click the rightmost side button (under the X button) to go back to dialog.
--> "[MBook1]MSheet1!1" is filled in the Data Range node.

4. Modify it a bit to include all objects, [MBook1]MSheet1!1:0.

5. Check the Plot node as you need.

6. Important!!! be sure to go to Output tab, expand "Report Tables" branch, change Book combo from <source>MBook1 to be <new>. (i.e. you cannot output result to matrix window)
Expand "Quantities" branch, change Book combo to be <report>, click OK.
--> The report is created.

Above cannot be done in LT yet, and I suppose there is no LT way to add ROI now.





So far I tried two methods: Intensity Profile for ROI and Descriptive Statistics from a worksheet.

Intensity Profile for ROI
It works fine.
However, I want also to have plots, including histograms and box charts (for some distributions typical stats parameters do not make sense).

Descriptive Statistics from a worksheet

It works as expected.
How do I configure the output of both Report Tables and Quantities to the same workbook?
Can you also explain the following syntax: [MBook1]MSheet1!1:0 used in the dialog, please?


---
Andrey
minimax Posted - 07/22/2021 : 04:26:21 AM
Hi Andrey,

You can try following:
1. With a workbook window active, select Statistics menu - Descriptive Statistics - Statistics on Columns to open dialog.

2. Click the interactive selection button (on the left side of the right-triangle button) for Data Range node to click inside the matrix window.
--> You will notice for example [MBook1]MSheet1!1 is picked up in the small "Select from Worksheet" popup window.

3. Click the rightmost side button (under the X button) to go back to dialog.
--> "[MBook1]MSheet1!1" is filled in the Data Range node.

4. Modify it a bit to include all objects, [MBook1]MSheet1!1:0.

5. Check the Plot node as you need.

6. Important!!! be sure to go to Output tab, expand "Report Tables" branch, change Book combo from <source>MBook1 to be <new>. (i.e. you cannot output result to matrix window)
Expand "Quantities" branch, change Book combo to be <report>, click OK.
--> The report is created.

Above cannot be done in LT yet, and I suppose there is no LT way to add ROI now.

AKazak Posted - 07/21/2021 : 10:57:49 PM
quote:
Originally posted by cpyang

You can easily add ROI to cover the whole matrix by zoom-out.
1. change to image view
2. hold A key and mouse wheel to scroll out, so you see the matrix image smaller then the window.
3. add ROI and have it cover the whole image
4. right-click to choose Intensity Profile and pick the stats you want.

Dose this work for your case?

CP




Dear CP,

How do I code the steps above with LT?

---
Andrey
cpyang Posted - 07/21/2021 : 7:40:57 PM
You can easily add ROI to cover the whole matrix by zoom-out.
1. change to image view
2. hold A key and mouse wheel to scroll out, so you see the matrix image smaller then the window.
3. add ROI and have it cover the whole image
4. right-click to choose Intensity Profile and pick the stats you want.

Dose this work for your case?

CP
snowli Posted - 07/21/2021 : 5:17:07 PM
Hi Andrey,

I added ORG-24011 for our developer to check.
For now, could you check if using the Intensity profile (i replied) works for u since it will give stats for each object of matrix sheet. I think it's easier than converting to xyz first since as u reported, it only does one object at a time so u need some coding.

Please also check if u want other stats quantities.

Thanks, Snow
AKazak Posted - 07/21/2021 : 4:03:13 PM
quote:
Originally posted by cpyang

Our current plan for 2022 is as follows:

1. Image View, add ROI, status bar will show stats for points inside ROI, similar to showing stats for data cells selection in worksheet

2. Data View, select the cells, and it will work the same as worksheet. To see stats for whole matrix, Cltr+A or click outside so no cell is selected.

Is that good enough?

CP




1 and 2 are great must-haves.

However, it would be useful to get Descriptive Statistics (reports and plots) for each matrix object separately.

Currently, I convert each matrix object to a separate worksheet and run Descriptive Statistics for each worksheet. This requires moderate coding, though.


---
Andrey
cpyang Posted - 07/21/2021 : 3:09:42 PM
Our current plan for 2022 is as follows:

1. Image View, add ROI, status bar will show stats for points inside ROI, similar to showing stats for data cells selection in worksheet

2. Data View, select the cells, and it will work the same as worksheet. To see stats for whole matrix, Cltr+A or click outside so no cell is selected.

Is that good enough?

CP
snowli Posted - 07/21/2021 : 2:57:47 PM
I see. U want to get stats of one matrix object.
For that, here is how to do it:
1. Use mini toolbar or choose View: Image mode to show image view of matrix.
2. Click the rectangle tool on left side to draw region of interest. U will need to expand it to cover all image.
3. Right click and choose Intensity Profile...

Thanks, Snow
AKazak Posted - 07/21/2021 : 12:33:59 PM
quote:
Originally posted by snowli

See Analysis: Descriptive Statistics... menu with Matrix window active.

Thanks, snow



Dear Snow,

I tried, but found that this calculates summary statistics over the matrixsheet, that is includes all its matrix objects in the analysis.

---
Andrey
snowli Posted - 07/21/2021 : 12:29:38 PM
See Analysis: Descriptive Statistics... menu with Matrix window active.

Thanks, snow

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000