Purchase Solution

Demographic reports

Not what you're looking for?

Ask Custom Question

Company CW is coming out with a new snack food. The Regional Manager is interested in some American Marketing Association reports on demographics. The files contain the following reports: General Summary, Census Trend 12980 to 2000 Sugary, Occupation and Employment Summary and Income Summary. In these demographics reports the data for many of the variables is distributed into many different categories. 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. The Regional Manager wants to see a smaller number of comprehensible categories.

Attached are the reports for zip code 60614. Using all four demographic reports (Overview, Trend, Employment and Population Detail) for the latter zip code, need to choose four variables (ONE from each report) and explain how you would collapse the categories and why. Show any graphs or charts.

PLEASE USE REPORT 1-ZIP CODE 60614.XLS

Purchase this Solution

Solution Summary

Collapsing categories within demographic reports

Solution Preview

See the attached file.

For the census trend report, you could consolidate the percentage change in household income data. Instead of having 13 different increments, you could divide income into six categories: Less than $30,000, Less than $50,000, Less than $75,000, Less than $100,000, Less than $150,000 and Over ...

Purchase this Solution


Free BrainMass Quizzes
Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.