a question on using Microsoft Excel to do data analysis
- by Gemma
Hello everyone there,
Me and my mates have been given an Excel spreasheet,which contains the data of the Census report.
The column here corresponds to "Year" (from 2000-2010),the row means "City/Town",the cell is simply the population of a town at a particular year.
We are up to doing some analysis like “what town had its first population gain in 10 years?”
etc.My question is just about can we do this in Excel,or do we need to export the data to other database(SQL) then do the programming?
Thanks in advance.