Summarize And Present Information In A Meaningful Way

One of WidgeCorp’s regional sales managers contacts you with a request. In preparation for rolling out a new type of snack food, she’s been trying to make sense of some demographic data available through the AMA (American Marketing Association) and is overwhelmed. She explains to you that there are two files which contain reports generated from AMA’s (American Marketing Association) website. AMA’s website provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S. Census decennial data obtained at the beginning of each decade. These files contain 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary. In these demographics reports the data for many of the variables is distributed into many different categories. For example, there are 7 different categories for Educational Attainment in the General Summary Report and 20 categories for Employment by Industry in the Occupation and Employment Summary Report. Help this regional sales manager see a smaller number of comprehensible categories.

  1. Click Here to download the reports for zip code 60614.
  2. Using all four demographic reports: (Overview, Trend, Employment, and Population Detail) for zip code 60614, choose four variables (including at least one from each report) and explain how you would collapse the categories and why.

CurrentGeography Selection: ZIP Codes (2004 Q3): 60614 ChicagoGeneralSummary ReportUSCensus 2000 Basic Variables2000Educational Attainment2000 Marital StatusCollege:Associates Degree1.90%Divorced7.59%College:Bachelor’s Degree44.19%Never Married54.20%College:Graduate Degree33.99%Now Married30.95%College:Some College, No Degree8.72%Separated3.80%School:9th to 11th grade no diploma3.19%Widowed3.46%School:Grade K – 91.95%School:High School Graduate5.60%USCensus 2000 Race and EthnicityTotalPopulation: RaceHispanic Ethnicity: RaceAmericanIndian, Eskimo, Aleut Population0.20%American Indian/Alaska NativeAlone1.20%Asian3.70%Asian Alone0.30%BlackPopulation4.80%Black Alone2.00%HispanicEthnicity5.40%Native Hawaiian/Other PacificIslander Alone0.10%NativeHawaiian and Other Pacific Islander Alone0.00%Some Other Race35.00%Not orLatino94.60%Two or More races6.40%OtherPopulation2.10%White Alone55.00%Two orMore Races1.60%Hispanic Ethnicity Population3,504WhitePopulation87.60%USCensus 2000 Occupation and Employment2000Means of Transportation to Work2000 Travel Time to Work inMinutesBicycle0.98%Median Travel Time To Work28.9Bus ortrolley bus15.50%0 to 51.30%Carpooled7.00%5 to 93.70%Drovealone39.50%10 to 148.00%Ferryboat0.00%15 to 1913.10%Motorcycle0.00%20 to 2416.00%Othermeans0.80%25 to 297.60%Railroad0.60%30 to 3419.10%Streetcaror trolley car0.30%35 to 393.10%Subwayor elevated22.60%40 to 444.40%Taxicab2.40%45 to 599.50%Walked6.00%60 to 897.50%Workedat home4.30%90 or more2.30%WorkersAge 16+45,551Worked at home4.30%USCensus 2000 Family Status: Family HouseholdsFamilyHouseholds10,458Male Householder3,316NaturalBorn or Adopted Children in Family Hhlds7,068Male HHldr, no wife present, ownchildren < 18130Grandchildrenin Family Hhlds213Female Householder2,789StepChildren in Family Hhlds103Female HHldr, no husbandpresent, own children < 18574MarriedCouple Family8,673MarriedCouple Family w/ Children < 183,095MarriedCouple Family w/ no own Children < 185,578

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount