[R] Calculating the mean in one column with empty cells

[R. Michael Weylandt <michael.weylandt@gmail.com>]

On Oct 6, 2012, at 4:54 PM, fxen3k <f.sehardt at gmail.com> wrote:

> I created a Microsoft Excel spreadsheet. As you said, I only have "as
> displayed" numbers. I just solved the problem by showing 25 decimal places
> in Excel and then exported the data into a CSV-file. 
> 
> Is there a better way to solve this?
> 

Don't use Excel. (or at least find a way to get reasonable defaults) This isn't sarcastic: just acknowledging that instances like this show Excel really isn't a suitable tool for real data analysis (cf Pat Burns' 'Spreadsheet Addiction' paper)

Michael

> Regards,
> Felix
> 
> 
> 
> --
> View this message in context: http://r.789695.n4.nabble.com/Calculating-the-mean-in-one-column-with-empty-cells-tp4645135p4645278.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.