>>>I'm looking for a subroutine that will perform a regression analysis on data in a Foxpro table. Anyone have any suggestions of where to look? Thanks...
>>
>>The "best fit" is defined as the line where the squares of the distances of the individual data points, from the resulting line, is at a minimum.
>>
>>Excel help, for the corresponding functions, explains how Excel does the calculation.
>
>Perhaps Paul could use Excel with automation to effectively do regression analysis from VFP?
That is another alternative, for very complicated formulae. However, I think that in this particular case, the formulae can be figured out in VFP, which would be more efficient.
Saludos,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)