Now that you have taken a deeper dive in data visualization using data that was given to you, I want you to expand your learning by getting more comfortable not only visualizing data, but finding it as well. Finding secondary data is a key part of marketing research, and this exercise will get you more comfortable finding and using data. Please use the American Community Survey: http://www.census.gov/acs/www
Please find the following information for Washington, DC, Pittsburgh, PA, and your hometown if not from Pittsburgh.
Develop a demographic profile of each city comparing the following in visualized format against one another:
- Average age
- Race distribution
- Income distribution (average income)
- Poverty distribution
- Employment statistics
If you were launching a new product, which city would you launch in? Why? What other items would you have to consider when launching a product in various markets.
I look forward to seeing your responses. Like last week, create charts using excel and then upload in powerpoint format or pdf format on slideshare and leave the link as a comment for the class to share.