5. Your friend is a web analyst for a major insurance company. He called you and presented following data. It contains information about number of vehicles sold in major US cities and number of insurance claims received from each of them for the year 2000) - 20 marks City (Column A Los Angeles Chica Houston Phoenix Philadelphia San Antonio Austin Dallas San Fransico Seattle Denver Washington Number of new vehicles sold in major cities across USA-In 2020 (Column) 73450 69375 81252 85627 95236 91771 103211 101256 103514 Number of insurance daims submitted on the portal Column C) 1740 1538 2251 1936 2407 2214 2778 2536 2231 107412 84129 2015 2413 3493 ro o c ma 20 S 2 & 3 4 5 7 8 9 VA Pla E R. . Y U o $ G H J K L C V B N. M, cente Media M w Helo Share Doments I Nema No Header Heading? Tele Dieta Eating Vete at City (Columna Number of new vehicles sold in major cities across USA in 2020 (Columna) 73450 69375 81252 85627 95236 91771 103211 101256 103514 Number of insurance claims submitted on the portal Column) 1740 1538 7251 1926 2407 2214 2778 2536 2231 Los Angeles Chica Houston Phoenix Philadelphia San Antonio Austin Dulos San Fransico Seattle Derves Washington Boston Nashville Memphis Portland New York Millwaukee Tucson Sacramento Atlanta 2015 2413 3493 2512 98451 107412 84129 87321 77414 81881 81578 106745 74514 68741 85369 2254 2114 2705 2550 1851 1630 PORR 1814 8PM 1220221 O RI - C 3 6 N 00 3 2 S P. U T R Y 5 K 7 . F B N M LO more M Share 1 Prin- SAADET Axbox AaBbc abcc Aab Tom Tag ding? Sem tang Ver a. Given that the coefficient of corriolation between Colunist and Column C0.52. comment on the relationship between number of new vehides sold and number of insurance aims submitted for the cities (you don't have to comment on each city, just give an overall ummary b. The company is planning to include 2 new cities for which they gathered following City Kansas City Salt Lake City Number of new vehicles sold 56215 137899 Table 4 ro O du EY 5 7 8 3 9 1 Ya 2 R E T Y 1 U F G H J L V B N. M City Kansas City Salt Lake City Number of new vehicles sold 56215 137899 Table 4 Your another good-of-heart anonymous friend, ran the linear regression on this table and presented you with following information Intercept-c-value of Cars sold Slope' m- of cars sold 516.1742558 0.019522274 Based on all the information in your hands now, estimate the number of insurance claims that will be submitted form Kansas City andSalt Lake City. You can use the equation y=mx+c to estimate the numbers
