Excel Tips and Tricks (SAMPLE 2)

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 2nd 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.

 

2nd Database (Contains Problems)

Website_presentation_SAMPLE_2.jpg

 

2nd Database (Corrected All Issues)

sample_2_CORRECTED.jpg

 

 

 

final_sample_2_sovled.jpg