Median household incomes of Arizona residents

Details:

The purpose of this assignment is to create a data story and communicate findings to key stakeholders.

Part 1:

For this assignment, you will use the “Arizona Incomes by Zip Code” dataset. You will use Tableau to create a data story that illustrates the median household incomes of Arizona residents. The data provided includes all zip codes in Arizona. Each record is a unique zip code. The data includes the following columns:

  1. Zip_Code:An Arizona zip code.
  2. Metro_Area:Whether or not the zip code is within the Phoenix-metro area.
  3. City:The city name of the zip code.
  4. Median_Income:The median household income of each zip code based on 5-year estimates (2010-2014) from the U.S. Census Bureau.

The marketing manager has asked you to analyze income data for Arizona residents so that leaders in his department can determine the company’s advertising strategy. The marketing manager intends to share this data with other decisions makers and the marketing department staff so that everyone has a thorough understanding of how the income information can be used to determine specific target markets in upcoming advertising campaigns. Because most of these individuals do not have a strong understanding of analytics, they must be able gain the information listed below from studying the charts. In the data story, use visualizations, heat maps, boxplots, etc. to describe the following:

  1. How do incomes differ across zip codes within the Phoenix-metro area (using geo-mapping)?
  2. What is the relative difference in incomes across zip codes within the Phoenix-metro area (use a heat map)?
  3. What are the distribution of incomes across Arizona?
  4. How do incomes within the Phoenix metro area differ from those outside of that area?

Part 2:

Demonstrate the ability to communicate the analytics story to key stakeholders, including the marketing manager, by creating a 6-10 slide PowerPoint presentation (with speaker notes for each slide). Use the charts generated in Tableau to illustrate the data story as it relates to the income of Arizona residents. The slides and speaker notes should address the following for each chart presented.

  1. What information is the chart providing to stakeholders?
  2. Why is the information in the chart important to key stakeholders?
  3. How can this information be used in making decisions about how marketing dollars can be allocated?
Zip_Code Metro_Area City Median_Income
85003 Yes Phoenix $42,661
85004 Yes Phoenix $29,567
85006 Yes Phoenix $24,983
85007 Yes Phoenix $27,200
85008 Yes Phoenix $34,581
85009 Yes Phoenix $22,137
85012 Yes Phoenix $53,333
85013 Yes Phoenix $46,920
85014 Yes Phoenix $42,162
85015 Yes Phoenix $29,838
85016 Yes Phoenix $46,399
85017 Yes Phoenix $28,385
85018 Yes Phoenix $54,028
85019 Yes Phoenix $29,335
85020 Yes Phoenix $43,927
85021 Yes Phoenix $37,445
85022 Yes Phoenix $46,529
85023 Yes Phoenix $47,646
85024 Yes Phoenix $63,864
85027 Yes Phoenix $52,137
85028 Yes Phoenix $89,030
85029 Yes Phoenix $42,137
85031 Yes Phoenix $23,054
85032 Yes Phoenix $47,691
85033 Yes Phoenix $32,935
85034 Yes Phoenix $21,052
85035 Yes Phoenix $31,065
85037 Yes Phoenix $47,869
85040 Yes Phoenix $30,664
85041 Yes Phoenix $41,438
85042 Yes Phoenix $45,420
85043 Yes Phoenix $40,636
85044 Yes Phoenix $67,154
85045 Yes Phoenix $109,500
85048 Yes Phoenix $95,628
85050 Yes Phoenix $80,233
85051 Yes Phoenix $38,389
85053 Yes Phoenix $44,039
85054 Yes Phoenix $75,093
85083 Yes Phoenix $101,453
85085 Yes Phoenix $80,342
85086 Yes Phoenix $80,477
85087 No New River $74,275
85118 Yes Apache Junction $63,492
85119 Yes Apache Junction $44,200
85120 Yes Apache Junction $34,808
85121 Yes Bapchule $32,891
85122 No Casa Grande $44,150
85123 No Arizona City $45,231
85128 No Coolidge $40,820
85131 No Eloy $28,130
85132 No Florence $48,625
85135 No Hayden $39,531
85137 No Kearny $44,762
85138 No Maricopa $65,290
85139 No Maricopa $56,168
85140 Yes San Tan Valley $57,585
85141 No Picacho $31,875
85142 Yes Queen Creek $71,927
85143 Yes San Tan Valley $59,830
85145 No Red Rock $55,962
85147 Yes Sacaton $22,000
85172 No Stanfield $35,467
85173 No Superior $43,750
85192 No Winkelman $52,604
85193 No Casa Grande $49,777
85194 No Casa Grande $47,190
85201 Yes Mesa $34,532
85202 Yes Mesa $41,513
85203 Yes Mesa $45,346
85204 Yes Mesa $43,912
85205 Yes Mesa $43,341
85206 Yes Mesa $45,557
85207 Yes Mesa $64,728
85208 Yes Mesa $44,455
85209 Yes Mesa $55,329
85210 Yes Mesa $37,322
85212 Yes Mesa $78,902
85213 Yes Mesa $57,220
85215 Yes Mesa $55,994
85224 Yes Chandler $61,754
85225 Yes Chandler $55,753
85226 Yes Chandler $76,253
85233 Yes Gilbert $74,668
85234 Yes Gilbert $78,649
85248 Yes Chandler $67,301
85249 Yes Chandler $99,910
85250 Yes Scottsdale $59,840
85251 Yes Scottsdale $50,159
85253 Yes Paradise Valley $112,005
85254 Yes Scottsdale $90,236
85255 Yes Scottsdale $112,531
85256 Yes Scottsdale $35,212
85257 Yes Scottsdale $50,740
85258 Yes Scottsdale $73,526
85259 Yes Scottsdale $100,250
85260 Yes Scottsdale $75,916
85262 Yes Scottsdale $133,199
85263 Yes Rio Verde $107,606
85264 Yes Fort McDowell $50,833
85266 Yes Scottsdale $103,883
85268 Yes Fountain Hills $72,530
85281 Yes Tempe $31,600
85282 Yes Tempe $49,173
85283 Yes Tempe $51,837
85284 Yes Tempe $111,145
85286 Yes Chandler $90,451
85295 Yes Gilbert $87,267
85296 Yes Gilbert $84,714
85297 Yes Gilbert $87,049
85298 Yes Gilbert $91,961
85301 Yes Glendale $26,802
85302 Yes Glendale $41,574
85303 Yes Glendale $48,739
85304 Yes Glendale $60,518
85305 Yes Glendale $62,689
85306 Yes Glendale $55,405
85307 Yes Glendale $47,757
85308 Yes Glendale $68,166
85309 Yes Glendale Luke AFB
85310 Yes Glendale $90,077
85320 No Aguila $24,423
85321 No Ajo $26,833
85322 No Arlington $36,154
85323 Yes Avondale $45,159
85324 No Black Canyon City $36,150
85325 No Bouse $29,306
85326 No Buckeye $50,546
85328 No Cibola $44,489
85331 Yes Cave Creek $90,038
85332 No Congress $35,917
85333 No Dateland $36,250
85334 No Ehrenberg $33,958
85335 Yes El Mirage $47,564
85336 No Gadsden $30,000
85337 No Gila Bend $33,311
85338 Yes Goodyear $65,583
85339 Yes Laveen $63,690
85340 Yes Litchfield Park $78,202
85341 No Lukeville
85342 No Morristown $43,750
85343 No Palo Verde $32,404
85344 No Parker $35,846
85345 Yes Peoria $44,513
85346 No Quartzsite $41,340
85347 No Roll $36,689
85348 No Salome $36,084
85349 No San Luis $31,064
85350 No Somerton $31,834
85351 Yes Sun City $34,729
85352 No Tacna $24,250
85353 Yes Tolleson $52,371
85354 No Tonopah $48,241
85355 Yes Waddell $72,919
85356 No Wellton $40,592
85357 No Wenden $30,625
85360 No Wikieup $26,719
85361 No Wittmann $50,000
85362 No Yarnell $26,250
85363 No Youngtown $35,737
85364 No Yuma $38,686
85365 No Yuma $50,979
85367 No Yuma $52,200
85371 No Poston $23,182
85373 Yes Sun City $50,266
85374 Yes Surprise $48,143
85375 Yes Sun City West $46,622
85377 Yes Carefree $85,436
85379 Yes Surprise $71,066
85381 Yes Peoria $70,980
85382 Yes Peoria $63,135
85383 Yes Peoria $102,047
85387 Yes Surprise $61,078
85388 Yes Surprise $67,900
85390 No Wickenburg $40,081
85392 Yes Avondale $66,947
85395 Yes Goodyear $76,453
85396 No Buckeye $76,314
85501 No Globe $40,400
85530 No Bylas $23,304
85531 No Central $52,857
85533 No Clifton $49,125
85534 No Duncan $33,065
85535 No Eden
85536 No Fort Thomas $33,281
85539 No Miami $45,462
85540 No Morenci $65,133
85541 No Payson $40,690
85542 No Peridot $32,125
85543 No Pima $45,673
85544 No Pine $49,805
85545 No Roosevelt $38,155
85546 No Safford $47,681
85550 No San Carlos $31,250
85551 No Solomon $52,422
85552 No Thatcher $52,533
85553 No Tonto Basin $35,190
85554 No Young $50,114
85601 No Arivaca $30,781
85602 No Benson $40,496
85603 No Bisbee $33,726
85605 No Bowie $33,542
85606 No Cochise $40,625
85607 No Douglas $26,684
85608 No Douglas
85609 No Dragoon $58,967
85610 No Elfrida $45,461
85611 No Elgin $39,519
85613 No Fort Huachuca $55,000
85614 No Green Valley $48,300
85615 No Hereford $54,780
85616 No Huachuca City $41,477
85617 No Mc Neal $36,438
85618 No Mammoth $36,875
85619 No Mount Lemmon
85620 No Naco $26,964
85621 No Nogales $27,952
85622 No Green Valley $55,842
85623 No Oracle $55,082
85624 No Patagonia $39,038
85625 No Pearce $36,276
85626 No Pirtleville $14,070
85627 No Pomerene $49,000
85629 No Sahuarita $62,939
85630 No Saint David $44,286
85631 No San Manuel $42,952
85632 No San Simon $36,417
85633 No Sasabe $24,250
85634 No Sells $26,250
85635 No Sierra Vista $54,022
85637 No Sonoita $70,129
85638 No Tombstone $32,500
85640 No Tumacacori $23,750
85641 No Vail $83,824
85643 No Willcox $42,998
85645 No Amado $50,036
85646 No Tubac $50,606
85648 No Rio Rico $50,680
85650 No Sierra Vista $77,730
85653 No Marana $57,143
85654 No Rillito $9,409
85658 No Marana $84,788
85701 No Tucson $36,211
85704 No Tucson $52,214
85705 No Tucson $24,489
85706 No Tucson $30,000
85707 No Tucson
85708 No Tucson $47,440
85710 No Tucson $42,049
85711 No Tucson $32,815
85712 No Tucson $32,109
85713 No Tucson $33,301
85714 No Tucson $25,604
85715 No Tucson $55,694
85716 No Tucson $33,313
85718 No Tucson $79,155
85719 No Tucson $29,100
85723 No Tucson
85724 No Tucson
85726 No Tucson
85730 No Tucson $46,558
85735 No Tucson $47,333
85736 No Tucson $37,400
85737 No Tucson $80,789
85739 No Tucson $60,681
85741 No Tucson $51,410
85742 No Tucson $68,209
85743 No Tucson $69,139
85745 No Tucson $47,432
85746 No Tucson $41,419
85747 No Tucson $84,230
85748 No Tucson $65,035
85749 No Tucson $85,861
85750 No Tucson $73,029
85755 No Tucson $83,326
85756 No Tucson $45,684
85757 No Tucson $53,300
85901 No Show Low $40,393
85911 No Cibecue $12,031
85912 No White Mountain Lake $24,738
85920 No Alpine $41,827
85922 No Blue $33,125
85923 No Clay Springs $12,122
85924 No Concho $34,702
85925 No Eagar $52,333
85926 No Fort Apache $56,750
85927 No Greer $40,804
85928 No Heber $26,159
85929 No Lakeside $43,220
85930 No McNary $40,893
85931 No Forest Lakes $32,143
85932 No Nutrioso $28,750
85933 No Overgaard $36,488
85934 No Pinedale $57,625
85935 No Pinetop $62,811
85936 No Saint Johns $36,628
85937 No Snowflake $52,159
85938 No Springerville $39,612
85939 No Taylor $55,657
85940 No Vernon $47,050
85941 No Whiteriver $26,614
85942 No Woodruff
86001 No Flagstaff $46,328
86003 No Flagstaff
86004 No Flagstaff $59,714
86011 No Flagstaff $20,039
86015 No Bellemont
86016 No Gray Mountain $20,833
86017 No Munds Park $34,600
86018 No Parks $44,050
86020 No Cameron $30,441
86021 No Colorado City $30,962
86022 No Fredonia $47,530
86023 No Grand Canyon $29,421
86024 No Happy Jack $66,458
86025 No Holbrook $46,563
86028 No Petrified Forest Natl Pk
86029 No Sun Valley $13,105
86030 No Hotevilla $35,964
86031 No Indian Wells $14,934
86032 No Joseph City $47,396
86033 No Kayenta $21,633
86034 No Keams Canyon $21,548
86035 No Leupp $29,201
86036 No Marble Canyon $25,543
86038 No Mormon Lake
86039 No Kykotsmovi Village $18,636
86040 No Page $52,690
86042 No Polacca $35,000
86043 No Second Mesa $31,713
86044 No Tonalea $23,750
86045 No Tuba City $45,833
86046 No Williams $47,279
86047 No Winslow $34,355
86052 No North Rim
86053 No Kaibeto $28,792
86054 No Shonto $29,375
86301 No Prescott $45,587
86303 No Prescott $45,727
86305 No Prescott $58,264
86313 No Prescott
86314 No Prescott Valley $40,298
86315 No Prescott Valley $56,180
86320 No Ash Fork $26,204
86321 No Bagdad $64,617
86322 No Camp Verde $38,039
86323 No Chino Valley $43,439
86324 No Clarkdale $45,297
86325 No Cornville $43,777
86326 No Cottonwood $38,341
86327 No Dewey $50,269
86329 No Humboldt $47,628
86331 No Jerome $25,641
86332 No Kirkland $36,484
86333 No Mayer $37,446
86334 No Paulden $43,984
86335 No Rimrock $41,528
86336 No Sedona $49,796
86337 No Seligman $32,554
86338 No Skull Valley $38,264
86343 No Crown King $38,500
86351 No Sedona $58,443
86401 No Kingman $43,692
86403 No Lake Havasu City $37,807
86404 No Lake Havasu City $41,050
86406 No Lake Havasu City $44,981
86409 No Kingman $31,237
86411 No Hackberry $45,735
86413 No Golden Valley $33,662
86426 No Fort Mohave $41,600
86429 No Bullhead City $41,176
86431 No Chloride $16,484
86432 No Littlefield $35,548
86433 No Oatman $4,560
86434 No Peach Springs $37,083
86435 No Supai $44,750
86436 No Topock $34,004
86437 No Valentine $32,188
86438 No Yucca $31,516
86440 No Mohave Valley $39,167
86441 No Dolan Springs $24,571
86442 No Bullhead City $36,395
86443 No Temple Bar Marina
86444 No Meadview $21,458
86445 No Willow Beach $50,142
86502 No Chambers $21,000
86503 No Chinle $30,904
86504 No Fort Defiance $34,854
86505 No Ganado $23,529
86506 No Houck $21,944
86507 No Lukachukai $22,188
86508 No Lupton $20,682
86510 No Pinon $21,816
86511 No Saint Michaels $31,563
86512 No Sanders $23,482
86514 No Teec Nos Pos $21,205
86515 No Window Rock $34,375
86520 No Blue Gap $16,250
86535 No Dennehotso $22,386
86538 No Many Farms $35,750
86540 No Nazlini $19,524
86544 No Red Valley $25,682
86545 No Rock Point $26,705
86547 No Round Rock $22,647
86556 No Tsaile $19,954