Microsoft Office Tutorials and References
In Depth Information
Exhibit 2.18 Dollar expenditures by type
2.5.5 Presenting Data
Exhibits 2.13, 2.14, 2.15, 2.16, 2.17, and 2.18 and Tables 2.4, 2.5, and 2.6 are exam-
ples of the many possible graphs and data tables that can be presented to explore
the questions originally asked by Dad. Each graph requires data preparation to
ﬁt the analytical goal. For example, the construction of the pie charts in Exhibits
2.17 and 2.18 required that we count the number of expenditures of each type
(Food, School, and Personal) and that we sum the dollar expenditures for each type,
respectively.
Dad is now able to examine Tere’s buying patterns more closely, and through
discussion with Tere he ﬁnds some interesting behavior related to the data he has
assembled:
1) The \$17.67 Thursday expenditures are related to Tere’s favorite personal
activity—having a manicure and pedicure. The duplicate charge on a single
Thursday represent a return to have her nails redone once she determines she
is not happy with the ﬁrst outcome.
2) Sunday expenditures are dinners (not grocery shopping) at her favorite sushi
restaurant. The dollar amount of each expenditure is always high because she
treats her friends, Dave and Suzanne, to dinner. Dad determines that this is a
magnanimous, but ﬁscally irresponsible, gesture. She agrees to stop paying for
her friends.
3) There are no expenditures on Wednesday because she has class all day long and
is able to do little else, but study and attend class.
4) To avoid carrying a lot of cash, Tere generally prefers to use a credit card for