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
 All Forums
 Origin Forum
 Origin Forum
 Averaging close value numbers

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
SG-sci Posted - 03/10/2024 : 09:43:22 AM
Hi All,

I need to average radius sizes (ColA) that have values close to each other and their corresponding intensity values (ColB). See example in the screenshot.
What would be the fastest way to do this in Origin instead of manually selecting ranges and calculating the mean?
The real dataset is large and I'm looking for an option to speed up data processing. I'd appreciate advices on this.
Thank you in advance.
1   L A T E S T    R E P L I E S    (Newest First)
YimingChen Posted - 03/11/2024 : 08:35:09 AM
Select menu Worksheet->Remove/Combine Duplicated Rows.... In the dialog, check the box Duplicate Tolerance and set a value. And also set Merge Duplications by to Average.

James

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