Skip to content
Prev 307046 / 398506 Next

Calculating the mean in one column with empty cells

fxen3k 
Hi all,

I recently tried to calculate the mean and the median just for one column.
In this column I have numbers with some empty cells due to missing data. 
So how can I calculate the mean just for the filled cells? 
I tried:
mean(dataSet2$ac_60d_4d_after_ann[!is.na(master$ac_60d_4d_after_ann)],
na.rm=TRUE)
But the output was different to the calculation I died in Microsoft Excel.

Thanks in advance,
Felix



--
View this message in context: http://r.789695.n4.nabble.com/Calculating-the-mean-in-one-column-with-empty-cells-tp4645135.html
Sent from the R help mailing list archive at Nabble.com.

Thread (18 messages)

fxen3k Calculating the mean in one column with empty cells Oct 5 PIKAL Petr Calculating the mean in one column with empty cells Oct 5 Berend Hasselman Calculating the mean in one column with empty cells Oct 5 Kenneth Takagi Calculating the mean in one column with empty cells Oct 5 fxen3k Calculating the mean in one column with empty cells Oct 5 fxen3k Calculating the mean in one column with empty cells Oct 5 arun Calculating the mean in one column with empty cells Oct 5 Sarah Goslee Calculating the mean in one column with empty cells Oct 5 William Dunlap Calculating the mean in one column with empty cells Oct 5 PIKAL Petr Calculating the mean in one column with empty cells Oct 5 fxen3k Calculating the mean in one column with empty cells Oct 6 R. Michael Weylandt Calculating the mean in one column with empty cells Oct 6 John Kane Calculating the mean in one column with empty cells Oct 6 fxen3k Calculating the mean in one column with empty cells Oct 6 David Winsemius Calculating the mean in one column with empty cells Oct 6 William Dunlap Calculating the mean in one column with empty cells Oct 6 michael.weylandt at gmail.com (R. Michael Weylandt Calculating the mean in one column with empty cells Oct 6 PIKAL Petr Calculating the mean in one column with empty cells Oct 8