Solved

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

Posted on 2002-03-13
9
1,478 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 57
ID: 6865145
Sasha,

  Yes, that's my understanding.

Jim.
0
 

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

786 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