Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP Equivalent of Excel LOGEST() Function?
Message
De
22/11/2001 08:12:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
22/11/2001 01:45:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00584819
Message ID:
00584881
Vues:
37
>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)
  • Précédent
    Suivant
    Répondre
    Fil
    Voir

    Click here to load this message in the networking platform