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
 Set Column Values

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
chandan11 Posted - 01/30/2017 : 03:06:38 AM
Origin Ver. and Service Release : OriginPro 2015 Sr1 b9.2.257
Operating System:Windows 10

I have two data sets. In worksheet they are put like, First data set [A(X1), B(Y1)] and second dataset [C(X2), D(Y2)].

Now in Column E I want to have ratio of data in D and data in B at common x-values.

This can also be intrepreted as ratio of (Graph of A vs B) And (Graph of C Vs D).

How can we do this in origin without manually matching the x values in every row ?

Thanks in advance.

-Chandan
2   L A T E S T    R E P L I E S    (Newest First)
chandan11 Posted - 01/30/2017 : 10:51:32 PM
Hello Hideo,

It worked perfectly. Thanks alot for the help.

-Chandan
Hideo Fujii Posted - 01/30/2017 : 12:02:51 PM
Hi Chandan,

You can try:

1) Highlight all columns, A(X1), B(Y1), C(X2), and D(Y2).
2) Choose "Analysis: Mathematics: Simple Curve Math" menu.
3) In the open tool, choose:

    Operator = Divide
    Reference Data = D(Y)
    Output = (<input>,<new>)
and click OK to run.

Now you see the ratio of curve(B)/curve(D) based on the A(X) dataset. If you want to get the result
based on C(X), you can set the Input1 branch to D(Y), and Reference Data to B(Y).

Does this procedure work for you?

--Hideo Fujii
OriginLab

P.S. In the Simple Curve Math tool's dialog, there is a check box, "Use Common Range Only". If you turn ON
this check box, it produces the result with only overlapped X range, obtained only by interpolation.
Otherwise, the output obtained contains the result of extrapolation, and you can avoid it by this check box.

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