Solved

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

Posted on 2002-03-13
9
1,477 Views
Last Modified: 2007-11-27
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
Comment
Question by:SBFurr
9 Comments
 
LVL 57
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

by:SBFurr
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

by:SBFurr
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
ID: 6865145
Sasha,

  Yes, that's my understanding.

Jim.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:SBFurr
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

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

Author Comment

by:SBFurr
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

by:nico5038
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
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
LVL 6

Accepted Solution

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

** Mindphaser - Community Support Moderator **
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now