Microsoft Office Tutorials and References
In Depth Information
Chapter 27: Data Mining Using Pivot Tables
this is true for any number of children the household has. Whether they have 0, 1, 2,
3, or 4 children, they always spend more if they are owners. The previous rela-
tionship also looks to be holding between the decreased spending compared to the
increase in number of children.
At first glance, this looks true in Figure 27.6. However, if you look at the chart,
you will discover that it is not the case. The chart we created in Figure 27.5 is
changing in the background, since the chart is linked to the table. The amount spent
by homeowners suddenly increases when you go from 3 to 4 children. It can be
difficult to tell from the table, but the charts tell it all. See Figure 27.7.
FIGURE 27.6 Homeowners Spend More
FIGURE 27.7 The Amount Spent by Owners Increases When You Move from 3 to 4 Children