21 Pivot Tables / Cross Tabulation

Where to work

Female

Male

Other

Total

1. Large Corporation

24

16

2

42

2. Small Company

13

15

28

3. Non-profit or Government Agency

8

5

13

4. Other

3

1

1

5

Grand Total

48

37

3

88

Frequency Distributions

Categorical data gets a Pareto Chart

How do you get to School?

Public transit

63

Drive

43

Walk

8

Carpool

8

Other

1

Total

123

Quantitative data gets a histogram

What is your Height in Cm?

140-150

1

150-160

14

160-170

29

170-180

35

180-190

26

190-200

8

Total

113

License

Icon for the Creative Commons Attribution-NonCommercial 4.0 International License

Business Analytics Copyright © by Amy Goldlist is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted.

Share This Book