Home G Paste Assignment 7 - Saved to my Mac Insert Draw Design Layout References Mailings Review View Tell me Share Comments X Times New... 12 v A A Aa 2 | AaBbCcDdE AaBbCcDdE AaBbCcDc AaBbCcDdEe AaBb AaBbCcDdEe BIU ab A Normal No Spacing Heading 1 Heading 2 Title Subtitle Styles Pane Dictate Editor Page 1 of 1 30 of 371 words English (United States) Tiger Company sells used cars. Tiger has 3 different locations and 12 total salespeople. Data about each salesperson is as follows: This is the same data used in Assignment 6. Years of Number of cars Salesperson Angie Total price of Location Montgomery Experience sold all cars sold 8 16 $157,321.77 Bryon Elmore 10 10 $99,999.99 Celinda Deron Emelia Frank Opelika 12 8 $178,547.25 Opelika 7 20 $479,500.07 Montgomery 5 25 $548,347.00 Opelika 1 1 $25,100.72 Gena Harvey Elmore 1 5 $106,855.97 Montgomery 20 12 $238,654.21 Imogene Jorge Katalin Levar Opelika 25 17 $350,471.82 Montgomery 17 34 $764,318.50 Elmore Montgomery 6 7 $175,687.74 4 4 $72,089.36 All of the required formulas must use at least one function from the material in chapter. You may use the numbers listed in the required items in the functions. Required: Enter the above data, as shown, with Salesperson starting in cell F1. For items 1-10, 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? 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. Remember to follow all items in the Excel Requirements document. Focus 110%