1. What is a pivot table

A pivot table is a table that displays statistics generated from a larger table that contains your “raw” data set. This pivot table may display counts, sums, averages and other statistics describing variability. It thus allows you to get an overview over thousands of data points within a few clicks.

This tool is quite powerful, it does not need much time to set up, but it requires that the data set is optimally organised in rows and columns, the data are arranged in categories, and the variables described in the header have unique labels. The efficiency of the pivot table thus relies on your ability to create a “clean” table.

This section is separated into several posts which show you:

  Fant du det du lette etter? Did you find this helpful?
[Average: 0]