| 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 |
