Anyone know of a VFP friendly Least Square Regression Routine? Free is
good.
TIA
George
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPpp0hXfC+jTOEcR7jKXLFpS6uEuix7-CT0b=TTV5WeSJxZXgQ@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
I did write one some years ago but can't lay my hands on it at the moment.
There's a VB example at http://www.a1vbcode.com/app-3220.asp just open up the .vb class file to see the class code if you haven't got visual studio. It gives you lots more than you need but you should be able to pull the bits out of it. Personally I'd write it from scratch.
Dave
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf Of G Gambill
Sent: 25 November 2011 13:30
To: ProFoxTech List
Subject: VFP and Least Squared Regression
Anyone know of a VFP friendly Least Square Regression Routine? Free is good.
TIA
George
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/BD031ECABF2B60499200AAB3DBB4A999921BCD1C@EX-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Here is a simple explanation of the constants a and b you will need to calculate any point on the line.
http://www.efunda.com/math/leastsquares/lstsqr1dcurve.cfm
I presume you are familiar with the Sigma mathematical operator.
Dave
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf Of G Gambill
Sent: 25 November 2011 13:30
To: ProFoxTech List
Subject: VFP and Least Squared Regression
Anyone know of a VFP friendly Least Square Regression Routine? Free is good.
TIA
George
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/BD031ECABF2B60499200AAB3DBB4A999921BCD30@EX-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Not free, but close . . . .
http://www.downloadatlas.com/visual_foxpro/visual-fitting-by-graphnow.html
John Harvey
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf
Of Dave Crozier
Sent: Friday, November 25, 2011 10:16 AM
To: ProFox Email List
Subject: RE: VFP and Least Squared Regression
Here is a simple explanation of the constants a and b you will need to
calculate any point on the line.
http://www.efunda.com/math/leastsquares/lstsqr1dcurve.cfm
I presume you are familiar with the Sigma mathematical operator.
Dave
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf
Of G Gambill
Sent: 25 November 2011 13:30
To: ProFoxTech List
Subject: VFP and Least Squared Regression
Anyone know of a VFP friendly Least Square Regression Routine? Free is
good.
TIA
George
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/066b01ccab93$45367200$cfa35600$@shelbynet.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Thanks, this should get me started.
On Fri, Nov 25, 2011 at 9:09 AM, Dave Crozier <DaveC@flexipol.co.uk> wrote:
> I did write one some years ago but can't lay my hands on it at the moment.
>
> There's a VB example at http://www.a1vbcode.com/app-3220.asp just open up
> the .vb class file to see the class code if you haven't got visual studio.
> It gives you lots more than you need but you should be able to pull the
> bits out of it. Personally I'd write it from scratch.
>
> Dave
>
>
>
> -----Original Message-----
> From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On
> Behalf Of G Gambill
> Sent: 25 November 2011 13:30
> To: ProFoxTech List
> Subject: VFP and Least Squared Regression
>
> Anyone know of a VFP friendly Least Square Regression Routine? Free is
> good.
>
> TIA
>
> George
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPpp0hWJgPF=6GRr4=TXLhV9zMeQxyq+AkQnQ8Mos0A9Z5e2aw@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
George,
If you have problems just frop me a note here or personal and I'll sort it out for you...
Do you want to send a two dimensional array of data points into it or a table of values?
This lends itself nicely to a non visual class and shouldn't take more than 20 mins or so to sort out.
Dave
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf Of G Gambill
Sent: 25 November 2011 17:04
To: profox@leafe.com
Subject: Re: VFP and Least Squared Regression
Thanks, this should get me started.
On Fri, Nov 25, 2011 at 9:09 AM, Dave Crozier <DaveC@flexipol.co.uk> wrote:
> I did write one some years ago but can't lay my hands on it at the moment.
>
> There's a VB example at http://www.a1vbcode.com/app-3220.asp just open
> up the .vb class file to see the class code if you haven't got visual studio.
> It gives you lots more than you need but you should be able to pull
> the bits out of it. Personally I'd write it from scratch.
>
> Dave
>
>
>
> -----Original Message-----
> From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On
> Behalf Of G Gambill
> Sent: 25 November 2011 13:30
> To: ProFoxTech List
> Subject: VFP and Least Squared Regression
>
> Anyone know of a VFP friendly Least Square Regression Routine? Free
> is good.
>
> TIA
>
> George
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept) text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/BD031ECABF2B60499200AAB3DBB4A999921BCEE9@EX-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
John,
I think the good old SEO's gratuitously added the Visual Foxpro onto that product. From what I see there is nothing to do with VFP there!
Dave
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf Of john harvey
Sent: 25 November 2011 16:57
To: 'ProFox Email List'
Subject: RE: VFP and Least Squared Regression
Not free, but close . . . .
http://www.downloadatlas.com/visual_foxpro/visual-fitting-by-graphnow.html
John Harvey
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf Of Dave Crozier
Sent: Friday, November 25, 2011 10:16 AM
To: ProFox Email List
Subject: RE: VFP and Least Squared Regression
Here is a simple explanation of the constants a and b you will need to calculate any point on the line.
http://www.efunda.com/math/leastsquares/lstsqr1dcurve.cfm
I presume you are familiar with the Sigma mathematical operator.
Dave
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf Of G Gambill
Sent: 25 November 2011 13:30
To: ProFoxTech List
Subject: VFP and Least Squared Regression
Anyone know of a VFP friendly Least Square Regression Routine? Free is good.
TIA
George
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/BD031ECABF2B60499200AAB3DBB4A999921BCEF9@EX-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
> Anyone know of a VFP friendly Least Square Regression Routine? Free is
> good.
>
If you want the coefficients of a regression line :
CREATE CURSOR test (xi n(4),yi n(4))
INSERT INTO test VALUES (1,180)
INSERT INTO test VALUES (2,182)
INSERT INTO test VALUES (3,187)
INSERT INTO test VALUES (4,188)
***
SELECT ;
AVG(xi),;
AVG(yi),;
SUM( (xi-(select AVG(xi) FROM test as hihi))* (yi-(select AVG(yi) FROM
test as haha))),;
SUM((xi-(select AVG(xi) FROM test as hihi))**2) ;
FROM test ;
INTO ARRAY atest
ca = atest(3)/atest(4)
cb = atest(2) - ca*atest(1)
***
?"Y = ca.X + cb"
?"ca = ",ca
?"cb = ",cb
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/ACECCE2BB9F54325A2C2392C37B2F87A@MuriellePC
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Thanks John. But, WOT (Web Of Trust) classifies this URL as bad in all 5
categories.
On Fri, Nov 25, 2011 at 9:57 AM, john harvey <john.harvey@shelbynet.com>wrote:
> Not free, but close . . . .
>
> http://www.downloadatlas.com/visual_foxpro/visual-fitting-by-graphnow.html
>
> John Harvey
>
> -----Original Message-----
> From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf
> Of Dave Crozier
> Sent: Friday, November 25, 2011 10:16 AM
> To: ProFox Email List
> Subject: RE: VFP and Least Squared Regression
>
> Here is a simple explanation of the constants a and b you will need to
> calculate any point on the line.
>
> http://www.efunda.com/math/leastsquares/lstsqr1dcurve.cfm
>
> I presume you are familiar with the Sigma mathematical operator.
>
> Dave
>
>
> -----Original Message-----
> From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf
> Of G Gambill
> Sent: 25 November 2011 13:30
> To: ProFoxTech List
> Subject: VFP and Least Squared Regression
>
> Anyone know of a VFP friendly Least Square Regression Routine? Free is
> good.
>
> TIA
>
> George
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPpp0hW3Ab52Kbiwpp2-O_yqTpix8N=0vYJLoyz5A+tK4bjvBA@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
This looks good. Thanks.
On Tue, Nov 29, 2011 at 10:01 PM, Gérard Lochon <g-lochon@wanadoo.fr> wrote:
>
>
>
> > Anyone know of a VFP friendly Least Square Regression Routine? Free is
> > good.
> >
>
>
> If you want the coefficients of a regression line :
>
> CREATE CURSOR test (xi n(4),yi n(4))
> INSERT INTO test VALUES (1,180)
> INSERT INTO test VALUES (2,182)
> INSERT INTO test VALUES (3,187)
> INSERT INTO test VALUES (4,188)
>
> ***
>
> SELECT ;
> AVG(xi),;
> AVG(yi),;
> SUM( (xi-(select AVG(xi) FROM test as hihi))* (yi-(select AVG(yi) FROM
> test as haha))),;
> SUM((xi-(select AVG(xi) FROM test as hihi))**2) ;
> FROM test ;
> INTO ARRAY atest
>
> ca = atest(3)/atest(4)
> cb = atest(2) - ca*atest(1)
>
> ***
>
> ?"Y = ca.X + cb"
> ?"ca = ",ca
> ?"cb = ",cb
>
>
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPpp0hU9H6GBwvZcJ=fqU+C+7px9b3zNj9aw5w4tKDkae084Gw@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.