[R] weighted average
arun
smartpink111 at yahoo.com
Tue Jul 23 00:26:35 CEST 2013
Hi,
May be this helps:
Master<-read.table(text="
SID B2A B2B B2C C2A C2B C2C C118A C118B C118C
001 0.01 0.5 -0.4 1.2 -1.8 0.3 -0.3 0.4 0.5
002 0.01 0.5 -0.4 0.5 -0.4 1.2 -1.8 0.3 -0.3
003 0.04 0.05 0.5 -0.4 -0.5 0.4 -1.2 1.8 0.3
",sep="",header=TRUE)
library(matrixStats)
Master$zGPA<-rowWeightedMeans(as.matrix(Master[,-1]),Units)
Master
# SID B2A B2B B2C C2A C2B C2C C118A C118B C118C zGPA
#1 1 0.01 0.50 -0.4 1.2 -1.8 0.3 -0.3 0.4 0.5 0.035121951
#2 2 0.01 0.50 -0.4 0.5 -0.4 1.2 -1.8 0.3 -0.3 -0.003902439
#3 3 0.04 0.05 0.5 -0.4 -0.5 0.4 -1.2 1.8 0.3 0.097804878
A.K.
----- Original Message -----
From: Robert Lynch <robert.b.lynch at gmail.com>
To: r-help at r-project.org
Cc:
Sent: Monday, July 22, 2013 6:12 PM
Subject: [R] weighted average
I am trying to compute GPA from class grades(which have been normallized)
I have for example the following matrix
Master =
SID B2A B2B B2C C2A C2B C2C C118A C118B C118C
001 0.01 0.5 -0.4 1.2 -1.8 0.3 -0.3 0.4
0.5
002 0.01 0.5 -0.4 0.5 -0.4 1.2 -1.8 0.3
-0.3
003 0.04 0.05 0.5 -0.4 - 0.5 0.4 -1.2 1.8
0.3
etc
Where each column has a zero mean and a standard deviation of 1. I want to
calculate a weighted average for each row(student ID) that takes into
account that
B2A, C118A, C118B, and C118C are all 4 unit classes, and the rest, B2B,
B2C, C2A,C2B,C2C are 5 unit classes
I have tried
Units<-c(4,5,5,5,5,5,4,4,4)
Master$zGPA <-weighted.means(Master[,2:10],Units)
But that gets me one number and not a vector.
[[alternative HTML version deleted]]
______________________________________________
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.
More information about the R-help
mailing list