Solved

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

Posted on 2002-03-13
1,487 Views
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
Question by:SBFurr
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 57

Expert Comment

ID: 6864406
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 Comment

ID: 6864569
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 Comment

ID: 6864663
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

LVL 57

Expert Comment

ID: 6865145
Sasha,

Yes, that's my understanding.

Jim.
0

Author Comment

ID: 6868872
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

LVL 2

Expert Comment

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

Author Comment

ID: 6882739
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

LVL 54

Expert Comment

ID: 7049607
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

LVL 6

Accepted Solution

Mindphaser earned 0 total points
ID: 7070247
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
###### Suggested Courses
Course of the Month6 days, 14 hours left to enroll