I'll try but I know the result is going to suck. Do you remember the calculation itself? I used to, but the STD() function spoiled me.
How about a cursor instead of an array....
>The Std Dev calculation is going to be a killer anyway..
>
>>I thought of that but this routine is called potentially hundreds of times in a single method call and the i/o would kill the app.
>>
>>>Why don't you take the contents of the array and jam it into a cursor?
>>>
>>>>Hi All.
>>>>
>>>>I'm in a bit of a problem here. I need to compute the standard deviation on an array of values. I know it's easy to do it on table data: CALCULATE STD(numfield). But what is the actual textbook formula? Anyone got a mathematics textbook handy or a darn good memory?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05