• Status: Solved
• Priority: Medium
• Security: Public
• Views: 1527

# Is there an Access function equivalent to the Quartile function in Excel?

Does anyone know if there is a built-in function for Access that is equivalent to the quartile function in excel?
If not, any ideas on how to recreate it?

I am thinking
quartile 0 = min
quartile 1 = sum of range * .25
quartile 2 = sum of range * .50
quartile 3 = sum of range * .75
quartile 4 = max

Sasha
0
SBFurr
1 Solution

President / OwnerCommented:
Sasha,

There is nothing compareable in Access except for Min and Max, which would give you the lowest/highest value respectively.

This:

quartile 1 = sum of range * .25
quartile 2 = sum of range * .50
quartile 3 = sum of range * .75

Won't work as that's not what a quartile is.  Given:

1,2,4,7,8,9,10,12

The 1st quartile is 3.5.  My understanding of what a quartile is is that its the median of the lower half of a set of data.

In this case we have 8 numbers, 7 is the median and half of that is 3.5.  The 3rd quartile would be 10.5

Help?
Jim.

0

Author Commented:
So,
assuming the data is sorted in ascending order
I could take the first half of the range (based on a record count) and find the median to get the 25% quartile.

then do the same with the upper half for the 75% quartile.?

I'll go test it.
thanks :)

Sasha

0

Author Commented:
So,
assuming the data is sorted in ascending order
I could take the first half of the range (based on a record count) and find the median to get the 25% quartile.

then do the same with the upper half for the 75% quartile.?

I'll go test it.
thanks :)

Sasha

0

President / OwnerCommented:
Sasha,

Yes, that's my understanding.

Jim.
0

Author Commented:
I did some reading into quartiles.
apparently it isn't just a percentage, but a median value.
I have a very scary looking equation from the statistics book here that I will try... so as I  finish a project that is due today!

I'll get back to this monday.

Sasha
0

Commented:
Can't you reference the Excel object library, and use it from there?
Carl
0

Author Commented:
My problem doing that is that the Excel function requires I pass it a range of cells.  I cant' think of a way to pass that info from an Access query.

ideas?

Sasha
0

Commented:
for SBFurr

No comment has been added for the last two months.
So it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- PAQ'd and pts refunded
next seven days.

Nic;o)
0

Commented:
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.