{"id":125,"date":"2023-05-05T12:48:45","date_gmt":"2023-05-05T16:48:45","guid":{"rendered":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/chapter\/pivot-tables-cross-tabulation\/"},"modified":"2023-06-19T13:44:47","modified_gmt":"2023-06-19T17:44:47","slug":"pivot-tables-cross-tabulation","status":"publish","type":"chapter","link":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/chapter\/pivot-tables-cross-tabulation\/","title":{"raw":"Pivot Tables \/ Cross Tabulation","rendered":"Pivot Tables \/ Cross Tabulation"},"content":{"raw":"
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

Where to work<\/p>\r\n<\/td>\r\n

\r\n

Female<\/p>\r\n<\/td>\r\n

\r\n

Male<\/p>\r\n<\/td>\r\n

\r\n

Other<\/p>\r\n<\/td>\r\n

\r\n

Total<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

1. Large Corporation<\/p>\r\n<\/td>\r\n

\r\n

24<\/p>\r\n<\/td>\r\n

\r\n

16<\/p>\r\n<\/td>\r\n

\r\n

2<\/p>\r\n<\/td>\r\n

\r\n

42<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

2. Small Company<\/p>\r\n<\/td>\r\n

\r\n

13<\/p>\r\n<\/td>\r\n

\r\n

15<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n

\r\n

28<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

3. Non-profit or Government Agency<\/p>\r\n<\/td>\r\n

\r\n

8<\/p>\r\n<\/td>\r\n

\r\n

5<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n

\r\n

13<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

4. Other<\/p>\r\n<\/td>\r\n

\r\n

3<\/p>\r\n<\/td>\r\n

\r\n

1<\/p>\r\n<\/td>\r\n

\r\n

1<\/p>\r\n<\/td>\r\n

\r\n

5<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Grand Total<\/p>\r\n<\/td>\r\n

\r\n

48<\/p>\r\n<\/td>\r\n

\r\n

37<\/p>\r\n<\/td>\r\n

\r\n

3<\/p>\r\n<\/td>\r\n

\r\n

88<\/p>\r\n<\/td>\r\n<\/tr>\r\n

<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\nFrequency Distributions\r\n

Categorical data gets a Pareto Chart<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

How do you get to School?<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Public transit<\/p>\r\n<\/td>\r\n

\r\n

63<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Drive<\/p>\r\n<\/td>\r\n

\r\n

43<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Walk<\/p>\r\n<\/td>\r\n

\r\n

8<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Carpool<\/p>\r\n<\/td>\r\n

\r\n

8<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Other<\/p>\r\n<\/td>\r\n

\r\n

1<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Total<\/p>\r\n<\/td>\r\n

\r\n

123<\/p>\r\n<\/td>\r\n<\/tr>\r\n

<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n<\/tr>\r\n

<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

Quantitative data gets a histogram<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

What is your Height in Cm?<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

140-150<\/p>\r\n<\/td>\r\n

\r\n

1<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

150-160<\/p>\r\n<\/td>\r\n

\r\n

14<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

160-170<\/p>\r\n<\/td>\r\n

\r\n

29<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

170-180<\/p>\r\n<\/td>\r\n

\r\n

35<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

180-190<\/p>\r\n<\/td>\r\n

\r\n

26<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

190-200<\/p>\r\n<\/td>\r\n

\r\n

8<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Total<\/p>\r\n<\/td>\r\n

\r\n

113<\/p>\r\n<\/td>\r\n<\/tr>\r\n

<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n<\/tr>\r\n

<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>","rendered":"
\n\n\n\n\n\n\n\n\n\n
\n

Where to work<\/p>\n<\/td>\n

\n

Female<\/p>\n<\/td>\n

\n

Male<\/p>\n<\/td>\n

\n

Other<\/p>\n<\/td>\n

\n

Total<\/p>\n<\/td>\n<\/tr>\n

\n

1. Large Corporation<\/p>\n<\/td>\n

\n

24<\/p>\n<\/td>\n

\n

16<\/p>\n<\/td>\n

\n

2<\/p>\n<\/td>\n

\n

42<\/p>\n<\/td>\n<\/tr>\n

\n

2. Small Company<\/p>\n<\/td>\n

\n

13<\/p>\n<\/td>\n

\n

15<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

28<\/p>\n<\/td>\n<\/tr>\n

\n

3. Non-profit or Government Agency<\/p>\n<\/td>\n

\n

8<\/p>\n<\/td>\n

\n

5<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

13<\/p>\n<\/td>\n<\/tr>\n

\n

4. Other<\/p>\n<\/td>\n

\n

3<\/p>\n<\/td>\n

\n

1<\/p>\n<\/td>\n

\n

1<\/p>\n<\/td>\n

\n

5<\/p>\n<\/td>\n<\/tr>\n

\n

Grand Total<\/p>\n<\/td>\n

\n

48<\/p>\n<\/td>\n

\n

37<\/p>\n<\/td>\n

\n

3<\/p>\n<\/td>\n

\n

88<\/p>\n<\/td>\n<\/tr>\n

<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Frequency Distributions<\/p>\n

Categorical data gets a Pareto Chart<\/h3>\n\n\n\n
\n\n\n\n\n\n\n\n\n\n\n\n
\n

How do you get to School?<\/p>\n<\/td>\n<\/tr>\n

\n

Public transit<\/p>\n<\/td>\n

\n

63<\/p>\n<\/td>\n<\/tr>\n

\n

Drive<\/p>\n<\/td>\n

\n

43<\/p>\n<\/td>\n<\/tr>\n

\n

Walk<\/p>\n<\/td>\n

\n

8<\/p>\n<\/td>\n<\/tr>\n

\n

Carpool<\/p>\n<\/td>\n

\n

8<\/p>\n<\/td>\n<\/tr>\n

\n

Other<\/p>\n<\/td>\n

\n

1<\/p>\n<\/td>\n<\/tr>\n

\n

Total<\/p>\n<\/td>\n

\n

123<\/p>\n<\/td>\n<\/tr>\n

<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n<\/td>\n

\n

\n<\/td>\n<\/tr>\n

<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Quantitative data gets a histogram<\/h3>\n\n\n\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

What is your Height in Cm?<\/p>\n<\/td>\n<\/tr>\n

\n

140-150<\/p>\n<\/td>\n

\n

1<\/p>\n<\/td>\n<\/tr>\n

\n

150-160<\/p>\n<\/td>\n

\n

14<\/p>\n<\/td>\n<\/tr>\n

\n

160-170<\/p>\n<\/td>\n

\n

29<\/p>\n<\/td>\n<\/tr>\n

\n

170-180<\/p>\n<\/td>\n

\n

35<\/p>\n<\/td>\n<\/tr>\n

\n

180-190<\/p>\n<\/td>\n

\n

26<\/p>\n<\/td>\n<\/tr>\n

\n

190-200<\/p>\n<\/td>\n

\n

8<\/p>\n<\/td>\n<\/tr>\n

\n

Total<\/p>\n<\/td>\n

\n

113<\/p>\n<\/td>\n<\/tr>\n

<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n<\/td>\n

\n

\n<\/td>\n<\/tr>\n

\n

\n<\/td>\n

\n

\n<\/td>\n<\/tr>\n

<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"author":883,"menu_order":4,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-125","chapter","type-chapter","status-publish","hentry"],"part":110,"_links":{"self":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapters\/125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/wp\/v2\/users\/883"}],"version-history":[{"count":2,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapters\/125\/revisions"}],"predecessor-version":[{"id":185,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapters\/125\/revisions\/185"}],"part":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/parts\/110"}],"metadata":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapters\/125\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/wp\/v2\/media?parent=125"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapter-type?post=125"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/wp\/v2\/contributor?post=125"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/wp\/v2\/license?post=125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}