Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started