B C D E G K New cars | Used Cars Profit Profit Sales New Car BBB Dealership sold each sold each from New | from Used Profit people Brand Rating week week Car Sales Car Sales A1 17 Ford 5 AA 28609 5256 33865 A2 BT Ford 14 8 AAA 57722 20904 78626 A3 19 Dodge 4 2 AA+ 13400 10562 23962 A 14 Toyota 18 8 AA+ 56952 15544 72496 A5 5 Dodge 10 5 AAA 35920 19275 55195 A6 15 /W 10 8 30550 2976 33526 47 17 VW 15 6 AAA 53250 20238 73488 LD 00 A8 20 Honda 10 6 AAA 41030 20436 51466 10 A9 19 VW 11 7 AAA 14352 17621 51973 11 A10 9 Honda 15 8 AAA 57255 17220 74475 12 A11 8 Honda 11 2 AAA 46123 13864 59987 13 A12 12 Honda 6 5 AA+ 23016 16040 39056 14 A13 13 -ord 14 5 AA 42084 3135 45219 15 A14 16 Ford 8 6 AAA 25616 22242 17858 16 A15 9 VW 20 8 AA 47992 512 53504 17 416 7 VW 6 4 AA 23538 3072 26610 18 A17 10 ord 12 2 AA+ 43656 9846 53502 19 A18 16 Toyota 5 2 AA 17625 1472 19097 20 A19 5 Honda 12 7 AA+ 36720 18668 55388 21 420 13 Honda 15 3 AA 54435 2260 56695 22 A21 6 Ford 5 6 AAA 14515 18018 32533 23 A22 13 Ford 8 2 AA+ 29120 10092 39212 24 423 13 Ford 8 3 AA+ 33456 13244 46700 25 424 13 Honda 11 8 AA+ 42064 14584 56648 26 A25 14 Ford 15 6 AA+ 60645 14654 75299 27 A26 19 VW 12 10 AAA 42528 19819 52347 28 A27 20 11 3 AAA 31097 14451 45548 29 A28 14 Honda 14 2 AAA 52836 14856 67692 30 A29 16 VW 9 4 AA 27540 304 29844 31 430 10 Toyota 13 8 A 42445 4472 46917 32 A31 11 5 4 AA+ 14130 13088 27218 33 A32 15 Dodge 13 7 A 41301 3495 49796 34 A33 5 Ford 25 4 AAA 46584 16728 63312 35 434 17 Toyota 6 8 AA 22950 4736 27686 36 A35 18 Ford 8 7 AAA 14596 22206 36802 37 A36 16 Toyota 11 7 AA 32538 4811 37349 38 437 17 Dodge 13 4 A 51870 2972 54842 39 A38 6 Toyota 8 2 AAA 31776 15460 47236 40 A39 11 Dodge 5 8 AA 20400 4944 25344 41 A40 9 w Ford 4 A 8754 1284 10038 42 43 44 45Use data from the attached spreadsheet that shows a sample of car sales data for various dealerships to answer these questions. i) Calculate the correlation coefficient between the number of salespersons and total profit? .201 b. -.953 c. .334 d. .038 ii) Using a threshold of 3 standard deviations, which of the following are true regarding outliers for new car sales? There are no outliers b. Store A15 is an outlier. c. Store A33 is an outlier. d. Stores A15 and A33 are outliers. iii) Which of the following statements is true? a) Used cars sold has a st dev of 2.30 and is more dispersed (less consistent) than New cars sold b) Used cars sold has a st dev of 10.33 and is less dispersed (more consistent) than New cars sold c) Used cars sold has a st dev of 2.30 and is less dispersed (more consistent) than New cars sold d) Used cars sold has a st dev of 3.93 and is less dispersed (more consistent) than New cars sold