[DeTomaso] NPT does anyone have a 2nd order least squares curve fit program handy?

[Ken Green]

Dave,
 
    I tried the excel trend line and the fit is lousy, I tried both 2nd and 4th order.  Maybe it's just lousy data and doesn't fit well.  Do you think the excel trendline is a good fit? 
 
Ken


________________________________
From: "davel at emspace.com" <davel at emspace.com>
To: Ken Green <kenn_green at yahoo.com>; Pantera List Serve <detomaso at realbig.com> 
Sent: Thursday, July 12, 2012 11:42 AM
Subject: RE: [DeTomaso] NPT does anyone have a 2nd order least squares curve fit program handy?


Here's some stuff from excel apps Ken.
These equations assume that your sheet has two named ranges: x and y.
I think you want 2nd Order Polynomial Trendline


Linear Trendline
Equation: y = m * x + b
m: =SLOPE(y,x)
b: =INTERCEPT(y,x)

Logarithmic Trendline
Equation: y = (c * LN(x)) - b
c: =INDEX(LINEST(y,LN(x)),1)
b: =INDEX(LINEST(y,LN(x)),1,2)

Power Trendline
Equation: y=c*x^b
c: =EXP(INDEX(LINEST(LN(y),LN(x),,),1,2))
b: =INDEX(LINEST(LN(y),LN(x),,),1)

Exponential Trendline
Equation: y = c *e ^(b * x)
c: =EXP(INDEX(LINEST(LN(y),x),1,2))
b: =INDEX(LINEST(LN(y),x),1)

2nd Order Polynomial Trendline
Equation: y = (c2 * x^2) + (c1 * x ^1) + b
c2: =INDEX(LINEST(y,x^{1,2}),1)
C1: =INDEX(LINEST(y,x^{1,2}),1,2)
b = =INDEX(LINEST(y,x^{1,2}),1,3)

3rd Order Polynomial Trendline
Equation: y = (c3 * x^3) + (c2 * x^2) + (c1 * x^1) + b
c3: =INDEX(LINEST(y,x^{1,2,3}),1)
c2: =INDEX(LINEST(y,x^{1,2,3}),1,2)
C1: =INDEX(LINEST(y,x^{1,2,3}),1,3)
b: =INDEX(LINEST(y,x^{1,2,3}),1,4)

Higher Order Polynomial Trendline
 

-------- Original Message --------
>Subject: [DeTomaso] NPT does anyone have a 2nd order least squares
>curve fit program handy?
>From: Ken Green <kenn_green at yahoo.com>
>Date: Thu, July 12, 2012 2:13 pm
>To: Pantera List Serve <detomaso at realbig.com>
>
>I haven't had to do this for a LONG time, just need to run it for about 6 points.  
>
>