Chapter 3: PivotTables
This chapter focuses on summarizing and describing patterns in data via tables. Tables efficiently convey basic summary information such as counts and averages. Tables can also be a powerful device with which to explore complicated relationships in data. Thus, the work on tables in this chapter will enable you to understand the concepts of the conditional average and regression analysis better. Tables make clear that a particular value can be viewed as the result of a conjunction of conditions or categories. That is a crucial aspect of regression analysis.
A powerful way to tabulate data is Excel’s PivotTable feature.APivotTable enables the user to try a variety of different views of the data. PivotTables, combined with Excel’s formatting and charting, facilitate effective and clear data description.