Microsoft Office Tutorials and References
In Depth Information
Exhibit 2.14 Data sort procedure
that ask the user for the key for sorting the data. The key used is Day #. As you
can see in Exhibit 2.14, the ﬁrst 16 sorted observations are for Sunday (Day 1). The
complete sorted data are shown in Table 2.6.
At this point our data have come a long way from 60 basic observations and
are ready to reveal some expenditure behavior. First, notice in Table 2.6 that all
expenditures on Sunday are for food (F), they are made with a credit card, and are
generally the highest $ values. This pattern occurs every Sunday of every week
in the data. Immediately, Dad is alerted to this curious behavior—is it possible
that Tere reserves grocery shopping for Sundays? Also, note that Monday’s cash
expenditures are of lesser value and never for food. Additionally, there are sev-
eral multiple Monday expenditures and they occur irregularly over the weeks of the
semester. Exhibit 2.15 provides a graph of this Sunday and Monday data comparison
and Exhibit 2.16 compares Sunday and Thursday. In each case Dad has organized
the data series by the speciﬁc day of each week. Also, he has aggregated multiple
expenditures for a single day, such as Monday, Jan-14 expenditures of $33.91 and
$36.65 (total $70.56). The Jan-14 quantity can be seen in Exhibit 2.15 in week 2
for Monday, and this has required manual summarization of the data in Table 2.6.
Obviously, there are many other possible daily comparisons that can be performed
and they, too, will require manual summarization.