top 50 metro area by pop inc pop percapinc profranch (1) Q AutoSave O OFF MAGIC ... Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments A1 X V fx |Top 50 Metro Areas by Population: Personal Income, Population, Per Capita Personal Income A B C D E F G H Top 50 Metro Areas by Population: Personal Income, Population, Per Capita Personal Income Total Metro Per Capita # of NFL, Personal Income Personal Population NBA, MLB, Rank Metro GeoName 2020 (000s Income 2020 2020 (millions) NHL teams W N New York-Newark-Jersey City, NY-NJ-PA 1574364671 82322 19.124359 2 Los Angeles-Long Beach-Anaheim, CA 915132543 69805 13.109903 3 Chicago-Naperville-Elgin, IL-IN-WI 636555184 67671 9.406638 4 Dallas-Fort Worth-Arlington, TX 473604117 61554 7.694138 5 Houston-The Woodlands-Sugar Land, TX 428500645 59893 7.154478 6 Washington-Arlington-Alexandria, DC-VA-MD-WV 485550913 76771 6.324629 7 Miami-Fort Lauderdale-Pompano Beach, FL 396247347 64190 6.173008 8 Philadelphia-Camden-Wilmington, PA-NJ-DE-MD 425748748 69705 6.107906 11 9 Atlanta-Sandy Springs-Alpharetta, GA 357795984 58773 6.087762 12 10 Phoenix-Mesa-Chandler, AZ 262362901 51851 5.059909 13 11 Boston-Cambridge-Newton, MA-NH 418178210 85724 4.878211 14 12 San Francisco-Oakland-Berkeley, CA 521589857 11 1050 4.696902 15 13 Riverside-San Bernardino-Ontario, CA 212234205 45365 4.678371 16 14 Detroit-Warren-Dearborn, MI 251173430 58356 4.304136 17 15 Seattle-Tacoma-Bellevue, WA 323176255 80420 4.018598 - - - NN WA W - A WAOAAAWAAA 18 16 Minneapolis-St. Paul-Bloomington, MN-WI 245833135 67214 3.657477 19 17 San Diego-Chula Vista-Carlsbad, CA 220825596 66266 3.332427 20 18 Tampa-St. Petersburg-Clearwater, FL 169629192 52291 3.243963 21 19 Denver-Aurora-Lakewood, CO 208852979 69822 2.991231 22 20 St. Louis, MO-IL 170697159 60844 2.805473 23 21 Baltimore-Columbia-Towson, MD 186759714 66695 2.800189 24 22 Charlotte-Concord-Gastonia, NC-SC 152149128 56682 2.684276 25 23 Orlando-Kissimmee-Sanford, FL 127277824 48223 2.639374 26 24 San Antonio-New Braunfels, TX 129592611 50022 2.590732 27 25 Portland-Vancouver-Hillsboro, OR-WA 157150249 62603 2.510259 2.374749 - 28 26 Sacramento-Roseville-Folsom, CA 146881794 61852 Sheet1 1 Accessibility: Good to go 229% ReadyAutoSave O OFF MAGIC ... top 50 metro area by pop inc pop percapinc profranch (1) Q Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments A1 X V fx |Top 50 Metro Areas by Population: Personal Income, Population, Per Capita Personal Income A B C D E F G H Top 50 Metro Areas by Population: Personal Income, Population, Per Capita Personal Income Total Metro Per Capita # of NFL, Personal Income Personal Population NBA, MLB, 2 Rank Metro GeoName 2020 (000s Income 2020 2020 (millions) NHL teams 24 22 Charlotte-Concord-Gastonia, NC-SC 152149128 56682 2.684276 25 23 Orlando-Kissimmee-Sanford, FL 127277824 48223 2.639374 - - 26 24 San Antonio-New Braunfels, TX 129592611 50022 2.590732 27 25 Portland-Vancouver-Hillsboro, OR-WA 157150249 62603 2.510259 28 26 Sacramento-Roseville-Folsom, CA 146881794 61852 2.374749 29 27 Las Vegas-Henderson-Paradise, NV 118678768 51244 2.315963 30 28 Pittsburgh, PA 147040883 63675 2.309246 31 29 Austin-Round Rock-Georgetown, TX 148993898 64913 2.295303 32 30 Cincinnati, OH-KY-IN 133097872 59607 2.232907 33 31 Kansas City, MO-KS 126169318 58057 2.173212 34 32 Columbus, OH 120320535 56252 2.138946 35 33 Indianapolis-Carmel-Anderson, IN 126361669 60431 2.091019 36 34 Cleveland-Elyria, OH 120269831 58846 2.043807 37 35 San Jose-Sunnyvale-Santa Clara, CA 239730405 121619 1.97116 38 36 Nashville-Davidson--Murfreesboro--Franklin, TN 121744536 62076 1.961232 - O NO - - - N- OONOW - - NNOW- -- 39 37 Virginia Beach-Norfolk-Newport News, VA-NC 94883251 53310 1.779824 40 38 Providence-Warwick, RI-MA 98890061 60897 1.62389 41 39 Jacksonville, FL 87532441 55125 1.587892 42 40 Milwaukee-Waukesha, WI 95447587 60499 1.577676 43 41 Oklahoma City, OK 75099831 52688 1.425375 44 42 Raleigh-Cary, NC 86478668 60884 1.420376 45 43 Memphis, TN-MS-AR 68992049 51155 1.348678 46 44 Richmond, VA 79704113 61148 1.303469 47 45 New Orleans-Metairie, LA 73652443 57891 1.272258 48 46 Louisville/Jefferson County, KY-IN 70652096 55676 1.268993 49 47 Salt Lake City, UT 71932167 58008 1.240029 Sheet1 Ready 12 Accessibility: Good to go 229%AutoSave O OFF MAGIC ... top 50 metro area by pop inc pop percapinc profranch (1) Q Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments A1 X V fx |Top 50 Metro Areas by Population: Personal Income, Population, Per Capita Personal Income A B C D E F G H Top 50 Metro Areas by Population: Personal Income, Population, Per Capita Personal Income Total Metro Per Capita # of NFL, Personal Income Personal Population NBA, MLB, 2 Rank Metro GeoName 2020 (000s) Income 2020 2020 (millions) NHL teams bu vall Just-Sunny Vale-Santa Clara, CA ZOJIJU4US 38 36 Nashville-Davidson--Murfreesboro--Franklin, TN 121744536 62076 1.961232 39 37 Virginia Beach-Norfolk-Newport News, VA-NC 94883251 53310 1.779824 40 38 Providence-Warwick, RI-MA 98890061 60897 1.62389 41 39 Jacksonville, FL 87532441 55125 1.587892 42 40 Milwaukee-Waukesha, WI 95447587 60499 1.577676 43 41 Oklahoma City, OK 75099831 52688 1.425375 44 42 Raleigh-Cary, NC 86478668 60884 1.420376 45 43 Memphis, TN-MS-AR 68992049 51 155 1.348678 ONO - ONO - - - NOON 46 44 Richmond, VA 79704113 61148 1.303469 47 45 New Orleans-Metairie, LA 73652443 57891 1.272258 48 46 Louisville/Jefferson County, KY-IN 70652096 55676 1.268993 49 47 Salt Lake City, UT 71932167 58008 1.240029 50 48 Hartford-East Hartford-Middletown, CT 80910874 67343 1.201483 51 49 Buffalo-Cheektowaga, NY 62784969 55777 1.125637 52 50 Birmingham-Hoover, AL 60136271 55074 1.091921 53 54 55 56 57 58 59 60 61 62 63 Sheet1 + Ready 12 Accessibility: Good to go 229%in My courses X ST 350 " ST 350 Homework #12 Fall 202 x ST 350 HW #12 - W Home My X (1195) How To Calculate Confic X C Chegg Search X Course Hero X F- C webassign.net/web/Student/Assignment-Responses/submit?dep=30559234&tags=autosave#question4142897_5 * 0 Update & Wolfware Fantasy Labs PRT 375 section 2... |VitalSource AST 350 Login All Sports DIMETIME 5. [-/6.5 Points] DETAILS MY NOTES NBA NFL Professional sports teams in the National Football League (NFL), Major League Baseball (MLB), National Basketball Association (NBA), and National Hockey League (NHL) are in cities across the United States. Population size of the surrounding metropolitan area is an important consideration when deciding to locate a team of one of the above leagues in a city. This Excel file top 50 metro area by pop inc pop percapinc profranch shows the populations of the 50 most populous metropolitan areas in the United States and the number of teams from the above 4 leagues that are located in each metropolitan area. Question 1. What is the slope of the least squares regression line for predicting the number of teams from the population of the metropolitan area? (use 3 decimal places) Question 2. What is the value of SSE, the sum of the squares of the residuals? (use 2 decimal places) Question 3. Estimate o, the standard deviation of the error term in the simple linear regression model. s, estimate of o (use 2 decimal places) Question 4. Calculate SE(b1), the estimate of the standard deviation ob, of the least squares slope b1 sby, estimate of obj (use 4 decimal places) Question 5. What is the value of the test statistic for testing Ho: 1 = 0? Question 6. Select the correct choice below concerning the P-value of the test Ho: B1 = Ha : P1 > 0 O P-value = .05 O P-value .0001 O .05 .05 Question 7. Calculate a 90% confidence interval for the slope of the least squares regression line of # of teams on Population size. lower bound (use 4 decimal places) upper bound (use 4 decimal places) Question 8. For metro areas that have at least 1 professional team, how much does their population have to increase to support another team? million (use 2 decimal places Question 9. What metro area has the fewest teams relative to what its population can support? Louisville/Jefferson County, KY-INin My courses X ST 350 X " ST 350 Homework #12 Fall 20 x ST 350 HW #12 - W Home My X (1195) How To Calculate Confic X C Chegg Search X Course Hero X C webassign.net/web/Student/Assignment-Responses/submit?dep=30559234&tags=autosave#question4142897_5 * 0 Update S Wolfware Fantasy Labs PRT 375 section 2... VitalSource ST 350 Login All Sports DIMETIME Question 1. What is the slope of the least squares regression line for predicting the number of teams from the population of the metropolitan area? (use 3 decimal places) Question 2. What is the value of SSE, the sum of the squares of the residuals? (use 2 decimal places) Question 3. Estimate o, the standard deviation of the error term in the simple linear regression model. s, estimate of o (use 2 decimal places) Question 4. Calculate SE(b1), the estimate of the standard deviation ob, of the least squares slope b1 sby, estimate of obj (use 4 decimal places) Question 5. What is the value of the test statistic for testing Ho: 1 = 0? Question 6. Select the correct choice below concerning the P-value of the test Ho: B1 = 0 Ha: 1 > 0 O P-value = .05 O P-value .0001 O .05 .05 Question 7. Calculate a 90% confidence interval for the slope of the least squares regression line of # of teams on Population size. lower bound (use 4 decimal places upper bound (use 4 decimal places) Question 8. For metro areas that have at least 1 professional team, how much does their population have to increase to support another team? million (use 2 decimal places) Question 9. What metro area has the fewest teams relative to what its population can support? O Louisville/Jefferson County, KY-IN Denver-Aurora-Lakewood, CO New York-Newark-Jersey city, NY-NJ-PA O Riverside-San Bernardino-Ontario, CA Pittsburgh, PA Question 10. What metro area has the most teams relative to what its population can support? O Denver-Aurora-Lakewood, CO O Riverside-San Bernardino-Ontario, CA O Louisville/Jefferson County, KY-IN New York-Newark-Jersey city, NY-NJ-PA O Pittsburgh, PA