General discussion

Locked

mode and median in Access reports

By john_wills ·
I can get mean and standard deviation of a column in an Access report by calling built-in functions. There seem to be no parallel functions for mode and median. How do I produce these statistics? I have an idea it may be doable via SQL, but the necessary grouping would lose me my output for the individual cases.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

mode and median in Access reports

by archimede In reply to mode and median in Access ...

If you have a budget for this, have a look at

http://www.fmsinc.com/products/statistics/productguide.htm

I have not used it, but it might be what you're looking for.

Regards.

Alessandro

Collapse -

by john_wills In reply to mode and median in Access ...

Poster rated this answer.

Collapse -

mode and median in Access reports

by A. Square In reply to mode and median in Access ...

Median is found by:

Sort the elements.
Count the elements in a sample array and dividing by 2 (Same count above as below).
If the result is a whole number (x), then the median is equal to the xth element in the array when sorted.
If the result (x) is a decimal (16.5) then you find the average of element 16 and 17.

Collapse -

mode and median in Access reports

by A. Square In reply to mode and median in Access ...

>>"If the result (x) is a decimal (16.5) then you find the average of element 16 and 17."

Sorry what I meant to say was
If the result (x) is a decimal (16.5 for example) then you find the average of elements (x-0.5 and x+0.5, in this case the 16th and 17th elements in the array)

Collapse -

mode and median in Access reports

by john_wills In reply to mode and median in Access ...

This I knew already: the problem is to get the calculation done in an Access report. My inclination is to transfer everything to Excel, insert mode and median there, then move the augmented array back to Access for the report, but something easier may be available - something more Access-ish.

Collapse -

by john_wills In reply to mode and median in Access ...

This question was auto-closed because it is 90 days old

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums