Location Salesperson Angie Bryon Celinda Deron Emelia Frank Gena Harvey Imogene Jorge Katalin Levar Montgomery Elmore Opelika Opelika Montgomery Opelika Elmore Montgomery Opelika Montgomery Elmore Montgomery Years of Experience 1 4 7 15 12 2 14 8 8 4 8 2 Number of cars sold 12 14 19 25 25 4 7 12 8 35 22 10 Total price of all cars sold $157,321.77 $99,999.99 $178,547.25 $479,500.07 $548,347.00 $25,100.72 $106,855.97 $238,654.21 $350,471.82 318.50 $175,687.74 $72,089.36 . Required Enter the above data, as shown, with Salesperson starting in cell F1. For all of the following, use the number below as a label in column B and put the formula that calculates the answer in column C. 1. How many of the salespeople work at the Montgomery location? 2. How many of the salespeople have more than 5 years of experience and sold at least 15 cars? 3. What is the average number of cars sold at the Elmore location? 4. What is the median of the total price of all cars sold? 5. What was the 4th largest number of cars sold? 6. What is the 3rd smallest years of experience? 7. Calculate the variance of the number of cars sold assuming that the above list is the entire population. 8. Calculate the standard deviation of the total price of all cars sold assuming that the above list is a sample. 9. Calculate the average number of cars sold by employees at the Opelika location and have less than 10 years of experience. 10. What is the mode of the years of experience? 11. Use the Data Analysis ToolPak to create the summary statistics for the number of cars sold and the total price of all cars sold on a new worksheet named Summary The worksheet Summary must be the last worksheet in the workbook