User Defined Functions

[Gabe Chan]

I'm working on a project that involves two-way analysis of election results from the past 6 elections. To do the analysis I need to find the midmean of a data set. The midmean is the average of the values between the first quartile (25th percentile) and the third quartile (75th percentile). Is there any way to create a user defined function that carries out this process?
Also, if there is no way to create a user defined function, would it be possible to use a macro that would take an input of data, order it, find the quartiles and then find the mean of the values between the quartiles.
In addition, would it be easier to make user defined functions on Microsoft Access?

Thank you,
Gabe Chan
(e-mail address removed)

 

[Stephen Bye]

Use the TRIMMEAN function.

I'm working on a project that involves two-way analysis of election

results from the past 6 elections. To do the analysis I need to find the
midmean of a data set. The midmean is the average of the values between the
first quartile (25th percentile) and the third quartile (75th percentile).
Is there any way to create a user defined function that carries out this
process?

Also, if there is no way to create a user defined function, would it be

possible to use a macro that would take an input of data, order it, find the
quartiles and then find the mean of the values between the quartiles.