Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Equivalent of Excel LOGEST() Function?
Message
From
22/11/2001 08:12:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
22/11/2001 01:45:51
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00584819
Message ID:
00584881
Views:
36
>In Excel LOGEST() is used to perform exponential regression on a set of data points. If worst came to worst I could automate Excel, but I'd rather avoid it:
>
>- its accuracy is doubtful (www.npl.co.uk/npl/publications/news/ise/countingonit_issue9.pdf)
>- Excel may not be available
>
>Has anyone implemented anything like this in VFP? Is there an external library/.DLL callable from VFP? I've started to look into BLAS and the Intel MKL but they look like vast overkill.
>
>TIA.

If you know how to do a linear regression in VFP (I don't), you might be able to do something similar to the following:

  • Take the natural logarithm of every data item,
  • Do the linear regression on the result,
  • Take the anti-logarithm (exp()) of the result or result set.

    HTH, 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)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform