This lab was not necessary difficult, but it was tedious. After i opened my census data in excel, i had to copy each individual column and place it in my NewJerseyData spreadsheet. After i thought i was all through i looked back and for my first county I had the population of the entire state in that given year as opposed to the specific data. I don’t exactly know what went on here but it must have happened in the copy and paste stage to the new excel sheet. This resulted in me starting again from scratch. Everything from copying and pasting, to adding the y’s in front of the years, to the apostrophes before the FIPS code.
Advertisement
