Dear Erik, There may be more elegant solutions, but try this:
a. Create a data frame with your data, for example data <- data.frame(agegrp, y1994, y1995, y1996) b. Then use the which function: as.character(aa$agegrp[which(aa$y1994==23)]) Hope it helps, José Prof. José Iparraguirre Chief Economist Age UK -----Original Message----- From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Erik B Svensson Sent: 12 January 2015 10:33 To: r-help@r-project.org Subject: [R] Calculate the median age interval Hello I've got a problem I don't know how to solve. I have got a dataset that contains age intervals (age groups) of people and the number of persons in each age group each year (y1994-y1996). The number of persons varies each year. I only have access to the age intervals, not the age of each person, which would make things easier. I want to know the median age interval (not the median number) for each year. Let's say that in y1994 23 corresponds to the median age interval "45-54", I want to "45-54" as a result. How is that done? This is the sample dataset: agegrp <- c("<1","1-4","5-14","15-24","25-34","35-44","45-54","55-64","65-74","75-84","84-") y1994 <- c(0,5,7,9,25,44,23,32,40,36,8) y1995 <- c(2,4,1,7,20,39,32,18,21,23,5) y1996 <- c(1,3,1,4,22,37,41,24,24,26,8) I look forward to your response Best regards, Erik Svensson [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. www.ageuk.org.uk Age UK Group Age UK is a registered charity and company limited by guarantee, (registered charity number 1128267, registered company number 6825798) Registered office: Tavis House, 1-6 Tavistock Square, London WC1H 9NA. For the purposes of promoting Age UK Insurance, Age UK is an Appointed Representative of Age UK Enterprises Limited. Age UK Enterprises Limited is authorised and regulated by the Financial Conduct Authority. Charitable Services are offered through Age UK (the Charity) and commercial products and services are offered by the Charity’s subsidiary companies. The Age UK Group comprises of Age UK, and its subsidiary companies and charities, dedicated to improving the lives of people in later life. Our network includes the three national charities Age Cymru, Age NI and Age Scotland and more than 160 local Age UK charities. This email and any files transmitted with it are confide...{{dropped:12}} ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
