Wednesday October 16, 2013 - Traditional Class

Wednesday Oct 16, 2013, we will have traditional class. We will discuss and review Excel. This will include discussing HW#4 - Pivot Tables in detail.

An example similar to HW#4 will be reviewed in detail. This will help in the understanding of Pivot Tables.

What are pivot tables?

In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, a pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a "pivot table") showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary's structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.