>>>>>>Can anyone direct me to any statistical generation methods/functions for VFP?
>>>>>>
>>>>>>I'd like to know:
>>>>>>
>>>>>>Mean,Mode,Median,High/Low,Std Dev...stuff like that.
>>>>>>
>>>>>>TIA,
>>>>>>
>>>>>>/Chris
>>>>>
>>>>>You can get average and standard deviation (as well as some others) by using CALCULATE. Check the help file for details.
>>>>
>>>>George,
>>>>
>>>>I was able to generate all I need but median. Anything for that?
>>>>
>>>>/Chris
>>>"Median" ? Is it the value sitting in middle in a series ? If so and number of elements <= 65000 a simple way might be :
>>>

select myValue into array myArray where !isnull(myValue)
>>>if type("myArray") # "U"
>>> if alen(myArray,1) > 1
>>>    return myArray[floor(alen(myArray,1)/2) + 1]
>>> else
>>>    return myArray[1]
>>> endif
>>>endif
>>>return .null.

>>
>>Hi Cetin,
>>
>>Median is a value in a series of numbers where there are an equal number of values less than and greater than. Not knowing if there may be duplicate values makes this a bit harder. I'd try for the arithmetic mean (by getting the minimumand maximum values via CALCULATE) as a starting point. Where to go from there, I haven't figured out.:-)
>
>Sounds like Value in the middle in an ordered series. I can't say I understood honestly :( Bruce is a statistician :)
>Cetin

I'm certainly not.:-) See his reply to me.< g >