Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chapter 11: Summarization (Summarize (Functions that can be applied to…
Chapter 11: Summarization
Summarize
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
Count
Sum
Min
Max
First
Last
Average
Median
Mode
Standard Deviation
Order Detail Price = (UnitPrice
Quantity)
(1-Discount)
Crosstab
Summarize's Cousin
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
Exercises
What would table 11.3 look like if Sum was run with the average function?
It would average everything and be smaller
Steven Chesney
Email:
stch1109@colorado.edu
Class: 3201-002
Prof: Larsen