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
 Input cell variable in Linear fit dialog

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
sreekarorigin Posted - 02/17/2021 : 2:13:40 PM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2021 (64-bit)
9.8.0.200 (Learning Edition)

Operating System: Windows 10 64 bit

Dear all,
For a linear fit analysis, I need to input a cell value from a worksheet as a fixed intercept value in the "Fit Control" tab of "Linear Fit" dialog. I need to check how the linear fit changes by manually varying the intercept value from the worksheet. Please suggest how to do this, if it is possible to do so.

sincerely yours,

Sreekar Guddeti
Graduate Student
Indian Institute of Science Bangalore
3   L A T E S T    R E P L I E S    (Newest First)
YimingChen Posted - 02/18/2021 : 08:54:29 AM
You can add two lines of code to put R value in a User Defined column label row.

wks.userparam(++Rvalue); 
col(D)[D1]$ = $(fitLR.r);


Please also refer to the fitLR Xfunction:
https://www.originlab.com/doc/X-Function/ref/fitLR

James
sreekarorigin Posted - 02/18/2021 : 08:08:05 AM
Dear James,
Thanks for the solution. It worked . In addition to the access to linear fit function from Set Column Values dialog, I need the function that calculates the residual sum of squares (RSS). Currently I am creating new column C to calculate the RSS using

sum((rData - rLF)^2)

I tried finding an appropriate function in the "Search and Insert Functions" dialog but was not successful. Could you suggest how to directly get RSS through LT script, if it is possible?



sincerely yours,


Sreekar Guddeti
Graduate Student
Indian Institute of Science Bangalore
YimingChen Posted - 02/17/2021 : 3:09:42 PM
You can probably use Set Column Value(SCV) feature in Origin. See the picture below, put the intercept value in C1, open SCV dialog of col(D), put the script in.

range r1 = col(C);
fitLR iy:=(1,2) fixint:=1 intercept:=r1[1] oy:=col(D);

Then you can change the intercept value and the fitting result gets updated.


James

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