>>Hi Ko,
>>
>>BTW, he doesn't agree with the math definition of Median function. He told me, that we can calculate median only for number of items greater than 2 (3 or more) and we have to pick up one of them, if number of items is even. Since it contradicts with math definition, I didn't agree, so we will discuss this problem in our meeting. In the past we used his own Median definition...
>

---

>Both my statistics book and my teacher told me that you are right.
>If you have an even number of items, you have to middle the two items in the middle.
>My book doesn't say anything about counts less then 3.
>My teacher told me that it then doesn't make sense to define a median.
>A median value only makes sense when you have more values.
>It is used to eliminate the extreme values.
>So in the sample values i gave you for the sql 1 and 40 are extreme values and the median value will be about 15. The average is 17,2
>
>PS. I didn't see the discussion thread about this.

See this thread: Coding, syntax & commands Re: Statistical functions in VFP6 (import) Thread #435549