Metropolitan Statistical Area Population Total Metropolitan Personal Income Per Capita Income college or higher share Akron, OH 697558 19,460,700,000 $ 27,898 0 215 Albany Schenectady Troy, NY 839570 27,631,400,000 $ 32,911 0 256 Albuquerque, NM 877676 22,493,500,000 $ 25,628 0 213 Allentown Bethlehem Easton, PA NJ 820490 24,872,100,000 $ 30,314 0 193 Amarillo, TX 246399 6,480,477,636 $ 26,301 0 154 Anchorage, AK 447361 15,447,300,000 $ 34,530 0 197 Ann Arbor, MI 353632 12,412,500,000 $ 35,100 0 363 Anniston Oxford Jacksonville, AL 114315 2,577,476,393 $ 22,547 0 138 Asheville, NC 499767 12,897,500,000 $ 25,807 0 242 Atlanta Sandy Springs Roswell, GA 5516118 160,670,000,000 $ 29,127 0 243 Atlantic City Hammonton, NJ 262404 7,432,307,504 $ 28,324 0 173 Auburn Opelika, AL 151617 3,776,440,482 $ 24,908 0 214 Augusta Richmond County, GA SC 525394 12,750,000,000 $ 24,268 0 188 Austin Round Rock, TX 1962613 63,812,600,000 $ 32,514 0 281 Bakersfield, CA 862323 17,882,300,000 $ 20,737 0 102 Baltimore Columbia Towson, MD 2708542 96,111,800,000 $ 35,485 0 268 Bangor, ME 152037 3,741,095,743 $ 24,606 0 206 Barnstable Town, MA 241101 9,657,055,990 $ 40,054 0 362 Baton Rouge, LA 818158 21,777,700,000 $ 26,618 0 183 Beaumont Port Arthur, TX 386729 9,180,489,824 $ 23,739 0 118 Bellingham, WA 206010 5,748,075,493 $ 27,902 0 222 Bend Redmond, OR 167578 4,765,019,873 $ 28,435 0 231 Binghamton, NY 229151 6,116,791,993 $ 26,693 0 213 Birmingham Hoover, AL 1113340 29,365,400,000 $ 26,376 0 200 Bismarck, ND 129555 4,370,744,635 $ 33,737 0 240 Blacksburg Christiansburg Radford, VA 178417 3,941,987,086 $ 22,094 0 203 Bloomington, IL 172041 5,044,684,686 $ 29,323 0 294 Bloomington, IN 141019 3,439,507,122 $ 24,390 0 279 Boise City, ID 682123 17,888,800,000 $ 26,225 0 195 Boston Cambridge Newton, MA NH 4732778 193,131,000,000 $ 40,807 0 334 Bremerton Silverdale, WA 250817 8,052,459,166 $ 32,105 0 233 Bridgeport Stamford Norwalk, CT 936202 48,672,000,000 $ 51,989 0 331 Brownsville Harlingen, TX 415081 6,212,273,106 $ 14,966 0 112 Buffalo Cheektowaga Niagara Falls, NY 1121750 32,728,800,000 $ 29,177 0 224 Burlington, NC 154698 3,517,628,064 $ 22,739 0 128 Burlington South Burlington, VT 213860 7,155,896,874 $ 33,461 0 309 Canton Massillon, OH 400842 9,965,753,050 $ 24,862 0 152 Cape Coral Fort Myers, FL 672142 19,238,000,000 $ 28,622 0 203 Champaign Urbana, IL 205583 5,729,704,736 $ 27,871 0 266 Charleston, WV 196754 5,023,590,326 $ 25,532 0 170 Charleston North Charleston, SC 719829 21,261,400,000 $ 29,537 0 234 Charlotte Concord Gastonia, NC SC 2389262 69,034,600,000 $ 28,894 0 223 Chattanooga, TN GA 520323 12,994,400,000 $ 24,974 0 184 Chicago Naperville Elgin, IL IN WI 9392260 303,206,000,000 $ 32,283 0 258 Chico, CA 222144 5,398,272,548 $ 24,301 0 183 Cincinnati, OH KY IN 2073920 61,732,500,000 $ 29,766 0 223 Clarksville, TN KY 305532 6,537,027,815 $ 21,396 0 134 Cleveland Elyria, OH 2041383 59,106,400,000 $ 28,954 0 213 Coeur d'Alene, ID 139416 3,737,656,648 $ 26,809 0 152 College Station Bryan, TX 206578 4,865,747,165 $ 23,554 0 222 Colorado Springs, CO 679001 19,783,400,000 $ 29,136 0 238 Columbia, MO 170336 4,403,915,373 $ 25,854 0 285 Columbia, SC 793126 20,731,800,000 $ 26,139 0 219 Columbus, OH 1868110 57,112,200,000 $ 30,572 0 248 Corpus Christi, TX 478329 12,041,100,000 $ 25,173 0 132 Dallas Fort Worth Arlington, TX 6740079 205,583,000,000 $ 30,502 0 220 Daphne Fairhope Foley, AL 196777 5,218,179,154 $ 26,518 0 204 Dayton, OH 791298 21,176,900,000 $ 26,762 0 192 Decatur, AL 151993 3,527,931,204 $ 23,211 0 108 Decatur, IL 107236 2,854,244,051 $ 26,616 0 173 Deltona Daytona Beach Ormond Beach, FL 603360 14,375,200,000 $ 23,825 0 168 Denver Aurora Lakewood, CO 2809677 100,545,000,000 $ 35,785 0 289 Des Moines West Des Moines, IA 661239 20,964,100,000 $ 31,704 0 235 Detroit Warren Dearborn, MI 4157192 120,061,000,000 $ 28,880 0 214 Dover, DE 170306 4,233,756,045 $ 24,860 0 160 East Stroudsburg, PA 165390 4,307,562,382 $ 26,045 0 185 Eau Claire, WI 154613 4,045,280,119 $ 26,164 0 178 El Centro, CA 176208 2,715,764,370 $ 15,412 0 081 Elkhart Goshen, IN 198864 4,535,834,122 $ 22,809 0 120 El Paso, TX 819571 15,017,500,000 $ 18,324 0 128 Erie, PA 275489 6,755,088,895 $ 24,520 0 197 Eugene, OR 354453 8,711,553,352 $ 24,577 0 204 Fayetteville, NC 320432 7,494,489,614 $ 23,389 0 146 Fayetteville Springdale Rogers, AR MO 457573 12,301,300,000 $ 26,884 0 198 Flagstaff, AZ 136010 3,389,746,131 $ 24,923 0 208 Florence, SC 204123 4,425,715,370 $ 21,682 0 140 Fort Collins, CO 320731 9,353,375,943 $ 29,163 0 292 Fort Wayne, IN 359410 9,019,561,831 $ 25,095 0 190 Fresno, CA 954417 19,408,000,000 $ 20,335 0 127 Gadsden, AL 103117 2,033,078,981 $ 19,716 0 114 Gainesville, FL 254321 6,428,947,874 $ 25,279 0 272 Gainesville, GA 189055 4,512,504,166 $ 23,869 0 165 Glens Falls, NY 127323 3,476,866,338 $ 27,307 0 169 Goldsboro, NC 122852 2,402,637,606 $ 19,557 0 135 Grand Junction, CO 123827 3,535,326,955 $ 28,551 0 167 Grand Rapids Wyoming, MI 894016 23,784,400,000 $ 26,604 0 227 Greensboro High Point, NC 785179 19,011,600,000 $ 24,213 0 187 Greenville, NC 173612 3,786,802,362 $ 21,812 0 193 Greenville Anderson Mauldin, SC 926061 22,784,300,000 $ 24,603 0 188 Gulfport Biloxi Pascagoula, MS 335742 7,339,775,491 $ 21,861 0 149 Hanford Corcoran, CA 149105 2,516,582,043 $ 16,878 0 067 Harrisburg Carlisle, PA 553189 17,329,900,000 $ 31,327 0 223 Harrisonburg, VA 130045 3,073,315,106 $ 23,633 0 172 Hartford West Hartford East Hartford, CT 1198690 44,388,800,000 $ 37,031 0 268 Hickory Lenoir Morganton, NC 404091 8,386,749,951 $ 20,755 0 130 Hilton Head Island Bluffton Beaufort, SC 200818 6,169,199,938 $ 30,720 0 254 Homosassa Springs, FL 138776 3,212,107,763 $ 23,146 0 140 Houma Thibodaux, LA 231884 5,405,267,923 $ 23,310 0 096 Houston The Woodlands Sugar Land, TX 6326744 196,746,000,000 $ 31,097 0 206 Huntsville, AL 410836 12,314,300,000 $ 29,974 0 232 Indianapolis Carmel Anderson, IN 1947694 54,696,500,000 $ 28,083 0 225 Iowa City, IA 140560 4,906,339,532 $ 34,906 0 374 Ithaca, NY 102949 2,932,139,329 $ 28,481 0 334 Jackson, MI 158692 3,631,125,075 $ 22,882 0 138 Jackson, MS 615395 15,154,200,000 $ 24,625 0 199 Jackson, TN 115444 2,455,469,584 $ 21,270 0 175 Jacksonville, FL 1371912 37,954,800,000 $ 27,666 0 193 Janesville Beloit, WI 158509 4,154,915,082 $ 26,212 0 142 Jefferson City, MO 148556 3,648,639,531 $ 24,561 0 178 Johnstown, PA 136155 3,545,724,818 $ 26,042 0 155 Joplin, MO 173244 4,061,096,931 $ 23,441 0 132 Kalamazoo Portage, MI 380926 9,706,504,593 $ 25,481 0 196 Kankakee, IL 109832 2,841,259,005 $ 25,869 0 146 Kansas City, MO KS 2101659 63,842,400,000 $ 30,377 0 239 Knoxville, TN 928767 23,445,900,000 $ 25,244 0 185 La Crosse Onalaska, WI MN 116649 3,279,622,682 $ 28,115 0 227 Lafayette, LA 531708 13,882,800,000 $ 26,110 0 144 Lafayette West Lafayette, IN 182038 4,028,313,317 $ 22,129 0 239 Lake Havasu City Kingman, AZ 218923 4,522,148,991 $ 20,656 0 099 Lakeland Winter Haven, FL 626967 13,066,400,000 $ 20,841 0 141 Lancaster, PA 524751 14,684,500,000 $ 27,984 0 176 Lansing East Lansing, MI 465540 12,282,800,000 $ 26,384 0 220 Laredo, TX 261102 4,033,453,003 $ 15,448 0 099 Las Cruces, NM 210041 3,915,007,008 $ 18,639 0 172 Las Vegas Henderson Paradise, NV 2045551 52,316,800,000 $ 25,576 0 156 Lawrence, KS 114470 3,039,730,306 $ 26,555 0 337 Lebanon, PA 134381 3,512,310,918 $ 26,137 0 131 Lewiston Auburn, ME 105380 2,756,803,996 $ 26,161 0 182 Lima, OH 104571 2,347,078,120 $ 22,445 0 104 Lincoln, NE 297121 8,190,475,021 $ 27,566 0 255 Little Rock North Little Rock Conway, AR 692843 17,986,400,000 $ 25,960 0 208 Los Angeles Long Beach Anaheim, CA 1 31E 07 390,958,000,000 $ 29,844 0 226 Louisville Jefferson County, KY IN 1230384 34,405,700,000 $ 27,963 0 197 Lubbock, TX 289451 7,166,812,382 $ 24,760 0 164 Lynchburg, VA 253487 6,146,123,504 $ 24,246 0 196 Madera, CA 151467 2,719,482,390 $ 17,954 0 070 Manchester Nashua, NH 352622 12,429,500,000 $ 35,249 0 250 Mansfield, OH 120584 2,538,503,373 $ 21,052 0 134 McAllen Edinburg Mission, TX 815083 12,080,800,000 $ 14,822 0 105 Medford, OR 208467 5,222,249,115 $ 25,051 0 191 Memphis, TN MS AR 1222479 31,245,600,000 $ 25,559 0 182 Merced, CA 262332 5,041,021,173 $ 19,216 0 082 Miami Fort Lauderdale West Palm Beach, FL 5837484 158,507,000,000 $ 27,153 0 215 Michigan City La Porte, IN 109749 2,524,150,297 $ 22,999 0 123 Midland, TX 152196 5,961,440,998 $ 39,170 0 175 Milwaukee Waukesha West Allis, WI 1555860 46,031,900,000 $ 29,586 0 243 Minneapolis St Paul Bloomington, MN WI 3493190 124,258,000,000 $ 35,572 0 282 Mobile, AL 409964 9,441,662,965 $ 23,030 0 145 Modesto, CA 524248 11,725,000,000 $ 22,365 0 115 Monroe, LA 153610 3,457,969,699 $ 22,511 0 166 Monroe, MI 148212 4,050,717,413 $ 27,331 0 126 Montgomery, AL 369832 9,217,198,160 $ 24,923 0 183 Morgantown, WV 136689 3,155,018,916 $ 23,082 0 225 Muncie, IN 116461 2,535,894,703 $ 21,775 0 181 Muskegon, MI 171116 3,677,164,727 $ 21,489 0 133 Myrtle Beach Conway North Myrtle Beach, SC NC 413322 10,524,500,000 $ 25,463 0 178 Napa, CA 140030 5,376,398,786 $ 38,395 0 230 Naples Immokalee Marco Island, FL 345551 12,457,600,000 $ 36,051 0 262 Nashville Davidson Murfreesboro Franklin, TN 1906944 54,877,800,000 $ 28,778 0 221 New Haven Milford, CT 854520 28,228,100,000 $ 33,034 0 259 New Orleans Metairie, LA 1238372 35,136,400,000 $ 28,373 0 203 New York Newark Jersey City, NY NJ PA 1 98E 07 722,251,000,000 $ 36,466 0 277 Niles Benton Harbor, MI 153689 4,034,836,507 $ 26,253 0 204 North Port Sarasota Bradenton, FL 743042 23,938,700,000 $ 32,217 0 244 Norwich New London, CT 271606 9,711,817,226 $ 35,757 0 236 Ocala, FL 335424 7,640,162,599 $ 22,778 0 134 Ocean City, NJ 104454 3,389,125,750 $ 32,446 0 202 Odessa, TX 150888 4,021,269,114 $ 26,651 0 105 Ogden Clearfield, UT 559361 14,571,900,000 $ 26,051 0 192 Oklahoma City, OK 1390031 38,436,700,000 $ 27,652 0 192 Olympia Tumwater, WA 263905 8,152,927,664 $ 30,893 0 241 Omaha Council Bluffs, NE IA 981560 29,076,000,000 $ 29,622 0 233 Orlando Kissimmee Sanford, FL 2253912 56,866,300,000 $ 25,230 0 205 Oshkosh Neenah, WI 168158 4,576,638,347 $ 27,216 0 174 Owensboro, KY 105467 2,433,301,708 $ 23,072 0 170 Oxnard Thousand Oaks Ventura, CA 837408 27,393,700,000 $ 32,712 0 217 Palm Bay Melbourne Titusville, FL 553079 15,315,600,000 $ 27,692 0 201 Parkersburg Vienna, WV 102710 2,471,532,437 $ 24,063 0 150 Pensacola Ferry Pass Brent, FL 467594 12,140,000,000 $ 25,963 0 185 Philadelphia Camden Wilmington, PA NJ DE MD 6018062 198,930,000,000 $ 33,056 0 250 Phoenix Mesa Scottsdale, AZ 4424111 120,256,000,000 $ 27,182 0 196 Pittsburgh, PA 2281207 71,986,400,000 $ 31,556 0 246 Pittsfield, MA 127469 4,159,229,256 $ 32,629 0 234 Portland South Portland, ME 519609 17,291,300,000 $ 33,277 0 293 Portland Vancouver Hillsboro, OR WA 2338733 73,275,800,000 $ 31,331 0 254 Port St Lucie, FL 439241 11,855,600,000 $ 26,991 0 163 Prescott, AZ 216766 5,587,282,674 $ 25,776 0 206 Providence Warwick, RI MA 1616678 49,269,400,000 $ 30,476 0 210 Provo Orem, UT 549401 11,785,300,000 $ 21,451 0 194 Pueblo, CO 152712 3,329,882,709 $ 21,805 0 157 Punta Gorda, FL 166977 4,620,592,395 $ 27,672 0 188 Racine, WI 192123 5,475,640,298 $ 28,501 0 177 Raleigh, NC 1287348 40,562,600,000 $ 31,509 0 286 Reading, PA 410170 10,884,900,000 $ 26,538 0 163 Redding, CA 178213 4,309,131,449 $ 24,180 0 150 Reno, NV 434034 12,198,600,000 $ 28,105 0 208 Richmond, VA 1227414 38,392,700,000 $ 31,279 0 232 Riverside San Bernardino Ontario, CA 4389090 98,958,900,000 $ 22,547 0 130 Roanoke, VA 331191 9,265,108,493 $ 27,975 0 201 Rochester, NY 1108109 31,912,500,000 $ 28,799 0 227 Rockford, IL 336821 8,711,764,993 $ 25,865 0 159 Rocky Mount, NC 147414 2,949,434,370 $ 20,008 0 105 Sacramento Roseville Arden Arcade, CA 2220523 66,248,300,000 $ 29,835 0 216 Saginaw, MI 192418 4,605,856,459 $ 23,937 0 163 St George, UT 150196 3,309,251,496 $ 22,033 0 181 St Joseph, MO KS 117924 2,751,307,081 $ 23,331 0 132 St Louis, MO IL 2801153 84,234,100,000 $ 30,071 0 227 Salinas, CA 484208 12,417,800,000 $ 25,646 0 156 Salisbury, MD DE 385350 11,217,800,000 $ 29,111 0 183 Salt Lake City, UT 1186189 32,505,500,000 $ 27,403 0 197 San Angelo, TX 115283 2,824,009,320 $ 24,496 0 130 San Antonio New Braunfels, TX 2226513 56,971,500,000 $ 25,588 0 175 San Diego Carlsbad, CA 3223952 103,002,000,000 $ 31,949 0 259 San Francisco Oakland Hayward, CA 4547866 198,638,000,000 $ 43,677 0 340 San Jose Sunnyvale Santa Clara, CA 1871208 83,127,800,000 $ 44,425 0 344 San Luis Obispo Paso Robles Arroyo Grande, CA 277813 8,341,659,926 $ 30,026 0 222 Santa Cruz Watsonville, CA 269544 9,354,119,221 $ 34,704 0 269 Santa Fe, NM 147299 4,707,003,426 $ 31,955 0 297 Santa Maria Santa Barbara, CA 434467 13,197,800,000 $ 30,377 0 218 Santa Rosa, CA 495475 17,302,500,000 $ 34,921 0 242 Scranton Wilkes Barre Hazleton, PA 491216 12,130,500,000 $ 24,695 0 187 Seattle Tacoma Bellevue, WA 3628421 133,958,000,000 $ 36,919 0 286 Sebastian Vero Beach, FL 144259 4,262,079,800 $ 29,545 0 190 Sheboygan, WI 113813 3,082,331,175 $ 27,082 0 153 Shreveport Bossier City, LA 413261 10,107,800,000 $ 24,459 0 157 Spartanburg, SC 292092 6,700,811,698 $ 22,941 0 165 Spokane Spokane Valley, WA 585029 15,079,400,000 $ 25,775 0 185 Springfield, IL 198257 6,428,210,017 $ 32,424 0 241 Springfield, MA 569943 16,003,400,000 $ 28,079 0 213 Springfield, MO 400940 9,279,755,087 $ 23,145 0 195 Springfield, OH 135766 3,054,017,497 $ 22,495 0 125 State College, PA 158277 4,015,869,811 $ 25,372 0 276 Stockton Lodi, CA 705579 16,444,200,000 $ 23,306 0 121 Syracuse, NY 668301 18,357,300,000 $ 27,469 0 223 Tampa St Petersburg Clearwater, FL 2884010 79,051,800,000 $ 27,410 0 205 Toledo, OH 640346 16,533,100,000 $ 25,819 0 187 Topeka, KS 223187 6,233,323,976 $ 27,929 0 199 Trenton, NJ 368766 14,417,000,000 $ 39,095 0 290 Tucson, AZ 992302 25,753,100,000 $ 25,953 0 212 Tuscaloosa, AL 218510 4,934,844,487 $ 22,584 0 179 Tyler, TX 214491 5,109,367,250 $ 23,821 0 178 Urban Honolulu, HI 978522 30,161,800,000 $ 30,824 0 232 Utica Rome, NY 274224 6,748,940,081 $ 24,611 0 165 Vallejo Fairfield, CA 425939 12,034,800,000 $ 28,255 0 170 Virginia Beach Norfolk Newport News, VA NC 1641791 47,632,300,000 $ 29,012 0 204 Visalia Porterville, CA 452494 8,131,954,835 $ 17,971 0 072 Waco, TX 238999 5,245,283,296 $ 21,947 0 145 Washington Arlington Alexandria, DC VA MD WV 5862852 257,424,000,000 $ 43,908 0 354 Wausau, WI 134905 3,696,915,570 $ 27,404 0 160 Wenatchee, WA 112244 2,676,364,715 $ 23,844 0 168 Wichita, KS 600896 15,844,700,000 $ 26,368 0 203 Wichita Falls, TX 130707 3,080,761,574 $ 23,570 0 164 Wilmington, NC 270745 8,102,550,278 $ 29,927 0 253 Winston Salem, NC 627709 15,371,700,000 $ 24,489 0 181 Worcester, MA CT 919002 29,244,300,000 $ 31,822 0 240 Yakima, WA 243342 5,105,475,029 $ 20,981 0 094 York Hanover, PA 437289 12,156,800,000 $ 27,800 0 177 Youngstown Warren Boardman, OH PA 549405 12,816,200,000 $ 23,327 0 148 Yuba City, CA 168272 3,660,414,923 $ 21,753 0 115 Yuma, AZ 199685 3,825,395,479 $ 19,157 0 087 2 A number of regional economists suggest that a labor force with a higher share of college graduates sets the base for a more successful metropolitan area Using the data associated with this problem set on Blackboard, regress the per capita personal income by metropolitan area on the share of the adult population that has a college degree or higher by metropolitan area Present a table with your results 3 Use excel to graph the basic data and the estimated regression line from (2) Write a short paragraph interpreting those findings, their significance and their limitations 4 Using the equation you estimated in (2) what would you predict would be the increase in per capita personal income in Chicago if the share of the adult population with a college degree increased by five percentage points Explain

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 06, 2024

Metropolitan Statistical Area Population Total Metropolitan Personal Income Per Capita Income college or higher share Akron, OH 697558 19,460,700,000 $ 27,898 0.215 Albany-Schenectady-Troy, NY 839570

Metropolitan Statistical Area	Population	Total Metropolitan Personal Income	Per Capita Income	college or higher share
Akron, OH	697558	19,460,700,000	$ 27,898	0.215
Albany-Schenectady-Troy, NY	839570	27,631,400,000	$ 32,911	0.256
Albuquerque, NM	877676	22,493,500,000	$ 25,628	0.213
Allentown-Bethlehem-Easton, PA-NJ	820490	24,872,100,000	$ 30,314	0.193
Amarillo, TX	246399	6,480,477,636	$ 26,301	0.154
Anchorage, AK	447361	15,447,300,000	$ 34,530	0.197
Ann Arbor, MI	353632	12,412,500,000	$ 35,100	0.363
Anniston-Oxford-Jacksonville, AL	114315	2,577,476,393	$ 22,547	0.138
Asheville, NC	499767	12,897,500,000	$ 25,807	0.242
Atlanta-Sandy Springs-Roswell, GA	5516118	160,670,000,000	$ 29,127	0.243
Atlantic City-Hammonton, NJ	262404	7,432,307,504	$ 28,324	0.173
Auburn-Opelika, AL	151617	3,776,440,482	$ 24,908	0.214
Augusta-Richmond County, GA-SC	525394	12,750,000,000	$ 24,268	0.188
Austin-Round Rock, TX	1962613	63,812,600,000	$ 32,514	0.281
Bakersfield, CA	862323	17,882,300,000	$ 20,737	0.102
Baltimore-Columbia-Towson, MD	2708542	96,111,800,000	$ 35,485	0.268
Bangor, ME	152037	3,741,095,743	$ 24,606	0.206
Barnstable Town, MA	241101	9,657,055,990	$ 40,054	0.362
Baton Rouge, LA	818158	21,777,700,000	$ 26,618	0.183
Beaumont-Port Arthur, TX	386729	9,180,489,824	$ 23,739	0.118
Bellingham, WA	206010	5,748,075,493	$ 27,902	0.222
Bend-Redmond, OR	167578	4,765,019,873	$ 28,435	0.231
Binghamton, NY	229151	6,116,791,993	$ 26,693	0.213
Birmingham-Hoover, AL	1113340	29,365,400,000	$ 26,376	0.200
Bismarck, ND	129555	4,370,744,635	$ 33,737	0.240
Blacksburg-Christiansburg-Radford, VA	178417	3,941,987,086	$ 22,094	0.203
Bloomington, IL	172041	5,044,684,686	$ 29,323	0.294
Bloomington, IN	141019	3,439,507,122	$ 24,390	0.279
Boise City, ID	682123	17,888,800,000	$ 26,225	0.195
Boston-Cambridge-Newton, MA-NH	4732778	193,131,000,000	$ 40,807	0.334
Bremerton-Silverdale, WA	250817	8,052,459,166	$ 32,105	0.233
Bridgeport-Stamford-Norwalk, CT	936202	48,672,000,000	$ 51,989	0.331
Brownsville-Harlingen, TX	415081	6,212,273,106	$ 14,966	0.112
Buffalo-Cheektowaga-Niagara Falls, NY	1121750	32,728,800,000	$ 29,177	0.224
Burlington, NC	154698	3,517,628,064	$ 22,739	0.128
Burlington-South Burlington, VT	213860	7,155,896,874	$ 33,461	0.309
Canton-Massillon, OH	400842	9,965,753,050	$ 24,862	0.152
Cape Coral-Fort Myers, FL	672142	19,238,000,000	$ 28,622	0.203
Champaign-Urbana, IL	205583	5,729,704,736	$ 27,871	0.266
Charleston, WV	196754	5,023,590,326	$ 25,532	0.170
Charleston-North Charleston, SC	719829	21,261,400,000	$ 29,537	0.234
Charlotte-Concord-Gastonia, NC-SC	2389262	69,034,600,000	$ 28,894	0.223
Chattanooga, TN-GA	520323	12,994,400,000	$ 24,974	0.184
Chicago-Naperville-Elgin, IL-IN-WI	9392260	303,206,000,000	$ 32,283	0.258
Chico, CA	222144	5,398,272,548	$ 24,301	0.183
Cincinnati, OH-KY-IN	2073920	61,732,500,000	$ 29,766	0.223
Clarksville, TN-KY	305532	6,537,027,815	$ 21,396	0.134
Cleveland-Elyria, OH	2041383	59,106,400,000	$ 28,954	0.213
Coeur d'Alene, ID	139416	3,737,656,648	$ 26,809	0.152
College Station-Bryan, TX	206578	4,865,747,165	$ 23,554	0.222
Colorado Springs, CO	679001	19,783,400,000	$ 29,136	0.238
Columbia, MO	170336	4,403,915,373	$ 25,854	0.285
Columbia, SC	793126	20,731,800,000	$ 26,139	0.219
Columbus, OH	1868110	57,112,200,000	$ 30,572	0.248
Corpus Christi, TX	478329	12,041,100,000	$ 25,173	0.132
Dallas-Fort Worth-Arlington, TX	6740079	205,583,000,000	$ 30,502	0.220
Daphne-Fairhope-Foley, AL	196777	5,218,179,154	$ 26,518	0.204
Dayton, OH	791298	21,176,900,000	$ 26,762	0.192
Decatur, AL	151993	3,527,931,204	$ 23,211	0.108
Decatur, IL	107236	2,854,244,051	$ 26,616	0.173
Deltona-Daytona Beach-Ormond Beach, FL	603360	14,375,200,000	$ 23,825	0.168
Denver-Aurora-Lakewood, CO	2809677	100,545,000,000	$ 35,785	0.289
Des Moines-West Des Moines, IA	661239	20,964,100,000	$ 31,704	0.235
Detroit-Warren-Dearborn, MI	4157192	120,061,000,000	$ 28,880	0.214
Dover, DE	170306	4,233,756,045	$ 24,860	0.160
East Stroudsburg, PA	165390	4,307,562,382	$ 26,045	0.185
Eau Claire, WI	154613	4,045,280,119	$ 26,164	0.178
El Centro, CA	176208	2,715,764,370	$ 15,412	0.081
Elkhart-Goshen, IN	198864	4,535,834,122	$ 22,809	0.120
El Paso, TX	819571	15,017,500,000	$ 18,324	0.128
Erie, PA	275489	6,755,088,895	$ 24,520	0.197
Eugene, OR	354453	8,711,553,352	$ 24,577	0.204
Fayetteville, NC	320432	7,494,489,614	$ 23,389	0.146
Fayetteville-Springdale-Rogers, AR-MO	457573	12,301,300,000	$ 26,884	0.198
Flagstaff, AZ	136010	3,389,746,131	$ 24,923	0.208
Florence, SC	204123	4,425,715,370	$ 21,682	0.140
Fort Collins, CO	320731	9,353,375,943	$ 29,163	0.292
Fort Wayne, IN	359410	9,019,561,831	$ 25,095	0.190
Fresno, CA	954417	19,408,000,000	$ 20,335	0.127
Gadsden, AL	103117	2,033,078,981	$ 19,716	0.114
Gainesville, FL	254321	6,428,947,874	$ 25,279	0.272
Gainesville, GA	189055	4,512,504,166	$ 23,869	0.165
Glens Falls, NY	127323	3,476,866,338	$ 27,307	0.169
Goldsboro, NC	122852	2,402,637,606	$ 19,557	0.135
Grand Junction, CO	123827	3,535,326,955	$ 28,551	0.167
Grand Rapids-Wyoming, MI	894016	23,784,400,000	$ 26,604	0.227
Greensboro-High Point, NC	785179	19,011,600,000	$ 24,213	0.187
Greenville, NC	173612	3,786,802,362	$ 21,812	0.193
Greenville-Anderson-Mauldin, SC	926061	22,784,300,000	$ 24,603	0.188
Gulfport-Biloxi-Pascagoula, MS	335742	7,339,775,491	$ 21,861	0.149
Hanford-Corcoran, CA	149105	2,516,582,043	$ 16,878	0.067
Harrisburg-Carlisle, PA	553189	17,329,900,000	$ 31,327	0.223
Harrisonburg, VA	130045	3,073,315,106	$ 23,633	0.172
Hartford-West Hartford-East Hartford, CT	1198690	44,388,800,000	$ 37,031	0.268
Hickory-Lenoir-Morganton, NC	404091	8,386,749,951	$ 20,755	0.130
Hilton Head Island-Bluffton-Beaufort, SC	200818	6,169,199,938	$ 30,720	0.254
Homosassa Springs, FL	138776	3,212,107,763	$ 23,146	0.140
Houma-Thibodaux, LA	231884	5,405,267,923	$ 23,310	0.096
Houston-The Woodlands-Sugar Land, TX	6326744	196,746,000,000	$ 31,097	0.206
Huntsville, AL	410836	12,314,300,000	$ 29,974	0.232
Indianapolis-Carmel-Anderson, IN	1947694	54,696,500,000	$ 28,083	0.225
Iowa City, IA	140560	4,906,339,532	$ 34,906	0.374
Ithaca, NY	102949	2,932,139,329	$ 28,481	0.334
Jackson, MI	158692	3,631,125,075	$ 22,882	0.138
Jackson, MS	615395	15,154,200,000	$ 24,625	0.199
Jackson, TN	115444	2,455,469,584	$ 21,270	0.175
Jacksonville, FL	1371912	37,954,800,000	$ 27,666	0.193
Janesville-Beloit, WI	158509	4,154,915,082	$ 26,212	0.142
Jefferson City, MO	148556	3,648,639,531	$ 24,561	0.178
Johnstown, PA	136155	3,545,724,818	$ 26,042	0.155
Joplin, MO	173244	4,061,096,931	$ 23,441	0.132
Kalamazoo-Portage, MI	380926	9,706,504,593	$ 25,481	0.196
Kankakee, IL	109832	2,841,259,005	$ 25,869	0.146
Kansas City, MO-KS	2101659	63,842,400,000	$ 30,377	0.239
Knoxville, TN	928767	23,445,900,000	$ 25,244	0.185
La Crosse-Onalaska, WI-MN	116649	3,279,622,682	$ 28,115	0.227
Lafayette, LA	531708	13,882,800,000	$ 26,110	0.144
Lafayette-West Lafayette, IN	182038	4,028,313,317	$ 22,129	0.239
Lake Havasu City-Kingman, AZ	218923	4,522,148,991	$ 20,656	0.099
Lakeland-Winter Haven, FL	626967	13,066,400,000	$ 20,841	0.141
Lancaster, PA	524751	14,684,500,000	$ 27,984	0.176
Lansing-East Lansing, MI	465540	12,282,800,000	$ 26,384	0.220
Laredo, TX	261102	4,033,453,003	$ 15,448	0.099
Las Cruces, NM	210041	3,915,007,008	$ 18,639	0.172
Las Vegas-Henderson-Paradise, NV	2045551	52,316,800,000	$ 25,576	0.156
Lawrence, KS	114470	3,039,730,306	$ 26,555	0.337
Lebanon, PA	134381	3,512,310,918	$ 26,137	0.131
Lewiston-Auburn, ME	105380	2,756,803,996	$ 26,161	0.182
Lima, OH	104571	2,347,078,120	$ 22,445	0.104
Lincoln, NE	297121	8,190,475,021	$ 27,566	0.255
Little Rock-North Little Rock-Conway, AR	692843	17,986,400,000	$ 25,960	0.208
Los Angeles-Long Beach-Anaheim, CA	1.31E+07	390,958,000,000	$ 29,844	0.226
Louisville/Jefferson County, KY-IN	1230384	34,405,700,000	$ 27,963	0.197
Lubbock, TX	289451	7,166,812,382	$ 24,760	0.164
Lynchburg, VA	253487	6,146,123,504	$ 24,246	0.196
Madera, CA	151467	2,719,482,390	$ 17,954	0.070
Manchester-Nashua, NH	352622	12,429,500,000	$ 35,249	0.250
Mansfield, OH	120584	2,538,503,373	$ 21,052	0.134
McAllen-Edinburg-Mission, TX	815083	12,080,800,000	$ 14,822	0.105
Medford, OR	208467	5,222,249,115	$ 25,051	0.191
Memphis, TN-MS-AR	1222479	31,245,600,000	$ 25,559	0.182
Merced, CA	262332	5,041,021,173	$ 19,216	0.082
Miami-Fort Lauderdale-West Palm Beach, FL	5837484	158,507,000,000	$ 27,153	0.215
Michigan City-La Porte, IN	109749	2,524,150,297	$ 22,999	0.123
Midland, TX	152196	5,961,440,998	$ 39,170	0.175
Milwaukee-Waukesha-West Allis, WI	1555860	46,031,900,000	$ 29,586	0.243
Minneapolis-St. Paul-Bloomington, MN-WI	3493190	124,258,000,000	$ 35,572	0.282
Mobile, AL	409964	9,441,662,965	$ 23,030	0.145
Modesto, CA	524248	11,725,000,000	$ 22,365	0.115
Monroe, LA	153610	3,457,969,699	$ 22,511	0.166
Monroe, MI	148212	4,050,717,413	$ 27,331	0.126
Montgomery, AL	369832	9,217,198,160	$ 24,923	0.183
Morgantown, WV	136689	3,155,018,916	$ 23,082	0.225
Muncie, IN	116461	2,535,894,703	$ 21,775	0.181
Muskegon, MI	171116	3,677,164,727	$ 21,489	0.133
Myrtle Beach-Conway-North Myrtle Beach, SC-NC	413322	10,524,500,000	$ 25,463	0.178
Napa, CA	140030	5,376,398,786	$ 38,395	0.230
Naples-Immokalee-Marco Island, FL	345551	12,457,600,000	$ 36,051	0.262
Nashville-Davidson--Murfreesboro--Franklin, TN	1906944	54,877,800,000	$ 28,778	0.221
New Haven-Milford, CT	854520	28,228,100,000	$ 33,034	0.259
New Orleans-Metairie, LA	1238372	35,136,400,000	$ 28,373	0.203
New York-Newark-Jersey City, NY-NJ-PA	1.98E+07	722,251,000,000	$ 36,466	0.277
Niles-Benton Harbor, MI	153689	4,034,836,507	$ 26,253	0.204
North Port-Sarasota-Bradenton, FL	743042	23,938,700,000	$ 32,217	0.244
Norwich-New London, CT	271606	9,711,817,226	$ 35,757	0.236
Ocala, FL	335424	7,640,162,599	$ 22,778	0.134
Ocean City, NJ	104454	3,389,125,750	$ 32,446	0.202
Odessa, TX	150888	4,021,269,114	$ 26,651	0.105
Ogden-Clearfield, UT	559361	14,571,900,000	$ 26,051	0.192
Oklahoma City, OK	1390031	38,436,700,000	$ 27,652	0.192
Olympia-Tumwater, WA	263905	8,152,927,664	$ 30,893	0.241
Omaha-Council Bluffs, NE-IA	981560	29,076,000,000	$ 29,622	0.233
Orlando-Kissimmee-Sanford, FL	2253912	56,866,300,000	$ 25,230	0.205
Oshkosh-Neenah, WI	168158	4,576,638,347	$ 27,216	0.174
Owensboro, KY	105467	2,433,301,708	$ 23,072	0.170
Oxnard-Thousand Oaks-Ventura, CA	837408	27,393,700,000	$ 32,712	0.217
Palm Bay-Melbourne-Titusville, FL	553079	15,315,600,000	$ 27,692	0.201
Parkersburg-Vienna, WV	102710	2,471,532,437	$ 24,063	0.150
Pensacola-Ferry Pass-Brent, FL	467594	12,140,000,000	$ 25,963	0.185
Philadelphia-Camden-Wilmington, PA-NJ-DE-MD	6018062	198,930,000,000	$ 33,056	0.250
Phoenix-Mesa-Scottsdale, AZ	4424111	120,256,000,000	$ 27,182	0.196
Pittsburgh, PA	2281207	71,986,400,000	$ 31,556	0.246
Pittsfield, MA	127469	4,159,229,256	$ 32,629	0.234
Portland-South Portland, ME	519609	17,291,300,000	$ 33,277	0.293
Portland-Vancouver-Hillsboro, OR-WA	2338733	73,275,800,000	$ 31,331	0.254
Port St. Lucie, FL	439241	11,855,600,000	$ 26,991	0.163
Prescott, AZ	216766	5,587,282,674	$ 25,776	0.206
Providence-Warwick, RI-MA	1616678	49,269,400,000	$ 30,476	0.210
Provo-Orem, UT	549401	11,785,300,000	$ 21,451	0.194
Pueblo, CO	152712	3,329,882,709	$ 21,805	0.157
Punta Gorda, FL	166977	4,620,592,395	$ 27,672	0.188
Racine, WI	192123	5,475,640,298	$ 28,501	0.177
Raleigh, NC	1287348	40,562,600,000	$ 31,509	0.286
Reading, PA	410170	10,884,900,000	$ 26,538	0.163
Redding, CA	178213	4,309,131,449	$ 24,180	0.150
Reno, NV	434034	12,198,600,000	$ 28,105	0.208
Richmond, VA	1227414	38,392,700,000	$ 31,279	0.232
Riverside-San Bernardino-Ontario, CA	4389090	98,958,900,000	$ 22,547	0.130
Roanoke, VA	331191	9,265,108,493	$ 27,975	0.201
Rochester, NY	1108109	31,912,500,000	$ 28,799	0.227
Rockford, IL	336821	8,711,764,993	$ 25,865	0.159
Rocky Mount, NC	147414	2,949,434,370	$ 20,008	0.105
Sacramento--Roseville--Arden-Arcade, CA	2220523	66,248,300,000	$ 29,835	0.216
Saginaw, MI	192418	4,605,856,459	$ 23,937	0.163
St. George, UT	150196	3,309,251,496	$ 22,033	0.181
St. Joseph, MO-KS	117924	2,751,307,081	$ 23,331	0.132
St. Louis, MO-IL	2801153	84,234,100,000	$ 30,071	0.227
Salinas, CA	484208	12,417,800,000	$ 25,646	0.156
Salisbury, MD-DE	385350	11,217,800,000	$ 29,111	0.183
Salt Lake City, UT	1186189	32,505,500,000	$ 27,403	0.197
San Angelo, TX	115283	2,824,009,320	$ 24,496	0.130
San Antonio-New Braunfels, TX	2226513	56,971,500,000	$ 25,588	0.175
San Diego-Carlsbad, CA	3223952	103,002,000,000	$ 31,949	0.259
San Francisco-Oakland-Hayward, CA	4547866	198,638,000,000	$ 43,677	0.340
San Jose-Sunnyvale-Santa Clara, CA	1871208	83,127,800,000	$ 44,425	0.344
San Luis Obispo-Paso Robles-Arroyo Grande, CA	277813	8,341,659,926	$ 30,026	0.222
Santa Cruz-Watsonville, CA	269544	9,354,119,221	$ 34,704	0.269
Santa Fe, NM	147299	4,707,003,426	$ 31,955	0.297
Santa Maria-Santa Barbara, CA	434467	13,197,800,000	$ 30,377	0.218
Santa Rosa, CA	495475	17,302,500,000	$ 34,921	0.242
Scranton--Wilkes-Barre--Hazleton, PA	491216	12,130,500,000	$ 24,695	0.187
Seattle-Tacoma-Bellevue, WA	3628421	133,958,000,000	$ 36,919	0.286
Sebastian-Vero Beach, FL	144259	4,262,079,800	$ 29,545	0.190
Sheboygan, WI	113813	3,082,331,175	$ 27,082	0.153
Shreveport-Bossier City, LA	413261	10,107,800,000	$ 24,459	0.157
Spartanburg, SC	292092	6,700,811,698	$ 22,941	0.165
Spokane-Spokane Valley, WA	585029	15,079,400,000	$ 25,775	0.185
Springfield, IL	198257	6,428,210,017	$ 32,424	0.241
Springfield, MA	569943	16,003,400,000	$ 28,079	0.213
Springfield, MO	400940	9,279,755,087	$ 23,145	0.195
Springfield, OH	135766	3,054,017,497	$ 22,495	0.125
State College, PA	158277	4,015,869,811	$ 25,372	0.276
Stockton-Lodi, CA	705579	16,444,200,000	$ 23,306	0.121
Syracuse, NY	668301	18,357,300,000	$ 27,469	0.223
Tampa-St. Petersburg-Clearwater, FL	2884010	79,051,800,000	$ 27,410	0.205
Toledo, OH	640346	16,533,100,000	$ 25,819	0.187
Topeka, KS	223187	6,233,323,976	$ 27,929	0.199
Trenton, NJ	368766	14,417,000,000	$ 39,095	0.290
Tucson, AZ	992302	25,753,100,000	$ 25,953	0.212
Tuscaloosa, AL	218510	4,934,844,487	$ 22,584	0.179
Tyler, TX	214491	5,109,367,250	$ 23,821	0.178
Urban Honolulu, HI	978522	30,161,800,000	$ 30,824	0.232
Utica-Rome, NY	274224	6,748,940,081	$ 24,611	0.165
Vallejo-Fairfield, CA	425939	12,034,800,000	$ 28,255	0.170
Virginia Beach-Norfolk-Newport News, VA-NC	1641791	47,632,300,000	$ 29,012	0.204
Visalia-Porterville, CA	452494	8,131,954,835	$ 17,971	0.072
Waco, TX	238999	5,245,283,296	$ 21,947	0.145
Washington-Arlington-Alexandria, DC-VA-MD-WV	5862852	257,424,000,000	$ 43,908	0.354
Wausau, WI	134905	3,696,915,570	$ 27,404	0.160
Wenatchee, WA	112244	2,676,364,715	$ 23,844	0.168
Wichita, KS	600896	15,844,700,000	$ 26,368	0.203
Wichita Falls, TX	130707	3,080,761,574	$ 23,570	0.164
Wilmington, NC	270745	8,102,550,278	$ 29,927	0.253
Winston-Salem, NC	627709	15,371,700,000	$ 24,489	0.181
Worcester, MA-CT	919002	29,244,300,000	$ 31,822	0.240
Yakima, WA	243342	5,105,475,029	$ 20,981	0.094
York-Hanover, PA	437289	12,156,800,000	$ 27,800	0.177
Youngstown-Warren-Boardman, OH-PA	549405	12,816,200,000	$ 23,327	0.148
Yuba City, CA	168272	3,660,414,923	$ 21,753	0.115
Yuma, AZ	199685	3,825,395,479	$ 19,157	0.087

2. A number of regional economists suggest that a labor force with a higher share of college graduates sets the base for a more successful metropolitan area. Using the data associated with this problem set on Blackboard, regress the per capita personal income by metropolitan area on the share of the adult population that has a college degree or higher by metropolitan area. Present a table with your results.

3. Use excel to graph the basic data and the estimated regression line from (2). Write a short paragraph interpreting those findings, their significance and their limitations.

4. Using the equation you estimated in (2) what would you predict would be the increase in per capita personal income in Chicago if the share of the adult population with a college degree increased by five percentage points? Explain.