Please enable JavaScript.
Coggle requires JavaScript to display documents.
CHAPTER 11: SUMMARIZATION (SUMMARIZE: grouping one or more columns…
CHAPTER 11: SUMMARIZATION
SUMMARIZE: grouping one or more columns together - creating virtual "bucket" for each group
several functions can be applied to data inside each bucket
count
sum
min
max
first
last
average
median
mode
standard deviation
summarize could be run with any information above the level of analysis of "OrderID"
CROSSTAB: uses content inside columns to create new columns
deals with data that is in "skinny form" and transform into column-form
Example: manager wants to evaluate types of drinks employees are drinking
pulls table about types of drinks
applies cross tab to table by selecting "drink name" to become new row and specifies "drink type" column to expand to 3 separate columns (coffee, tea, energy drink)
uses COUNT as function to see number of each drink