# Web Development

## General discussion

Locked

### mode and median in Access reports

By ·
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.

Thread display: Collapse - | Expand +

Collapse -

### mode and median in Access reports

by 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 In reply to mode and median in Access ...

Collapse -

### mode and median in Access reports

by 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 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 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 In reply to mode and median in Access ...

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

## Related Discussions

• 21

• 10

• 1

#### Help with hosting a web server

Harry_TheKing1 ·

• 0

#### What are the top 5 programming languages for web development?

escalesolutions2 ·

• 2

#### Office 365 DNS Records

alexis1606845310 ·