Microsoft Office Tutorials and References
In Depth Information
2. Can you find any interesting relationships in Tere’s expenditures that Dad has
not noticed?
3. Create a graph similar to Exhibits 2.15 and 2.16 that compares Friday and
Saturday .
4. Perform a single sort of the data in Table 2.6 to reflect the following 3 condi-
tions: 1st—credit card expenditures, 2nd—in chronological order, 3rd—if there
are multiple entries for a day, sort by quantity in ascending fashion.
5. Create a pie chart reflecting the proportion of all expenditures related to Food ,
Personal , and School for Dad and Tere’s example.
6. Create a scatter diagram of Day # and Amount for Dad and Tere’s example.
7. The data below represent information on bank customers at 4 branch locations,
their deposits at the branch, and the percent of the customers over 60 years of
age at the branch. Create graphs that show: (1) line graph for the series No.
Customers and $ Deposits for the various branches and (2) pie graphs for each
quantitative series. Finally, consider how to create a graph that incorporates all
the quantitative series (hint: bubble graph).
Percentofcustomersover60
years of age
Branch
No. customers
$ Deposits
A
1268
23,452,872
0.34
B
3421
123,876,985
0.57
C
1009
12,452,198
0.23
D
3187
97,923,652
0.41
8. For the following data, provide the summarization and manipulation that will
permit you to sort the data by day-of-the-week. Thus, you can sort all Mondays,
Tuesdays, etc. (hint: you will need a good day calculator).
Last name, First name
Date of birth
Contribution
Laffercar, Carole
1/24/76
10,000
Lopez, Hector
9/13/64
12,000
Rose, Kaitlin
2/16/84
34,500
LaMumba, Patty
11/15/46
126,000
Roach, Tere
5/7/70
43,000
Guerrero, Lili
10/12/72
23,000
Bradley, James
1/23/48
100,500
Mooradian, Addison
12/25/97
1,000
Brown, Mac
4/17/99
2,000
Gomez, Pepper
8/30/34
250,000
Kikapoo, Rob
7/13/25
340,000
9. Advanced Problem —Isla Mujeres is an island paradise located very near Cancun,
Mexico. The island government has been run by a prominent family, the
Murillos, for most of four generations. During that time, the island has become a
 
Search JabSto ::




Custom Search