| Author |
 Topic  |
|
|
leonard.ghr
Germany
2 Posts |
 Posted - 10/18/2024 : 12:33:11 PM
|
Hi everyone,
for a project, I need to calculate the mean values of individual matric objects. I have a matrix book, which contains a matrix sheet consisting of 972 quadratic matrix-objects. I spent several hours using origins help pages as well as chat gpt but I just can't get this to work. In the end I want a matrix- or workbook sheet that contains one column and 972 rows, each filled with the mean value of the corresponding matrix object. This can be performed either using a simple F(x) function in the top of a standard column, the set values function of the output matrix or the command window.
For most of you, this is probably straight forward, but I just find the matrix-related syntax really confusing.
Thanks for your help in advance,
Leonard
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2023b (64-bit) SR1
10.0.5.157 (Home-use)
Operating System: Windows 11 |
|
|
NicholasSupport
USA
45 Posts |
Posted - 10/18/2024 : 1:27:14 PM
|
Hi Leonard,
I have good news for you! The "Statistics on Columns" feature should allow you to do this as it treats Matrix-objects similarly to columns of a worksheet.
You can try following:
1. With the matrix window active, select the button as in the image above.
2. In the "Data Range" field, it should say something like [MBook1]MSheet1!1. Simply adjust this to "[MBook1]MSheet1!1:0". Adding the "1:0" to the end of it tells Origin to select from 1st to last matrix objects
3. Go to Quantities tab to clear all checkboxes under Moments and Quantiles and only check Mean
4. Switch to the Output tab. Under "Report Tables", set Book to <none>. Under "Quantities", set Book to <new>. (Note: Such output cannot be written directly to the Matrixbook).
5. Click OK!
--> The report is created.
Let me know if you have any questions.
Best,
Nicholas G.
nicholas@originlab.com
OriginLab Technical Support Team |
 |
|
|
leonard.ghr
Germany
2 Posts |
Posted - 10/20/2024 : 11:31:08 AM
|
Hi Nicholas,
thanks a lot for you help!
This procedure worked out perfectly.
Best,
Leonard
quote:
Originally posted by NicholasSupport
Hi Leonard,
I have good news for you! The "Statistics on Columns" feature should allow you to do this as it treats Matrix-objects similarly to columns of a worksheet.
You can try following:
1. With the matrix window active, select the button as in the image above.
2. In the "Data Range" field, it should say something like [MBook1]MSheet1!1. Simply adjust this to "[MBook1]MSheet1!1:0". Adding the "1:0" to the end of it tells Origin to select from 1st to last matrix objects
3. Go to Quantities tab to clear all checkboxes under Moments and Quantiles and only check Mean
4. Switch to the Output tab. Under "Report Tables", set Book to <none>. Under "Quantities", set Book to <new>. (Note: Such output cannot be written directly to the Matrixbook).
5. Click OK!
--> The report is created.
Let me know if you have any questions.
Best,
Nicholas G.
nicholas@originlab.com
OriginLab Technical Support Team
|
|
|
| |
Topic |
|
|
|
Calculate Mean Value of several Matrix objects