QUESTION 1 QUESTION 2

Salesperson Sum - Order Amount Country Salesperson Sum -

Buchanan $2,640.00 UK ###
Davolio $1,800.00 Buchanan ###
Dodsworth $2,400.00 Dodsworth ###
Leverling $5,850.00 Suyama ###
Peacock $11,150.00 USA ###
Suyama $1,600.00 Davolio ###
Total Result $25,440.00 Leverling ###
Peacock ###
Total Result ###
QUESTION 2 (2ND WAY)
Sum - Order Amount Country
Salesperson UK USA Total Result
Buchanan $2,640.00 $2,640.00
Davolio ### $1,800.00
Dodsworth $2,400.00 $2,400.00
Leverling ### $5,850.00
Peacock ### $11,150.00
Suyama $1,600.00 $1,600.00
Total Result $6,640.00 ### $25,440.00
 QUESTION 4 TOP 5 SALES PEOPLE
QUESTION 3 HIGHEST TO LOWEST Salesperson Sum - Order Amount
Salesperson Sum - Order Amount Peacock $11,150.00
Peacock $11,150.00 Leverling $5,850.00
Leverling $5,850.00 Dodsworth $2,400.00
Buchanan $2,640.00 Davolio $1,800.00
Dodsworth $2,400.00 Buchanan $2,640.00
Davolio $1,800.00 Total Result $23,840.00
Suyama $1,600.00
Total Result $25,440.00
Sum - Order AmoSalesperson
Order Date Buchanan Davolio Dodsworth Leverling Peacock Suyama
Q1 $2,640.00 $2,150.00 $2,650.00 $1,600.00
Q2 $2,400.00 $1,300.00
Q3 ### $2,350.00 $4,250.00
Q4 $1,350.00 $2,950.00
Total Result $2,640.00 ### $2,400.00 $5,850.00 ### $1,600.00

QUESTION 5

Salesperson Order Date Sum - Order Amount

Buchanan ###
Q1 ###
Davolio ###
Q3 ###
Dodsworth ###
Q2 ###
Leverling ###
Q1 ###
Q3 ###
Q4 ###
Peacock ###
Q1 ###
Q2 ###
Q3 ###
Q4 ###
Suyama ###
Q1 ###
Total Result ###
Total Result
$9,040.00
$3,700.00
$8,400.00
$4,300.00
$25,440.00
QUESTION 6 QUESTION 7

Order Date Salesperson Sum - Ord Country Order Date Salesp

Q1 $9,040.00 UK
Buchanan $2,640.00 Q1
Leverling $2,150.00 Bucha
Peacock $2,650.00 Suyam
Suyama $1,600.00 Q2
Q2 $3,700.00 Dodswo
Dodsworth $2,400.00 USA
Peacock $1,300.00 Q1
Q3 $8,400.00 Leverli
Davolio $1,800.00 Peacoc
Leverling $2,350.00 Q2
Peacock $4,250.00 Peacoc
Q4 $4,300.00 Q3
Leverling $1,350.00 Davoli
Peacock $2,950.00 Leverli
Total Result ### Peacoc
Q4
Leverli
Peacoc
Total Result
QUESTION 8

Sum - Order AmoSum - Order Amount

$6,640.00 10.38%
$4,240.00 7.08%
$2,640.00 9.43%
$1,600.00 23.00%
$2,400.00 43.83%
$2,400.00 6.29%
$18,800.00 100.00%
$4,800.00
$2,150.00
$2,650.00
$1,300.00
$1,300.00
$8,400.00
$1,800.00
$2,350.00
$4,250.00
$4,300.00
$1,350.00
$2,950.00
$25,440.00
Country Salesperson Sum - Order Amount
UK $6,640.00
Buchanan $2,640.00
Dodsworth $2,400.00
Suyama $1,600.00
USA ### Total
Davolio $1,800.00
10
Leverling $5,850.009
Peacock ###8
Total Result ###7
6
5 Salespers
4
3
2
1
0
UK
USA
Total Result
 Salesperson

Total Result
Country Salesperson Order Date Order ID Order Amount
UK Buchanan 2/16/2003 10248 $440.00
UK Suyama 3/10/2003 10249 $1,600.00
USA Peacock 7/12/2003 10250 $2,500.00
USA Leverling 3/15/2003 10251 $2,150.00
USA Peacock 8/11/2003 10252 $1,750.00
USA Leverling 12/16/2003 10253 $1,350.00
UK Buchanan 3/23/2003 10254 $2,200.00
UK Dodsworth 6/15/2003 10255 $2,400.00
USA Leverling 9/17/2003 10256 $2,350.00
USA Peacock 2/22/2003 10257 $2,650.00
USA Davolio 7/23/2003 10258 $1,800.00
USA Peacock 5/25/2003 10259 $1,300.00
USA Peacock 11/29/2003 10260 $1,450.00
USA Peacock 12/30/2003 10261 $1,500.00

1 What are the order amounts for each salesperson?

2 What are the order amounts for each salesperson in a specific country?
3 How are salespersons ranked by order amounts?
4 What are the top five salespeople?
5 How did salespeople perform in a specific quarter?
6 How did salesperson's performance vary by each quarter?
7 What are the details for the specific order amount?
8 What percent is a specific order of the total order amounts?