Re: [R] Quantiles of data in a contingency table

From: Markus Jäntti <markus.jantti_at_iki.fi>
Date: Thu 17 Mar 2005 - 19:29:16 EST

Matt Mohebbi wrote:
> Hello,
>
> I have data of the following form:
>
>

>>data <- data.frame(type=c("c","d","e"), size=c(10,20,30), count=c(20,10,5))
>>data

>
> type size count
> 1 c 10 20
> 2 d 20 10
> 3 e 30 5
>
> I would like to compute the quantiles of size given the counts. For
> instance, in this example, the median size would be 10. Is there an
> easy way of doing this?

One at least is to the function wtd.median [and wtd.quantile] in package Hmisc by Frank Harrell.

install.packages("Hmisc")
library(Hmisc)
wtd.median(data$size, data$weights)

is likely a route to get you what you want.

regards,

markus
>
> Is there a good way to deal with data in this format in general? Much
> of R seems to center around having an entry for each item. This
> question (http://www.r-project.org/nocvs/mail/r-help/2000/0102.html)
> seems to be related but no one provided an answer.
>
> Thanks,
> Matt
>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>

-- 
Markus Jantti
Abo Akademi University
markus.jantti@iki.fi
http://www.iki.fi/~mjantti

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Received on Thu Mar 17 19:35:29 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:30:50 EST