TABULATION

[Link Map]
begin comments text sound
line

A pivot table in Excel is an interactive worksheet table which provides an easy way to display and analyse summary information about data stored in an Excel Worksheet. The pivot table on the right is a summary of windsp categorised by winddir (* denotes the missing value category of winddir)

Creating a pivot table

  1. Create the pivot table by using: Data > Pivot table report...
  2. To specify the layout follow the wizard steps. If you highlight variables before you start only those ones will appear in the pivot table selection. The list of variables in the figure on the right is the result of no selection before starting the table.
  3. To create the table, drag the boxes containing the variable names on the right-hand side of the Wizard screen to the area marked column, row or data. In this example, a box containing winddir was moved into COLUMN and windsp was dragged 5 times into the DATA area at the centre of the table. The boxes in the data area were then double-clicked on successively and the appropriate statistic chosen (Count, Average, StDev, Max, Min).
  4. Click Next, then enter the location for the output of the table and finally click Finish.
For making changes and filtering data in a pivot table, see next page.

line
Basic statistics in Excel   23.2.99   Page: 11 of 25