90.2K

Verified Solution

Link Copied!

please show all fuctions.

Eagle Company rents cars. Eagle has 3 different locations and 12 total salespeople. Data about each salesperson is as follows: This is the camn dnco 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 E2. - 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 Tampa location? 2. How many of the salespeople have more than 7 years of experience and rented at least 12 cars? 3. What is the average number of cars rented per salesperson at the New Orleans location? 4. What is the median of the years of experience? 5. What was the 33/4 largest number of cars rented? 6. What is the 5th smallest total price of all cars rented? 7. Calculate the variance of the number of cars rented assuming that the above list is a sample. 8. Calculate the standard deviation of the years of experience assuming that the above list is the entire population. 9. Calculate the average number of cars rented per salesperson at the Montgomery location that have 10 or less 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 rented 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

Answer & Explanation Solved by verified expert

See Answer