{"id":61,"date":"2018-10-31T17:02:28","date_gmt":"2018-10-31T21:02:28","guid":{"rendered":"https:\/\/pressbooks.bccampus.ca\/simplestats\/?post_type=chapter&#038;p=61"},"modified":"2019-09-15T23:30:32","modified_gmt":"2019-09-16T03:30:32","slug":"2-3-frequency-tables","status":"publish","type":"chapter","link":"https:\/\/pressbooks.bccampus.ca\/simplestats\/chapter\/2-3-frequency-tables\/","title":{"raw":"2.3 Frequency Tables","rendered":"2.3 Frequency Tables"},"content":{"raw":"&nbsp;\r\n\r\nAs usual, let's start ground-up with an example and work our way up to the concept under study. Consider the following raw (unorganized) data.\r\n\r\n&nbsp;\r\n<div class=\"textbox textbox--examples\"><header class=\"textbox__header\">\r\n<p class=\"textbox__title\"><em>Example 2.2 (A) Hypothetical Raw Data on<\/em>\u00a0<em>Educational Attainment<\/em><\/p>\r\n\r\n<\/header>\r\n<div class=\"textbox__content\">\r\n\r\n&nbsp;\r\n\r\nImagine that a group of 21 people were asked about the highest educational degree they have attained. These are their responses:\r\n\r\n<\/div>\r\n<table class=\"no-lines aligncenter\" style=\"height: 118px;width: 71.7522%\">\r\n<tbody>\r\n<tr style=\"height: 29px\">\r\n<td style=\"width: 14.5098%;height: 29px\"><strong>Secondary\/High School<\/strong><\/td>\r\n<td style=\"width: 16.6013%;height: 29px\"><strong>\u00a0Bachelor's<\/strong><\/td>\r\n<td style=\"width: 15.5556%;height: 29px\"><strong>Secondary\/High School<\/strong><\/td>\r\n<td style=\"width: 15.5556%;height: 29px\"><strong>No Degree<\/strong><\/td>\r\n<td style=\"width: 10.719%;height: 29px\"><strong>Bachelor's<\/strong><\/td>\r\n<td style=\"width: 21.5921%;height: 29px\"><strong>Didn't answer\u00a0<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 29px\">\r\n<td style=\"width: 14.5098%;height: 29px\"><strong>Master's<\/strong><\/td>\r\n<td style=\"width: 16.6013%;height: 29px\"><strong>Associate's<\/strong><\/td>\r\n<td style=\"width: 15.5556%;height: 29px\"><strong>Master's<\/strong><\/td>\r\n<td style=\"width: 15.5556%;height: 29px\"><strong>Secondary\/High School<\/strong><\/td>\r\n<td style=\"width: 10.719%;height: 29px\"><strong>Bachelor's<\/strong><\/td>\r\n<td style=\"width: 21.5921%;height: 29px\"><\/td>\r\n<\/tr>\r\n<tr style=\"height: 31px\">\r\n<td style=\"width: 14.5098%;height: 31px\"><strong>Secondary\/High School<\/strong><strong>\r\n<\/strong><\/td>\r\n<td style=\"width: 16.6013%;height: 31px\"><strong>Secondary\/High School<\/strong><strong>\r\n<\/strong><\/td>\r\n<td style=\"width: 15.5556%;height: 31px\"><strong>Didn't answer<\/strong><strong>\r\n<\/strong><\/td>\r\n<td style=\"width: 15.5556%;height: 31px\"><strong>Didn't answer<\/strong><strong>\r\n<\/strong><\/td>\r\n<td style=\"width: 10.719%;height: 31px\"><strong>Bachelor's<\/strong><strong>\r\n<\/strong><\/td>\r\n<td style=\"width: 21.5921%;height: 31px\"><strong>\u00a0<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 29px\">\r\n<td style=\"width: 14.5098%;height: 29px\"><strong>Secondary\/High School<\/strong><\/td>\r\n<td style=\"width: 16.6013%;height: 29px\"><strong>PhD<\/strong><\/td>\r\n<td style=\"width: 15.5556%;height: 29px\"><strong>Bachelor's<\/strong><\/td>\r\n<td style=\"width: 15.5556%;height: 29px\"><strong>Associate's<\/strong><\/td>\r\n<td style=\"width: 10.719%;height: 29px\"><strong>Associate's<\/strong><\/td>\r\n<td style=\"width: 21.5921%;height: 29px\"><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n&nbsp;\r\n\r\nWhat can we glean from this presentation of the information? Can we easily see which is the most frequently obtained educational degree in the group? How many people do we have of each degree? What fraction\/proportion of the total are each?\r\n\r\n&nbsp;\r\n\r\nOf course, we could always count -- but what if I had asked you to imagine a group of 36 people? Of 72? Or 200? Or 2,000? Or more? Are you still going to painstakingly count the different responses?\r\n\r\n&nbsp;\r\n\r\nYou may be surprised, but the answer is \"yes, if we had to\". In the past, researchers used to do a that, a lot. Nowadays of course we have computers to do it for us. SPSS can easily summarize this data but to understand the process better, we'll start from scratch.\r\n\r\n&nbsp;\r\n\r\nThe most obvious way we can organize the raw data above into something less chaotic is the following:\r\n\r\n&nbsp;\r\n<div class=\"textbox textbox--examples\"><header class=\"textbox__header\">\r\n<p class=\"textbox__title\"><em>Example 2.2 (B) Hypothetical Data on Educational Attainment, Organized<\/em><\/p>\r\n\r\n<\/header>\r\n<div class=\"textbox__content\">\r\n\r\n<em>Table 2.1 Educational Attainment by Frequency\u00a0<\/em>\r\n<table style=\"border-collapse: collapse;width: 56.5894%;height: 121px\" border=\"0\">\r\n<tbody>\r\n<tr style=\"height: 15px\">\r\n<td style=\"width: 28.187%;height: 15px;text-align: center\"><strong>Degree<\/strong><\/td>\r\n<td style=\"width: 19.8946%;height: 15px\">\r\n<p style=\"text-align: center\"><strong>\u00a0Count (a.k.a. <em>frequency<\/em>)<\/strong><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr style=\"height: 15px\">\r\n<td style=\"width: 28.187%;height: 15px\">\u00a0 \u00a0No degree<\/td>\r\n<td style=\"width: 19.8946%;height: 15px;text-align: center\">1<\/td>\r\n<\/tr>\r\n<tr style=\"height: 15px\">\r\n<td style=\"width: 28.187%;height: 15px\">\u00a0 \u00a0Secondary\/High School<\/td>\r\n<td style=\"width: 19.8946%;height: 15px;text-align: center\">6<\/td>\r\n<\/tr>\r\n<tr style=\"height: 15px\">\r\n<td style=\"width: 28.187%;height: 15px\">\u00a0 \u00a0Associate's<\/td>\r\n<td style=\"width: 19.8946%;height: 15px;text-align: center\">3<\/td>\r\n<\/tr>\r\n<tr style=\"height: 15px\">\r\n<td style=\"width: 28.187%;height: 15px\">\u00a0 \u00a0Bachelor's<\/td>\r\n<td style=\"width: 19.8946%;height: 15px;text-align: center\">5<\/td>\r\n<\/tr>\r\n<tr style=\"height: 15px\">\r\n<td style=\"width: 28.187%;height: 15px\">\u00a0 \u00a0Master's<\/td>\r\n<td style=\"width: 19.8946%;height: 15px;text-align: center\">2<\/td>\r\n<\/tr>\r\n<tr style=\"height: 16px\">\r\n<td style=\"width: 28.187%;height: 16px\">\u00a0 \u00a0PhD<\/td>\r\n<td style=\"width: 19.8946%;height: 16px;text-align: center\">1<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 28.187%\">\u00a0 \u00a0Didn't answer<\/td>\r\n<td style=\"width: 19.8946%;text-align: center\">3<\/td>\r\n<\/tr>\r\n<tr style=\"height: 15px\">\r\n<td style=\"width: 28.187%;height: 15px\">\u00a0 <strong>\u00a0TOTAL<\/strong><\/td>\r\n<td style=\"width: 19.8946%;text-align: center;height: 15px\"><strong>21<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n<\/div>\r\n&nbsp;\r\n\r\nIn the most basic sense, this is a <em>frequency table<\/em>. It lists the different categories of a variable along with their observed count, a.k.a. <em>frequency. <\/em>That is<em>,\u00a0<\/em><strong>we essentially count how many times any given category appears, i.e., we count how <em>frequent<\/em>\u00a0a response is among the respondents, and then indicate the number for each category\/response. Frequency is usually denoted by <em>f<\/em> in statistical notation.<\/strong>\r\n\r\n&nbsp;\r\n\r\nReal frequency tables, however, usually contain more information than a simple count. The following few sub-sections provide the details, while we work our way through creating a full frequency table.\r\n\r\n&nbsp;","rendered":"<p>&nbsp;<\/p>\n<p>As usual, let&#8217;s start ground-up with an example and work our way up to the concept under study. Consider the following raw (unorganized) data.<\/p>\n<p>&nbsp;<\/p>\n<div class=\"textbox textbox--examples\">\n<header class=\"textbox__header\">\n<p class=\"textbox__title\"><em>Example 2.2 (A) Hypothetical Raw Data on<\/em>\u00a0<em>Educational Attainment<\/em><\/p>\n<\/header>\n<div class=\"textbox__content\">\n<p>&nbsp;<\/p>\n<p>Imagine that a group of 21 people were asked about the highest educational degree they have attained. These are their responses:<\/p>\n<\/div>\n<table class=\"no-lines aligncenter\" style=\"height: 118px;width: 71.7522%\">\n<tbody>\n<tr style=\"height: 29px\">\n<td style=\"width: 14.5098%;height: 29px\"><strong>Secondary\/High School<\/strong><\/td>\n<td style=\"width: 16.6013%;height: 29px\"><strong>\u00a0Bachelor&#8217;s<\/strong><\/td>\n<td style=\"width: 15.5556%;height: 29px\"><strong>Secondary\/High School<\/strong><\/td>\n<td style=\"width: 15.5556%;height: 29px\"><strong>No Degree<\/strong><\/td>\n<td style=\"width: 10.719%;height: 29px\"><strong>Bachelor&#8217;s<\/strong><\/td>\n<td style=\"width: 21.5921%;height: 29px\"><strong>Didn&#8217;t answer\u00a0<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 29px\">\n<td style=\"width: 14.5098%;height: 29px\"><strong>Master&#8217;s<\/strong><\/td>\n<td style=\"width: 16.6013%;height: 29px\"><strong>Associate&#8217;s<\/strong><\/td>\n<td style=\"width: 15.5556%;height: 29px\"><strong>Master&#8217;s<\/strong><\/td>\n<td style=\"width: 15.5556%;height: 29px\"><strong>Secondary\/High School<\/strong><\/td>\n<td style=\"width: 10.719%;height: 29px\"><strong>Bachelor&#8217;s<\/strong><\/td>\n<td style=\"width: 21.5921%;height: 29px\"><\/td>\n<\/tr>\n<tr style=\"height: 31px\">\n<td style=\"width: 14.5098%;height: 31px\"><strong>Secondary\/High School<\/strong><strong><br \/>\n<\/strong><\/td>\n<td style=\"width: 16.6013%;height: 31px\"><strong>Secondary\/High School<\/strong><strong><br \/>\n<\/strong><\/td>\n<td style=\"width: 15.5556%;height: 31px\"><strong>Didn&#8217;t answer<\/strong><strong><br \/>\n<\/strong><\/td>\n<td style=\"width: 15.5556%;height: 31px\"><strong>Didn&#8217;t answer<\/strong><strong><br \/>\n<\/strong><\/td>\n<td style=\"width: 10.719%;height: 31px\"><strong>Bachelor&#8217;s<\/strong><strong><br \/>\n<\/strong><\/td>\n<td style=\"width: 21.5921%;height: 31px\"><strong>\u00a0<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 29px\">\n<td style=\"width: 14.5098%;height: 29px\"><strong>Secondary\/High School<\/strong><\/td>\n<td style=\"width: 16.6013%;height: 29px\"><strong>PhD<\/strong><\/td>\n<td style=\"width: 15.5556%;height: 29px\"><strong>Bachelor&#8217;s<\/strong><\/td>\n<td style=\"width: 15.5556%;height: 29px\"><strong>Associate&#8217;s<\/strong><\/td>\n<td style=\"width: 10.719%;height: 29px\"><strong>Associate&#8217;s<\/strong><\/td>\n<td style=\"width: 21.5921%;height: 29px\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>&nbsp;<\/p>\n<p>What can we glean from this presentation of the information? Can we easily see which is the most frequently obtained educational degree in the group? How many people do we have of each degree? What fraction\/proportion of the total are each?<\/p>\n<p>&nbsp;<\/p>\n<p>Of course, we could always count &#8212; but what if I had asked you to imagine a group of 36 people? Of 72? Or 200? Or 2,000? Or more? Are you still going to painstakingly count the different responses?<\/p>\n<p>&nbsp;<\/p>\n<p>You may be surprised, but the answer is &#8220;yes, if we had to&#8221;. In the past, researchers used to do a that, a lot. Nowadays of course we have computers to do it for us. SPSS can easily summarize this data but to understand the process better, we&#8217;ll start from scratch.<\/p>\n<p>&nbsp;<\/p>\n<p>The most obvious way we can organize the raw data above into something less chaotic is the following:<\/p>\n<p>&nbsp;<\/p>\n<div class=\"textbox textbox--examples\">\n<header class=\"textbox__header\">\n<p class=\"textbox__title\"><em>Example 2.2 (B) Hypothetical Data on Educational Attainment, Organized<\/em><\/p>\n<\/header>\n<div class=\"textbox__content\">\n<p><em>Table 2.1 Educational Attainment by Frequency\u00a0<\/em><\/p>\n<table style=\"border-collapse: collapse;width: 56.5894%;height: 121px\">\n<tbody>\n<tr style=\"height: 15px\">\n<td style=\"width: 28.187%;height: 15px;text-align: center\"><strong>Degree<\/strong><\/td>\n<td style=\"width: 19.8946%;height: 15px\">\n<p style=\"text-align: center\"><strong>\u00a0Count (a.k.a. <em>frequency<\/em>)<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15px\">\n<td style=\"width: 28.187%;height: 15px\">\u00a0 \u00a0No degree<\/td>\n<td style=\"width: 19.8946%;height: 15px;text-align: center\">1<\/td>\n<\/tr>\n<tr style=\"height: 15px\">\n<td style=\"width: 28.187%;height: 15px\">\u00a0 \u00a0Secondary\/High School<\/td>\n<td style=\"width: 19.8946%;height: 15px;text-align: center\">6<\/td>\n<\/tr>\n<tr style=\"height: 15px\">\n<td style=\"width: 28.187%;height: 15px\">\u00a0 \u00a0Associate&#8217;s<\/td>\n<td style=\"width: 19.8946%;height: 15px;text-align: center\">3<\/td>\n<\/tr>\n<tr style=\"height: 15px\">\n<td style=\"width: 28.187%;height: 15px\">\u00a0 \u00a0Bachelor&#8217;s<\/td>\n<td style=\"width: 19.8946%;height: 15px;text-align: center\">5<\/td>\n<\/tr>\n<tr style=\"height: 15px\">\n<td style=\"width: 28.187%;height: 15px\">\u00a0 \u00a0Master&#8217;s<\/td>\n<td style=\"width: 19.8946%;height: 15px;text-align: center\">2<\/td>\n<\/tr>\n<tr style=\"height: 16px\">\n<td style=\"width: 28.187%;height: 16px\">\u00a0 \u00a0PhD<\/td>\n<td style=\"width: 19.8946%;height: 16px;text-align: center\">1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 28.187%\">\u00a0 \u00a0Didn&#8217;t answer<\/td>\n<td style=\"width: 19.8946%;text-align: center\">3<\/td>\n<\/tr>\n<tr style=\"height: 15px\">\n<td style=\"width: 28.187%;height: 15px\">\u00a0 <strong>\u00a0TOTAL<\/strong><\/td>\n<td style=\"width: 19.8946%;text-align: center;height: 15px\"><strong>21<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p>In the most basic sense, this is a <em>frequency table<\/em>. It lists the different categories of a variable along with their observed count, a.k.a. <em>frequency. <\/em>That is<em>,\u00a0<\/em><strong>we essentially count how many times any given category appears, i.e., we count how <em>frequent<\/em>\u00a0a response is among the respondents, and then indicate the number for each category\/response. Frequency is usually denoted by <em>f<\/em> in statistical notation.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Real frequency tables, however, usually contain more information than a simple count. The following few sub-sections provide the details, while we work our way through creating a full frequency table.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"author":533,"menu_order":3,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-61","chapter","type-chapter","status-publish","hentry"],"part":323,"_links":{"self":[{"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/pressbooks\/v2\/chapters\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/wp\/v2\/users\/533"}],"version-history":[{"count":25,"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/pressbooks\/v2\/chapters\/61\/revisions"}],"predecessor-version":[{"id":2015,"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/pressbooks\/v2\/chapters\/61\/revisions\/2015"}],"part":[{"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/pressbooks\/v2\/parts\/323"}],"metadata":[{"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/pressbooks\/v2\/chapters\/61\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/wp\/v2\/media?parent=61"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/pressbooks\/v2\/chapter-type?post=61"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/wp\/v2\/contributor?post=61"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/simplestats\/wp-json\/wp\/v2\/license?post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}