Microsoft Office Tutorials and References
In Depth Information
2. Can you ﬁnd any interesting relationships in Tere’s expenditures that Dad has
3. Create a graph similar to Exhibits 2.15 and 2.16 that compares Friday and
4. Perform a single sort of the data in Table 2.6 to reﬂect 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 reﬂecting 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).
years of age
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
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