Microsoft Office Tutorials and References
In Depth Information
calculate the subtotal max, min, standard deviation, and sum for the Sales
Com
c.
for cars sold with a rebate, calculate the sum, max, and min for the Rebates.
14. Advanced Problem —A wine supplier, Sac Rebleu, deals with exclusive restau-
rants in New York City. The wine supplier locates hard to ﬁnd and expensive
French wines for the wine stewards of some of the ﬁnest restaurants in the
world. Below is a table of purchases for the month of January. The supplier is a
meticulous man who believes that data reveals le vérité (the truth). Answer the
following questions for Monsieur Rebleu by using Sort, Filter, and Advanced
Filter:
a. Which customer can be described as most generous based on the proportion
of Tip to \$Purchase that they provide?
b. Sort the transactions on and between 1/08/2007 and 1/20/2007 as follows:
i. Alphabetically.
ii. By \$ Purchase in descending order.
iii. Primary sort same as (ii) and secondary as Tip (descending).
c. What is the average \$ Purchase for each steward?
d. What is the sum of Tips for the 3 most frequently transacting stewards?
Obs.
Customer
Date
\$ Purchase
Tip
1
Hoffer
1/2/2007
\$ 249
20
2
Aschbach
1/2/2007
\$ 131
10
3
Jamal
1/3/2007
\$ 156
20
4
Johnson
1/6/2007
\$ 568
120
5
Johnson
1/6/2007
\$ 732
145
6
Aschbach
1/8/2007
\$ 134
10
7
Rodriguez
1/10/2007
\$ 345
35
8
Polari
1/12/2007
\$ 712
125
9
Otto
1/13/2007
\$ 219
10
10
Johnson
1/14/2007
\$ 658
130
11
Otto
1/16/2007
\$ 160
10
12
Hoffer
1/16/2007
\$ 254
20
13
Otto
1/18/2007
\$ 155
10
14
Johnson
1/19/2007
\$ 658
135
15
Hoffer
1/19/2007
\$ 312
20
16
Otto
1/21/2007
\$ 197
10
17
Rodriguez
1/24/2007
\$ 439
40
18
Polari
1/25/2007
\$ 967
200
19
Hoffer
1/26/2007
\$ 250
20
20
Johnson
1/29/2007
\$ 661
130
21
Hoffer
1/31/2007
\$ 254
20
22
Polari
1/31/2007
\$ 843
160

Search JabSto ::

Custom Search