Access -- calculate "median" and "mode"
Please find attached two files:
1. "Example Data -- Statistics" (Excel)
2. "Mean, StDev, Var" (Access)
The Excel file contains the following five stats:
I've imported the 10 values (B1:B10) into Table1 of the Access file. In Query1, the mean, stdev, and variance can be easily derived.
My question: How can I compute/calculate the **median** and **mode** in the database?
Note: Please keep in mind that I'm currently (in the actual database) using a SQL statement that re-generates queries for other input. That said, if VBA is required for the calculation of these two statistical measures of dispersion, I need to be able to "call that function" from within Query1 in order to dynamically create/update other queries.
Ideally, any proposed solution includes a working query1 that includes these two measures.