Skip to content

MODE , VARIANCE , NTH PERCENTAILE

6 messages · Rantony, chamilka, arun +1 more

Rantony
# 
Hi,
Here i have an matrix like this,

ABC    PQR    XYZ   MNO
------   -------   ------   --------
3            6        7          15
2          12        24        15
20         5         1           2
25          50      15         35

i need to get the 
                                      "MODE" - for each column-wise
                                      "VARIANCE" - for each column-wise
                                      "25TH-PERCENTAILE" -for each
column-wise

i tried alots, and it was difficult to get. Someone can help me out please ?

- Antony                                        


--
View this message in context: http://r.789695.n4.nabble.com/MODE-VARIANCE-NTH-PERCENTAILE-tp4636112.html
Sent from the R help mailing list archive at Nabble.com.
chamilka
# 
Din't you try sapply function?
I tried it for you. 
Just convert your matrix into a data frame using as.data.frame and then 
*> rantony*
     ABC PQR XYZ MNO
[1,]   3   6   7  15
[2,]   2  12  24  15
[3,]  20   5   1   2
[4,]  25  50  15  35

*> rantony=as.data.frame(rantony)*

*> sapply(rantony,var)* #calculates column wise variance
      ABC       PQR       XYZ       MNO 
137.66667 457.58333  99.58333 185.58333 

*> sapply(rantony,Mode)*  #calculates column vise Mode, where the mode
function is available in
http://cran.r-project.org/web/packages/prettyR/index.html  prettyR  package
      ABC       PQR       XYZ       MNO 
">1 mode" ">1 mode" ">1 mode"      "15" 
# the above means there are no modes in first three columns and in the last
column Mode is 15
ABC   PQR   XYZ   MNO
0%    2.00  5.00  1.00  2.00
25%   2.75  5.75  5.50 11.75
50%  11.50  9.00 11.00 15.00
75%  21.25 21.50 17.25 20.00
100% 25.00 50.00 24.00 35.00

--
View this message in context: http://r.789695.n4.nabble.com/MODE-VARIANCE-NTH-PERCENTAILE-tp4636112p4636142.html
Sent from the R help mailing list archive at Nabble.com.
arun
# 
Hi,

Just try:?dat4<-read.table(text="
?ABC PQR XYZ MNO
?? 3? 6? 7? 15
?? 2? 12? 24? 15
?? 20? 5? 1? 2
? 25? 50? 15? 35 
?",sep="",header=TRUE)
?apply(dat4,2,quantile)
?
?apply(dat4,2,var) 

#For mode calculation, use package ?modalvalue {rattle}
A.K.

,



----- Original Message -----
From: Rantony <antony.akkara at ge.com>
To: r-help at r-project.org
Cc: 
Sent: Wednesday, July 11, 2012 3:38 AM
Subject: [R] MODE , VARIANCE , NTH PERCENTAILE

Hi,
Here i have an matrix like this,

ABC? ? PQR? ? XYZ?  MNO
------?  -------?  ------?  --------
3? ? ? ? ? ? 6? ? ? ? 7? ? ? ? ? 15
2? ? ? ? ? 12? ? ? ? 24? ? ? ? 15
20? ? ? ?  5? ? ? ?  1? ? ? ? ?  2
25? ? ? ? ? 50? ? ? 15? ? ? ?  35

i need to get the 
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? "MODE" - for each column-wise
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? "VARIANCE" - for each column-wise
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? "25TH-PERCENTAILE" -for each
column-wise

i tried alots, and it was difficult to get. Someone can help me out please ?

- Antony? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 


--
View this message in context: http://r.789695.n4.nabble.com/MODE-VARIANCE-NTH-PERCENTAILE-tp4636112.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help at r-project.org mailing list
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.
Jim Lemon
#
On 07/11/2012 05:38 PM, Rantony wrote:
Hi Rantony,
Try this:

testdat<-matrix(c(3,2,20,25,6,12,5,50,7,24,1,15,15,15,2,35),nrow=4)
colnames(testdat)<-c("ABC","PQR","XYZ","MNO")
library(prettyR)
# make a function for 25th percentile
q25<-function(x,na.rm) return(quantile(x,prob=0.25,na.rm=na.rm))
testdesc<-describe(testdat,num.desc=c("Mode","var","q25"),xname="testdat")
print(testdesc)

Note that the values in the data frame "testdesc" are numeric, except 
for the first column, as there are text messages that no mode exists for 
columns ABC, PQR and XYZ. When "testdesc" is printed, it is converted to 
a matrix, which coerces everything to character type.

Jim