Thanks for the reply PH.
I hope I can clarify exactly what I need help with.
I can code an algorithm for calculating the median:
sort by award then
take the middle value if there are an odd number of values or the mean of the two middle values if there are an even number of values
So that...
I am writing a statistical report for a weekly reporting database and need to include the median as well as the average in the report. The SQL for the report is:
SELECT vw_a.Assessor, Count(vw_a.Award) AS CountOfAward, Avg(vw_a.Award) AS AvgOfAward, Max(vw_a.Award) AS MaxOfAward...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.