1. There are two separate reports for the USA. File contains reports generated from the AMA (American Marketing Association) website. This file contains four reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the entire U.S. Attached as excel spreadsheet.
2. Reports for zip code 60614. Consist of 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the US zip code 60614. Using all 4 reports prepare a one page memo explaining how this territory differs from the national profile and describe any surprises in this data.
3. PPT presentation of 5-6 slides with notes on the major findings for the above (#'s 1-2). Group a category of the data from the Total US and zip code 60614 and create a graph to show how they differ. Presentation should include at least one graph and a headline that summarizes a key takeaway from the graph. Last page should contain at least 3 questions that one would want answered based on what is seen in the comparison.
The solution provides detailed explanations and answer, including the Powerpoint presentation for the problem.