Summarize and Present Information in a Meaningful Way

Apr 19th, 2014
FratBro23
Category:
Business & Finance
Price: $50 USD

Question description

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.
Current Geography Selection: ZIP Codes (2004 Q3): 60614 Chicago
General Summary Report
US Census 2000 Basic Variables
2000 Educational Attainment 2000 Marital Status
College: Associates Degree 1.90% Divorced 7.59%
College: Bachelor's Degree 44.19% Never Married 54.20%
College: Graduate Degree 33.99% Now Married 30.95%
College: Some College, No Degree 8.72% Separated 3.80%
School: 9th to 11th grade no diploma 3.19% Widowed 3.46%
School: Grade K - 9 1.95%
School: High School Graduate 5.60%
US Census 2000 Race and Ethnicity
Total Population: Race Hispanic Ethnicity: Race
American Indian, Eskimo, Aleut Population 0.20% American Indian/Alaska Native Alone 1.20%
Asian 3.70% Asian Alone 0.30%
Black Population 4.80% Black Alone 2.00%
Hispanic Ethnicity 5.40% Native Hawaiian/Other Pacific Islander Alone 0.10%
Native Hawaiian and Other Pacific Islander Alone 0.00% Some Other Race 35.00%
Not or Latino 94.60% Two or More races 6.40%
Other Population 2.10% White Alone 55.00%
Two or More Races 1.60% Hispanic Ethnicity Population 3,504
White Population 87.60%
US Census 2000 Occupation and Employment
2000 Means of Transportation to Work 2000 Travel Time to Work in Minutes
Bicycle 0.98% Median Travel Time To Work 28.9
Bus or trolley bus 15.50% 0 to 5 1.30%
Carpooled 7.00% 5 to 9 3.70%
Drove alone 39.50% 10 to 14 8.00%
Ferryboat 0.00% 15 to 19 13.10%
Motorcycle 0.00% 20 to 24 16.00%
Other means 0.80% 25 to 29 7.60%
Railroad 0.60% 30 to 34 19.10%
Streetcar or trolley car 0.30% 35 to 39 3.10%
Subway or elevated 22.60% 40 to 44 4.40%
Taxicab 2.40% 45 to 59 9.50%
Walked 6.00% 60 to 89 7.50%
Worked at home 4.30% 90 or more 2.30%
Workers Age 16+ 45,551 Worked at home 4.30%
US Census 2000 Family Status: Family Households
Family Households 10,458 Male Householder 3,316
Natural Born or Adopted Children in Family Hhlds 7,068 Male HHldr, no wife present, own children < 18 130
Grandchildren in Family Hhlds 213 Female Householder 2,789
Step Children in Family Hhlds 103 Female HHldr, no husband present, own children < 18 574
Married Couple Family 8,673
Married Couple Family w/ Children < 18 3,095
Married Couple Family w/ no own Children < 18 5,578

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: New York University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
ddg82
Dec 4th, 2016
" Thanks, good work "
kenmwao2
Nov 22nd, 2016
" Solid work, thanks. "
tinytim47
Nov 21st, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
jestin7
Nov 12th, 2016
" This tutor is great! "
lilmoe415
Oct 29th, 2016
" Thank you, Thank you, for top quality work, this is your guy!! "
dontuwannaknow
Oct 7th, 2016
" Excellent work as always thanks so much "
thargrow
Sep 28th, 2016
" Very Satisfied. "
SjSurvivor143
Sep 23rd, 2016
" Thanks for the help. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors