Third Quartile

[haviv]

Hi I have a question on how to create query to calculate third quartile on a
defined array

My field is as follow

week office number time
1 SIN 80000001 60
1 SIN 80000002 40
1 MAL 80000003 80
1 MAL 80000004 50
1 MAL 80000005 90
2 SIN 80000006 70
2 SIN 80000007 80
2 MAL 80000008 90
2 MAL 80000009 40
3 MAL 80000010 50
3 SIN 80000011 90
3 SIN 80000012 70
3 MAL 80000013 80

And the defined array is I need quartile result for turn time based on week
and office. ie I should get quartile result for week 1 SIN, week 1 MAL, week
2 SIN, week 2 MAL and so on.

I can do this in excel using quartile and array grouping but find
difficulties to get quartile result (first, second and third) for above
defined array in access. I have look the answer for percentile and median,
but find it difficult to calculate quartile. Quartile in statistic defined
the same as percentile but the percentage is 25% for first quartile, 50% for
second quartile and 75% for third quartile

Any one can help me please

Sincerely Yours
Haviv

 

[James A. Fortune]

Hi I have a question on how to create query to calculate third quartile on a
defined array

My field is as follow

week office number time
1 SIN 80000001 60
1 SIN 80000002 40
1 MAL 80000003 80
1 MAL 80000004 50
1 MAL 80000005 90
2 SIN 80000006 70
2 SIN 80000007 80
2 MAL 80000008 90
2 MAL 80000009 40
3 MAL 80000010 50
3 SIN 80000011 90
3 SIN 80000012 70
3 MAL 80000013 80

And the defined array is I need quartile result for turn time based on week
and office. ie I should get quartile result for week 1 SIN, week 1 MAL, week
2 SIN, week 2 MAL and so on.

I can do this in excel using quartile and array grouping but find
difficulties to get quartile result (first, second and third) for above
defined array in access. I have look the answer for percentile and median,
but find it difficult to calculate quartile. Quartile in statistic defined
the same as percentile but the percentage is 25% for first quartile, 50% for
second quartile and 75% for third quartile

Any one can help me please

Sincerely Yours
Haviv

See:

http://groups.google.com/group/microsoft.public.access/msg/d4eed6cd6f6d7846

Maybe use [week] & [office] as your group.

James A. Fortune
(e-mail address removed)

 

[haviv]

Hi James,

Thank you. But i am not quite understand after reading said message. Could
you rewrite again the code. I am sorry but I am quite rookie in SQL database.
I
--
Sincerely Yours
Haviv

Hi I have a question on how to create query to calculate third quartile on a
defined array

My field is as follow

week office number time
1 SIN 80000001 60
1 SIN 80000002 40
1 MAL 80000003 80
1 MAL 80000004 50
1 MAL 80000005 90
2 SIN 80000006 70
2 SIN 80000007 80
2 MAL 80000008 90
2 MAL 80000009 40
3 MAL 80000010 50
3 SIN 80000011 90
3 SIN 80000012 70
3 MAL 80000013 80

And the defined array is I need quartile result for turn time based on week
and office. ie I should get quartile result for week 1 SIN, week 1 MAL, week
2 SIN, week 2 MAL and so on.

I can do this in excel using quartile and array grouping but find
difficulties to get quartile result (first, second and third) for above
defined array in access. I have look the answer for percentile and median,
but find it difficult to calculate quartile. Quartile in statistic defined
the same as percentile but the percentage is 25% for first quartile, 50% for
second quartile and 75% for third quartile

Any one can help me please

Sincerely Yours
Haviv

See:

http://groups.google.com/group/microsoft.public.access/msg/d4eed6cd6f6d7846

Maybe use [week] & [office] as your group.

James A. Fortune
(e-mail address removed)

 

[James A. Fortune]

Hi James,

Thank you. But i am not quite understand after reading said message. Could
you rewrite again the code. I am sorry but I am quite rookie in SQL database.
I

See if the following helps:

http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/1789b9f773475c5a

James A. Fortune
(e-mail address removed)