Share
Explore BrainMass

Data Analysis Project

This assignment is framed around the concepts of data analysis and biases in Chapter 12 (Step 7) and in Sekaran. Click here to view the Sekaran diagram on the research process.

For the first part of this exercise, download the files from the Census Bureau using the Government data mining tool (http://www.factfinder.census.gov/). You will create a short presentation for the Marketing department highlighting how the consumers in the 60647 zip code differ from those in the Total U.S.

Create a graph that compares the categories from each file you consider relevant. Create a 3-5 slide presentation with in-depth narratives in the speaker notes section that displays the graph(s) and analysis on how the 60647 categories you chose differ from the national profile.

Search for your data sets using www.factfinder.census.gov. You can enter the ZIP code in the "Fast Access to Information" search window to obtain the data for 60647. The site also presents the national demographics on the same results page any time you type in a ZIP code. Analyze and compare both data sets using the data analysis concepts from Chapter 12 of Sekaran. Compare only those categories that you find are significant to your analysis in demonstrating whether the US marketing advertising schemes can or cannot be effectively used in this ZIP code. Remember that you can copy from the web and paste into an Excel spreadsheet as one way to the create graphs for this assignment.

Solution Preview

This assignment is framed around the concepts of data analysis and biases in Chapter 12 (Step 7) and in Sekaran. Click here to view the Sekaran diagram on the research process.

For the first part of this exercise, download the files from the Census Bureau using the Government data mining tool (http://www.factfinder.census.gov/). You will create a short presentation for the Marketing department highlighting how the consumers in the 60647 zip code differ from those in the Total U.S.

Create a graph that compares the categories from each file you consider relevant. Create a 3-5 slide presentation with in-depth narratives in the speaker notes section that displays the graph(s) and analysis on how the 60647 categories you chose differ from the national profile.

Search for your data sets using www.factfinder.census.gov. You can enter the ZIP code in the "Fast Access to Information" search window to obtain the data for 60647. The site also presents the national demographics on the same results page any time you type in a ZIP code. Analyze and compare both data sets using the data analysis concepts from Chapter 12 of Sekaran. Compare only those categories that you find are significant to your analysis in demonstrating whether the US marketing advertising schemes can or cannot be effectively used in this ZIP code. Remember that you can copy from the web and paste into an Excel spreadsheet as one way to the create graphs for this assignment.

In this assignment, we have to compare consumers in the 60647 zip code to consumers in the entire U.S.

First, I went to the website, and downloaded data describing that zip code. The most recent data that was published was from the 2000 census. ...

Solution Summary

The solution explores how the residents in 60647 differ from the United States as a whole in the following areas: age, education level, race, and income. It uses z-tests to determine if the proportions of people in different age groups are statistically significantly different in this zip code compared to the U.S. Excel graphs are used to present the results visually.

$2.19