[R] Calculating the mean in one column with empty cells
bhh at xs4all.nl
Fri Oct 5 15:01:55 CEST 2012
On 05-10-2012, at 11:27, fxen3k wrote:
> 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:
> But the output was different to the calculation I died in Microsoft Excel.
No data ==> no can answer question.
What did you expect?
What did Excel give you?
But you are trying to calculate the mean of dataSet2$ac_60d_4d_after_ann and indexing with the indices of non-NA numbers of master$ac_60d_4d_after_ann.
should do what you want.
More information about the R-help