Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Statistical functions
Message
From
28/10/2004 19:10:45
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
28/10/2004 19:04:59
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00955598
Message ID:
00955613
Views:
12
>Hilmar,
>
>This is exactly what I have done, simply automating excel to access the functions, in this case NORMSINV(x), works fine if a little slow.

OK.

According to the description I found in help - if I have the correct function, for I use Excel in Spanish - the function uses an iterative process.

If you know what normsinv() is the inverse of, you might do something similar in a UDF. This might run faster than Excel Automation.
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
Reply
Map
View

Click here to load this message in the networking platform