Typing errors can be fatal

I thought the following article might be valuable to readers of this forum as spreadsheets have few built in procedures to prevent data entry errors:

http://www.medscape.com/viewarticle/546515_print

The double entry method is perhaps the most valuable suggestion. I also always look for outliers and off patterns in the data - what Vickers calls "consistency checks."

I don't think Excel can produce programmed analyses (I presume they mean "R" which is a statistical programming language that is becoming standard for many medical journals). Also I don't think Excel can create "log" files. If anyone knows how let me know!

Lance

Sign In or Register to comment.