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
 Getting exact values of polynomial fit

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
bur2000 Posted - 10/18/2013 : 06:42:17 AM
Origin Ver. and Service Release (Select Help-->About Origin): 8.6
Operating System: Win 7

I did a 9th order polynomial fit and Origin did output the fitting parameters B1-B9. The fit worked well, the values calculated by Origin are very close to the original values.

However, when I use the parameters in Excel the calculated values differ significantly from those in Origin. It's not a problem in Excel, I used a pocket calculator and got the same wrong results.

Here's the parameter table from Origin:

Intercept 17.54397
B1 1.23021
B2 0.05444
B3 -0.01853
B4 0.00163
B5 -7.70248E-5
B6 2.15435E-6
B7 -3.58271E-8
B8 3.27741E-10
B9 -1.27133E-12

For x = 10.04374 Origin gets 27.2526715364701, but I get 27.20678141 (using Intercept + B1*x^1 + B2*x^2 and so on).

I guess the Bx values in the report table are not the values actually used by Origin, but rounded ones. Is that so and how can I access the exact values Origin used? I need these for some calculation in Excel.

Thanks.
2   L A T E S T    R E P L I E S    (Newest First)
bur2000 Posted - 10/21/2013 : 07:04:23 AM
Thanks a lot, that was exactly what I was looking for!
greg Posted - 10/18/2013 : 08:53:39 AM
High order polynomials vary significantly with only minor changes to significant digits of input values...

Click the drop-down button next to Parameters on your Report sheet and choose "Create Copy as New Sheet".
Double click the top of the Value column to open Column Properties.
Set Digits to "Significant Digits=" and enter 15 for Significant Digits and click OK.

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