5–8 PPT slides and speaker notes For this assignment, you will need to become familiar with specialized business intelligence (BI) software, then download the software. Complete the following steps to begin:Step 1: Watch an instructional video on the BI software. Step 2: Review various BI Software options including Tableau; Excel or other Business Intelligence. Search the CTU Library and the internet to learn about optional software. Step 3: If you choose Tableau, download the Tableau BI software. After you select the link, look for the orange icon in the middle portion of your screen to begin the download or use any Business Intelligence software to create at least 2 graphs illustrating at least 2 comparisons between the US and zip code data.Consider the following scenario, continued from the Unit 1 Individual Project:Big D Incorporated needs to prepare an assessment regarding the feasibility of making a recommendation for expansion into another market. As the Business Analyst, your assignment is to prepare a short presentation for the Board of Directors that apply concepts learned in Unit 1 and concepts from Unit 2 to make the necessary recommendations and justifications for those recommendations. You will need to compare and contrast the varying markets in order to make the best recommendation possible. Complete the following:Click here to download the reports for the United States. The Web site provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S. Census data. This particular file contains 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the entire United States. Click here to download the reports for zip code 60614. This particular file contains 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the U.S. zip code 60614. Using all 4 demographic reports (General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary) for the United States and zip code 60614, prepare a 1-page memo explaining how your territory differs from the national profile. Feel free to note anything that you found surprising in this data. Use the business intelligence software you choose to depict information from these reports. Prepare a presentation of 5–6 slides of your major findings. You may group a category of data from the Total United States and zip code 60614, and create a graph to show how they differ. The presentation should have at least two graphs and a headline that summarizes a key takeaway from the graph. The last page should contain at least 3 questions that you would want answered based on what you’ve seen in this comparison. Your presentation should include 5–6 slides in PowerPoint, plus title and reference slides with speaker notes (200–250 words per slide). For assistance with the usage of Tableau for analysis and reporting, review and use the following instructions. This should be helpful if you are having problems with the software usage or with problems with the data. But, you do not need to use Tableau. For BI software usage such as Excel, resort to using the Help functions and other resources on the internet and in videos to learn how to use Excel to create graphical presentations including table usage.
us_reports.xls

report_zip_codes.xls

Unformatted Attachment Preview

Date: March 3, 2006
Current Geography Selection: Entire US:
Entire US
General Summary Report
US Census 2000 Basic Variables
2000 Educational Attainment
College: Associates Degree
College: Bachelor’s Degree
College: Graduate Degree
College: Some College, No Degree
School: 9th to 11th grade no diploma
School: Grade K – 9
School: High School Graduate
6.32%
15.54%
8.86%
21.05%
12.05%
6.11%
28.63%
2000 Marital Status
Divorced
Never Married
Now Married
Separated
Widowed
9.75%
27.10%
51.13%
5.40%
6.63%
US Census 2000 Race and Ethnicity
Total Population: Race
Hispanic Ethnicity: Race
American Indian, Eskimo, Aleut Population
Asian
Black Population
0.90%
3.60%
12.30%
American Indian/Alaska Native Alone
Asian Alone
Black Alone
1.20%
0.30%
2.00%
Hispanic Ethnicity
12.50%
Native Hawaiian/Other Pacific Islander
Alone
0.10%
Native Hawaiian and Other Pacific Islander
Alone
Not or Latino
Other Population
Two or More Races
White Population
0.10%
87.50%
5.50%
2.40%
75.10%
Some Other Race
Two or More races
White Alone
Hispanic Ethnicity Population
42.20%
6.30%
47.90%
3504
US Census 2000 Occupation and
Employment
2000 Means of Transportation to Work
Bicycle
Bus or trolley bus
Carpooled
Drove alone
Ferryboat
Motorcycle
Other means
Railroad
Streetcar or trolley car
Subway or elevated
Taxicab
Walked
Worked at home
Workers Age 16+
2000 Travel Time to Work in Minutes
Median Travel Time To Work
0 to 5
5 to 9
10 to 14
15 to 19
20 to 24
25 to 29
30 to 34
35 to 39
40 to 44
45 to 59
60 to 89
90 or more
Worked at home
2150.00%
3.30%
10.70%
14.50%
15.30%
14.00%
5.60%
12.80%
2.50%
3.20%
7.20%
5.00%
2.70%
3.30%
71,787,347
Male Householder
3,776,997
79,134,868
5,428,325
Male HHldr, no wife present, own
children < 18 Female Householder 2,190,989 2,685,682 Female HHldr, no husband present, own children < 18 7,561,874 0.38% 2.50% 12.20% 75.70% 0.00% 0.10% 0.70% 0.50% 0.10% 1.50% 0.20% 2.90% 3.30% 45551 US Census 2000 Family Status: Family Households Family Households Natural Born or Adopted Children in Family Hhlds Grandchildren in Family Hhlds Step Children in Family Hhlds 4,258,524 Married Couple Family Married Couple Family w/ Children < 18 54,493,232 24,835,505 Married Couple Family w/ no own Children < 18 29,657,727 Date: March 3, 2006 Current Geography Selection: Entire US Census Trend 1980 to 2000 Summary Report Basic Variables Population Percent Female Percent Male 1980 1990 Percent Change 1980 to 1990 2000 Percent Change 1990 to 2000 224,811,135 248,710,012 10.60% 281,421,906 13.20% 51.50% 51.30% 10.20% 50.90% 12.50% 48.50% 48.70% 11.10% 49.10% 13.90% 79,887,387 91,947,641 15.10% 105,480,101 14.70% 2.75 2.63 -4.20% 2.59 -1.40% 193,665,964 203,905,540 5.30% 231,374,718 13.50% 5,417,823 6,697,345 23.60% 7,778,633 16.10% 1980 1990 Percent Change 1980 to 1990 2000 Percent Change 1990 to 2000 Median Household Income $16,902 $30,102 78.10% $42,257 40.40% Average Household Income $20,382 $38,464 88.70% $56,643 47.30% Total Households Average Household Size Family Population Group Quarters Population Household Income Per Capita Income $7,321 $14,381 96.40% $21,231 47.60% $ 0 - $9,999 23,151,917 14,160,538 -38.80% 10,061,842 -28.90% $ 10,000 - $14,999 12,228,204 8,114,324 -33.60% 6,653,726 -18.00% $ 15,000 - $19,999 11,292,020 8,091,126 -28.30% 6,597,532 -18.50% $ 20,000 - $29,999 9,945,771 15,439,727 55.20% 13,729,008 -11.10% $ 30,000 - $39,999 12,617,264 13,358,162 5.90% 12,946,852 -3.10% $ 40,000 - $49,999 3,359,065 10,221,806 204.30% 11,203,306 9.60% $ 50,000 - $74,999 3,591,660 13,795,934 284.10% 20,529,242 48.80% $ 75,000 + 3,719,547 8,754,151 135.40% 23,758,288 171.40% $ 75,000 - $99,999 2,578,079 4,711,982 82.80% 10,793,156 129.10% $100,000 + 1,141,468 4,042,169 254.10% $100,000 - $124,999 $125,000 - $149,999 $150,000 + 12,965,132 220.70% 1,834,823 5,488,333 199.10% 763,165 2,654,858 247.90% 1,444,181 4,821,941 233.90% Race and Ethnicity 2000 Percent Change 1990 to 2000 42.10% 2,475,956 26.40% 112.00% 10,641,833 46.40% 45.80% 15,359,073 56.70% 29,986,018 13.80% 34,658,190 15.60% 199,686,676 22,353,238 6.90% 53.80% 211,460,626 35,305,818 5.90% 57.90% 1980 1990 Percent Change 1980 to 1990 2000 Percent Change 1990 to 2000 Owner Occupied Housing 51,428,015 59,025,095 14.80% 69,815,753 18.30% Renter Occupied Housing 28,459,214 32,922,614 15.70% 35,664,348 8.30% 1980 1990 American Indian, Eskimo, Aleut 1,378,738 1,958,777 Asian 3,429,040 7,270,823 Other 6,726,165 9,804,230 Black 26,338,642 186,878,591 14,538,161 White Hispanic Ethnicity Percent Change 1980 to 1990 Housing Units Date: March 3, 2006 Current Geography Selection: Entire US: Entire US Occupation and Employment Summary Report Employment Not in Labor Force 1990 2000 66,603,437 34.70% 78,319,195 36.10% 125,216,716 65.30% 138,829,294 63.90% 115,716,133 92.40% 129,728,865 93.40% Unemployed 7,780,384 6.20% 7,947,452 5.70% In Armed Forces 1,706,113 0.90% 1,152,977 0.80% In Labor Force Employed 2000 Census Transportation, Industry and Occupation Means of Transportation to Work Workers Age 16+ Travel Time to Work 130,881,842 Median Travel Time To Work in Minutes 21 Bicycle 0.40% 0 to 5 3.30% Bus or trolley bus 2.50% 5 to 9 10.70% Carpooled 12.20% 10 to 14 14.50% Drove alone 75.70% 15 to 19 15.30% Ferryboat 0.00% 20 to 24 14.00% Motorcycle 0.10% 25 to 29 5.60% Other means 0.70% 30 to 34 12.80% Railroad 0.50% 35 to 39 2.50% Streetcar or trolley car 0.10% 40 to 44 3.20% Subway or elevated 1.50% 45 to 59 7.20% Taxicab 0.20% 60 to 89 5.00% Walked 2.90% 90 or more 2.70% Worked at home 3.30% Worked at home 3.30% Employment by Industry Occupation Accommodation and food services Administrative and support and waste management service 6.10% 3.40% Aircraft and traffic control occupations Architects surveyors cartographers and engineers Agriculture forestry fishing and hunting 1.50% Arts design entertainment sports and media occupation 1.90% Arts entertainment and recreation 1.80% Building & grounds cleaning & maintenance occupat 3.30% Construction 6.80% Business operations specialists 2.10% Educational services 8.80% Community and social services occupations 1.50% Finance and insurance 5.00% Computer and mathematical occupations 2.40% Construction trades workers 4.70% Drafters engineering and mapping technicians 0.60% Health care and social assistance Information 11.10% 3.10% 0.10% 1.50% Management of companies and enterprises Manufacturing 0.10% 14.10% Education training and library occupations 5.60% Extraction workers 0.10% Mining 0.40% Farmers and farm managers 0.60% Other services (except public administration) 4.90% Farming fishing and forestry occupations 0.70% Professional scientific and technical services 5.90% Financial specialists 2.20% 4.80% Fire fighting prevention and law enforcement workers 1.20% 1.90% Food preparation and serving related occupations 4.80% Health diagnosing and treating practitioners and tech 3.20% Public administration Real estate and rental and leasing Retail trade 11.70% Transportation and warehousing 4.30% Health technologists and technicians 1.40% Utilities 0.90% Healthcare support occupations 2.00% Wholesale trade 3.60% Installation maintenance and repair occupations 3.90% Personal care and service occupations 2.80% Legal occupations 1.10% Life physical and social science occupations 0.90% Management occupations except farmers and farm manage 8.50% Material moving workers 2.50% Motor vehicle operators 2.90% Office and administrative support occupations 15.30% Production 8.40% Protective Service Occupations 0.80% Rail water and other transportation occupations Sales and related occupations 0.30% 11.20% Supervisors construction and extraction workers 0.70% Supervisors transportation and material moving worker 0.20% Date: March 3, 2006 Current Geography Selection: Entire US: Entire US Income Summary Report 2000 Census Household Income by Type Total Households 105,480,101 Average Household Income $56,643 Total Population 281,421,906 Median Household Income $42,257 Total Workers 130,881,842 Per Capita Household Income $21,587 Income by Type: Earnings $ 1 to $2,499 or less Household Income Percents $ 0 - $9,999 9.54% $ 2,500 to $4,999 10,621,378 7,953,137 $ 10,000 - $14,999 6.31% $ 5,000 to $7,499 8,124,698 $ 15,000 - $19,999 6.25% $ 7,500 to $9,999 6,504,581 $ 20,000 - $24,999 6.57% $ 10,000 to $12,499 9,597,527 $ 25,000 - $29,999 6.44% $ 12,500 to $14,999 6,201,326 $ 30,000 - $34,999 6.37% $ 15,000 to $17,499 8,302,907 $ 35,000 - $39,999 5.91% $ 17,500 to $19,999 6,179,510 $ 40,000 - $44,999 5.65% $ 20,000 to $22,499 9,086,198 $ 45,000 - $49,999 4.97% $ 22,500 to $24,999 5,644,521 $ 50,000 - $59,999 9.04% $ 25,000 to $29,999 12,996,782 $ 60,000 - $74,999 10.43% $ 30,000 to $34,999 11,366,211 $ 75,000 - $99,999 10.23% $ 35,000 to $39,999 9,219,670 $100,000 - $124,999 5.20% $ 40,000 to $44,999 7,744,095 $125,000 - $149,999 2.52% $ 45,000 to $49,999 5,200,969 $150,000 - $199,999 2.20% $ 50,000 to $54,999 5,563,669 $200,000 + 2.37% $ 55,000 to $64,999 6,146,281 $ 65,000 to $74,999 2,041,290 $ 75,000 to $99,999 2,191,536 $100,000 or more 1,850,632 HH Income By Age of Householder <25 25-34 35-44 45-54 54-64 65-74 75+ Less than $10,000 21.11% 7.87% 6.61% 6.78% 9.52% 12.13% 17.76% $10,000 to $14,999 11.02% 5.09% 4.17% 3.90% 5.40% 9.61% 14.54% $15,000 to $19,999 10.53% 5.96% 4.65% 4.12% 5.37% 9.19% 11.77% $20,000 to $24,999 10.39% 7.02% 5.48% 4.82% 5.90% 8.77% 9.74% $25,000 to $29,999 8.96% 7.47% 5.86% 5.05% 5.94% 8.08% 7.81% $30,000 to $34,999 7.72% 7.75% 6.23% 5.41% 5.98% 7.30% 6.44% $35,000 to $39,999 6.28% 7.18% 6.17% 5.34% 5.72% 6.43% 5.16% $40,000 to $49,999 5.21% 6.84% 6.25% 5.55% 5.59% 5.57% 4.22% $50,000 to $59,999 4.02% 6.00% 5.58% 5.12% 5.01% 4.70% 3.44% $60,000 to $74,999 5.67% 10.79% 10.75% 10.12% 9.37% 7.46% 5.27% $75,000 to $99,999 4.42% 11.58% 13.19% 13.00% 11.12% 7.51% 5.10% $100,000 - $124,999 2.88% 9.47% 13.04% 14.78% 11.79% 6.72% 4.46% $125,000 - $149,999 1.02% 3.97% 6.41% 8.28% 6.63% 3.32% 2.20% $150,000 - $199,999 0.43% 1.69% 2.99% 4.12% 3.47% 1.69% 1.08% $200,000 + 0.33% 0.33% 1.32% 2.62% 3.60% 3.17% 1.54% Current Geography Selection: ZIP Codes (2004 Q3): 60614 Chicago General Summary Report US Census 2000 Basic Variables 2000 Educational Attainment College: Associates Degree College: Bachelor's Degree College: Graduate Degree College: Some College, No Degree School: 9th to 11th grade no diploma School: Grade K - 9 School: High School Graduate 1.90% 44.19% 33.99% 8.72% 3.19% 1.95% 5.60% 2000 Marital Status Divorced Never Married Now Married Separated Widowed 7.59% 54.20% 30.95% 3.80% 3.46% US Census 2000 Race and Ethnicity Total Population: Race American Indian, Eskimo, Aleut Population Asian Black Population Hispanic Ethnicity Native Hawaiian and Other Pacific Islander Alone Not or Latino Other Population Two or More Races White Population 0.20% 3.70% 4.80% Hispanic Ethnicity: Race American Indian/Alaska Native Alone Asian Alone Black Alone 1.20% 0.30% 2.00% 5.40% Native Hawaiian/Other Pacific Islander Alone 0.10% 0.00% 94.60% 2.10% 1.60% 87.60% Some Other Race Two or More races White Alone Hispanic Ethnicity Population 35.00% 6.40% 55.00% 3,504 2000 Travel Time to Work in Minutes Median Travel Time To Work 0 to 5 5 to 9 10 to 14 15 to 19 20 to 24 25 to 29 30 to 34 35 to 39 40 to 44 45 to 59 60 to 89 90 or more Worked at home 28.9 1.30% 3.70% 8.00% 13.10% 16.00% 7.60% 19.10% 3.10% 4.40% 9.50% 7.50% 2.30% 4.30% US Census 2000 Occupation and Employment 2000 Means of Transportation to Work Bicycle Bus or trolley bus Carpooled Drove alone Ferryboat Motorcycle Other means Railroad Streetcar or trolley car Subway or elevated Taxicab Walked Worked at home Workers Age 16+ 0.98% 15.50% 7.00% 39.50% 0.00% 0.00% 0.80% 0.60% 0.30% 22.60% 2.40% 6.00% 4.30% 45,551 US Census 2000 Family Status: Family Households Family Households Natural Born or Adopted Children in Family Hhlds Grandchildren in Family Hhlds Step Children in Family Hhlds 10,458 7,068 213 103 Married Couple Family Married Couple Family w/ Children < 18 8,673 3,095 Married Couple Family w/ no own Children < 18 5,578 Male Householder 3,316 Male HHldr, no wife present, own children < 18 Female Householder Female HHldr, no husband present, own children < 18 130 2,789 574 Current Geography selection: Zip code 60614 Census Trend 1980 to 2000 Summary Report Basic Variables Percent Change Percent Change 2000 1990 to 2000 1980 1990 1980 to 1990 57,441 61,469 7.00% 64,637 5.20% Percent Female 51.20% 52.00% 8.70% 51.10% 3.30% Percent Male 48.80% 48.00% 5.30% 48.90% 7.20% 31,698 34,838 9.90% 35,975 3.30% 1.75 1.7 -2.80% 1.7 0.10% 30,152 26,956 -10.60% 27,975 3.80% 1,952 2,182 11.80% 3,363 54.10% Population Total Households Average Household Size Family Population Group Quarters Population Household Income Percent Change Percent Change 2000 1990 to 2000 1980 1990 1980 to 1990 Median Household Income $18,438 $41,227 123.60% $69,311 68.10% Average Household Income $24,245 $67,607 178.80% $114,615 69.50% Per Capita Income $13,564 $38,518 184.00% $63,791 65.60% $ 0 - $9,999 7,661 3,710 -51.60% 2,570 -30.70% $ 10,000 - $14,999 4,841 1,541 -68.20% 1,134 -26.40% $ 15,000 - $19,999 4,663 2,031 -56.50% 1,125 -44.60% $ 20,000 - $29,999 3,883 4,889 25.90% 2,208 -54.80% $ 30,000 - $39,999 4,791 4,589 -4.20% 3,060 -33.30% $ 40,000 - $49,999 1,289 3,703 187.30% 2,820 -23.90% $ 50,000 - $74,999 1,633 5,610 243.40% 6,256 11.50% $ 75,000 + 2,928 8,763 199.30% 16,801 91.70% $ 75,000 - $99,999 1,843 2,750 49.20% 4,126 50.00% $100,000 + 1,085 6,013 454.10% 12,675 110.80% $100,000 - $124,999 1,930 3,091 60.10% $125,000 - $149,999 1,216 2,053 68.80% $150,000 + 2,867 7,531 162.70% Race and Ethnicity Percent Change Percent Change 2000 1990 to 2000 1980 1990 1980 to 1990 147 107 -27.60% 126 18.50% Asian 1,697 1,475 -13.10% 2,392 62.10% Other 3,164 2,049 -35.30% 1,359 -33.70% Black 4,853 3,435 -29.20% 3,079 -10.30% White 47,581 54,404 14.30% 56,619 4.10% 6,405 4,461 -30.30% 3,504 -21.50% 1980 1990 Percent Change 1980 to 1990 Owner Occupied Housing 8,198 11,433 39.50% 14,495 26.80% Renter Occupied Housing 23,500 23,405 -0.40% 21,480 -8.20% American Indian, Eskimo, Aleut Hispanic Ethnicity Housing Units Percent Change 2000 1990 to 2000 Current Geography Selection: ZIP Codes (2004 Q3): 60614 Chicago Occupation and Employment Summary Report Employment 1990 2000 Not in Labor Force 10,340 18.50% 11,120 18.90% In Labor Force 45,585 81.50% 47,653 81.10% 43,739 96.00% 45,543 95.60% Employed Unemployed In Armed Forces 1,827 21 4.00% 2,102 4.40% 0.00% 8 0.00% 2000 Census Transportation, Industry and Occupation Means of Transportation to Work Workers Age 16+ Bicycle Bus or trolley bus Carpooled Travel Time to Work 45,551 Median Travel Time To Work in Minutes 29 1.00% 0 to 5 1.30% 15.50% 5 to 9 3.70% 7.00% 10 to 14 8.00% 39.50% 15 to 19 13.10% Ferryboat 0.00% 20 to 24 16.00% Drove alone Motorcycle 0.00% 25 to 29 7.60% Other means 0.80% 30 to 34 19.10% Railroad 0.60% 35 to 39 3.10% Streetcar or trolley car 0.30% 40 to 44 4.40% 22.60% 45 to 59 9.50% Taxicab 2.40% 60 to 89 7.50% Walked 6.00% 90 or more 2.30% Worked at home 4.30% Worked at home 4.30% Subway or elevated Employment by Industry Accommodation and food services Occupation 3.10% Aircraft and traffic control occupations 0.20% Administrative and support and waste management service 2.00% Architects surveyors cartographers and engineers 2.10% Agriculture forestry fishing and hunting 0.00% Arts design entertainment sports and media occupation 4.80% Arts entertainment and recreation 2.20% Building & grounds cleaning & maintenance occupat 0.40% Construction 1.50% Business operations specialists 8.00% Educational services 7.80% Community and social services occupations 1.40% Computer and mathematical occupations 5.20% 8.60% Construction trades workers 0.60% 6.20% Drafters engineering and mapping technicians 0.10% Finance and insurance Health care and social assistance Information 15.20% Management of companies and enterprises 0.10% Education training and library occupations 4.80% Manufacturing 5.80% Extraction workers 0.00% Mining 0.00% Farmers and farm managers 0.00% Other services (except public administration) 2.80% Farming fishing and forestry occupations 0.00% Financial specialists 6.70% 0.20% Professional scientific and technical services 27.70% Public administration 1.70% Fire fighting prevention and law enforcement workers Real estate and rental and leasing 3.70% Food preparation and serving related occupations 1.70% Retail trade 6.30% Health diagnosing and treating practitioners and tech 5.30% Transportation and warehousing 1.60% Health technologists and technicians 0.60% Utilities 0.30% Healthcare support occupations 0.40% Wholesale trade 3.10% Installation maintenance and repair occupations 0.30% Personal care and service occupations 1.70% Legal occupations 7.00% Life physical and social science occupations 1.40% Management occupations except farmers and farm manage 18.30% Material moving workers 0.30% Motor vehicle operators 0.30% Office and administrative support occupations 9.20% Production 1.20% Protective Service Occupations 0.20% Rail water and other transportation occupations 0.00% Sales and related occupations 17.40% Supervisors construction and extraction workers 0.10% Supervisors transportation and material moving worker 0.10% Current Geography Selection: ZIP Codes (2004 Q3): 60614 Chicago Income Summary Report 2000 Census Household Income by Type Total Households 35,975 Total Population 64,637 Total Workers 45,551 Average Household Income Median Household Income Per Capita Household Income $114,615 $69,311 $64,426 Household Income Percents Income by Type: Earnings $ 1 to $2,499 or less 1,991 $ 0 - $9,999 7.14% $ 2,500 to $4,999 1,875 $ 10,000 - $14,999 3.15% $ 5,000 to $7,499 1,564 $ 15,000 - $19,999 3.13% $ 7,500 to $9,999 775 $ 20,000 - $24,999 3.04% 1,579 $ 25,000 - $29,999 3.10% $ 12,500 to $14,999 743 $ 30,000 - $34,999 4.42% $ 15,000 to $17,499 1,222 $ 35,000 - $39,999 4.08% $ 17,500 to $19,999 861 $ 40,000 - $44,999 4.18% $ 20,000 to $22,499 1,516 $ 45,000 - $49,999 3.66% $ 22,500 to $24,999 659 $ 50,000 - $59,999 7.97% $ 25,000 to $29,999 2,716 $ 60,000 - $74,999 9.42% $ 30,000 to $34,999 2,868 $ 75,000 - $99,999 11.47% $ 35,000 to $39,999 2,937 $100,000 - $124,999 8.59% $ 40,000 to $44,999 3,348 $125,000 - $149,999 5.71% $ 45,000 to $49,999 2,627 $150,000 - $199,999 7.21% $ 50,000 to $54,999 2,875 $200,000 + $ 55,000 to $64,999 3,727 $ 65,000 to $74,999 2,520 $ 75,000 to $99,999 3,967 $100,000 or more 5,536 $ 10,000 to $12,499 13.73% HH Income By Age of Householder Less than $10,000 <25 25-34 35-44 45-54 54-64 65-74 75+ 13.36% 3.95% 5.44% 8.47% 9.89% 29.43% 26.13% $10,000 to $14,999 5.79% 2.10% 2.72% 2.83% 5.24% 10.00% 10.59% $15,000 to $19,999 7.35% 2.14% 3.40% 3.60% 3.77% 9.09% 3.18% $20,000 to $24,999 7.4 ... Purchase answer to see full attachment