Chapter 11: Summarization (Summarize (Functions that can be applied to…
Chapter 11: Summarization
Available in most programming tools
When summarizing, one or more columns by which to group data is selected, essentially creating a virtual "bucket" for each unique group
Ex: If you are interested in employees, you would summarize via EmployeeID
Possible to summarize by more than one column
Functions that can be applied to each bucket
Order Detail Price = (UnitPrice
Uses the content inside columns to create new columns
A way to deal with data that is currently in "skinny" form and transform what is currently listed in rows to column-form.
Ex: Select a column to be the new row and specify how many columns
Skinny table is a common data form simply because it occurs when one or more data inputs happen over time
Can join two tables to make a larger table. Summarize and Crosstab will get you the data you want in a clearer and concise way
What would table 11.3 look like if Sum was run with the average function?
It would average everything and be smaller