Displaying 1 result from an estimated 1 matches for "ac_bhar_60d_4d_after_ann".
2012 Oct 05
11
Calculating the mean in one column with empty cells
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