UCLA Campus    |    David Geffen School of Medicine    |    CTSI    |    UCLA Department of Medicine
Department of
Medicine
Statistics
Core

Excel Tips and Tricks (SAMPLE 1)

When data is collected in an excel spreadsheet, there are several excel formats which do not transfer well into a statistical software package, causing a misinterpretation of the data during data analysis. These tips help streamline the data and avoid these misinterpretations. Below you will find the 1st sample with potential formatting issues which may not transfer into statistical software easily. If you scroll further down, there is a re-done version of the same database showing the different changes. The red numbers in the description of changes correspond to the numbers in the two tables.

1st Database (Contains Problems)

1st Database (Corrected All Issues)