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
 I can nor use "reduce by group" function

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
edwardclhuang Posted - 06/19/2012 : 04:25:36 AM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 8.6.0
Operating System:Win 7

Dear OriginLab

I have two columns of data:

A11 B11
A12 B12
A13 B13
A21 B21
A22 B22
.
.
.

Now I want to reduce them by an average by every 3 points. I try to use "reduce by group" function, but when I select the data, it shows "X coordinates of the curve are not monotonic." How can I do it then?

Thanks for reply in advance.

Chien-Lung Huang
3   L A T E S T    R E P L I E S    (Newest First)
Hideo Fujii Posted - 06/20/2012 : 09:31:07 AM
Hi Chien-Lung,

I'm sorry for having missed what you originally said about averaging.

Changing the designation of first column from X to Y has made the "reduce by group" work because, I think, Origin takes the index (i.e., row number, which is, of course a number, and monotonic) as the X dataset (at the left of Y's).

--Hideo Fujii
OriginLab
edwardclhuang Posted - 06/20/2012 : 08:41:04 AM
I upgrade it, but it shows right now "You must have numeric data to run this analysis".

Your suggestion will not work in my case, since I need to average A11+A12+A13. The way you suggest will left A13 after wards.

Anyway, I have successfully done it by a strange way. Initially, I have A(x) and B(y). I set A(x) as A(y), which means I don't have any x-variable in my worksheet. Then it works!!!

Share to other users who might face the same problem and again thank you for the reply.

All the best,

Chien-Lung
Hideo Fujii Posted - 06/19/2012 : 5:59:21 PM
Hi Chien-Lung Huang,

If you upgrade your Origin 8.6 to its SR3 (by "Check for Updates"), you get a better error message: "You must have numeric data to run this analysis". So, this is the reason literally.

If you simply want to extract the data every 3 points, you can choose "Worksheet: Reduce Rows: menu, and choose "Delete N Rows, then Skip M rows" for the Reduce Method, and set 2 to Delete Rows and 1 to Skip Rows.

Does this solve your problem?

--Hideo Fujii
OriginLab

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