Question: Please steps using max, min, large and small functions. Tiger Company sells used cars. Tiger has 3 different locations and 12 total salespeople. Data about

Please steps using max, min, large and small functions.
Please steps using max, min, large and small functions. Tiger Company sells

Tiger Company sells used cars. Tiger has 3 different locations and 12 total salespeople. Data about each salesperson is as follows: Salesperson Location Years of Number of cars Total price of Experience sold all cars sold Angie Montgomery 1 12 $157,321.77 Bryon Elmore 4 14 $99,999.99 Celinda Opelika 7 19 $178.547.25 Deron Opelika 15 25 $479,500.07 Emelia Montgomery 12 25 $548,347.00 Frank Opelika 2 4 $25,100.72 Gena Elmore 14 7 $106,855.97 Harvey Montgomery 8 12 $238.654.21 Imogene Opelika 8 8 $350,471.82 Jorge Montgomery 4 35 $764.318.50 Katalin Elmore 8 22 $175,687.74 Levar Montgomery 2 10 $72,089.36 All of the required formulas must use at least one function from the material in chapter 11 that was covered in class on Monday, October 4. Each of items 1-6 must be solved using a single formula (nesting is allowed). Your formulas may use the numbers listed in the required items. Required: Enter the above data, as shown, with Salesperson starting in cell F1. This is the same data that was used in assignments 8 and 10. For items 1-6, label each item in column B and put the formula that calculates the answer in column C. 1. What is the highest years of experience? 2. What is the lowest total price of all cars sold? 3. What is the fourth highest number of cars sold? 4. What is the third smallest total price of all cars sold? 5. What is the variance of the total price of all cars sold? Assume that this is the entire population 6. What is the standard deviation of the number of cars sold? Assume that this is a sample. Install the Data Analysis add-in. Create descriptive (summary) statistics for the years of experience, number of cars sold, and total price of all cars sold. o You must create the statistics for all three of these at the same time. o The statistics must be created on a new worksheet named Stats. The worksheet containing the data and items 1-6 must be the first worksheet and Stats must be the last worksheet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!