Excel Spreadsheet (Accounting)
Assignment 8
Tiger Company sells used cars. Tiger has 3 differentlocations and 12 total salespeople. Data about each salesperson is as follows:
|
Salesperson |
Location |
Years of Experience |
Number of cars sold |
Total price of 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 functionfrom the material in chapter 11 that was covered in class on Monday, October 5.You may use the numbers listed in the required items in the functions.
Required:
Enter the above data, as shown, starting withSalesperson in cell F1.
For items 1-15, use the number below as a labelin column B (cells B1:B15) and put the formula that calculates the answer incolumn C (cells C1:C15).
1. What is the total years of experience of thesalespeople working at the Montgomery location?
2. How many cars were sold by salespeople with lessthan 8 years of experience?
3. Calculate the total price of all cars sold bysalespeople who sold 15 or more cars, and round the total price to the nearestdollar.
4. Calculate the total price of all cars sold byTiger Company and round the total price to the nearest $1,000.
5. Determine the remainder (modulus) from dividingthe total price of all cars sold by Tiger Company by the total number of carssold by Tiger Company.
6. How many of the salespeople work at theMontgomery location?
7. How many of the salespeople have more than 5years of experience and sold at least 15 cars?
8. What is the average number of cars sold at the Elmorelocation?
9. What is the median of the total price of all carssold?
10. Whatwas the 4th largest number of cars sold?
11. Whatis the 3rd smallest years of experience?
12. Calculatethe variance of the number of cars sold assuming that the above list is theentire population.
13. Calculatethe standard deviation of the total price of all cars sold assuming that theabove list is a sample.
14. Calculatethe average number of cars sold by employees at the Opelika location and haveless than 10 years of experience.
15. Whatis the mode of the years of experience?
Use the Data Analysis ToolPak to create thesummary statistics for the number of cars sold and the total price of all carssold on a new worksheet named Summary. The worksheet Summary must be the lastworksheet in the workbook.
Remember to follow all items in the Excel Requirementsdocument.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
