{"id":37,"date":"2022-10-07T11:52:57","date_gmt":"2022-10-07T15:52:57","guid":{"rendered":"https:\/\/opentextbc.ca\/busstatsancillary\/chapter\/sampling-and-data-excel-tools-instruction\/"},"modified":"2023-01-20T14:17:56","modified_gmt":"2023-01-20T19:17:56","slug":"sampling-and-data-excel-tools-instruction","status":"publish","type":"chapter","link":"https:\/\/opentextbc.ca\/busstatsancillary\/chapter\/sampling-and-data-excel-tools-instruction\/","title":{"raw":"Sampling and Data - Excel Tools Instruction","rendered":"Sampling and Data &#8211; Excel Tools Instruction"},"content":{"raw":"<div class=\"textbox\">Download <a href=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2022\/10\/Sampling-and-Data-\u2013-Excel-Instruction-Data-Sets.xlsx\">Sampling and Data \u2013 Excel Instruction Data Sets [Excel]<\/a>.<\/div>\r\n<h1>Pie Charts and Bar Graphs<\/h1>\r\n<ul>\r\n \t<li>In a <strong>pie chart<\/strong>, categories of data are represented by wedges in a circle and are proportional in size to the percent of individuals in each category.<\/li>\r\n \t<li>In a <strong>bar graph<\/strong>, the length of the bar for each category is proportional to the number or percent of individuals in each category. Bars may be vertical or horizontal.<\/li>\r\n<\/ul>\r\n<h2>Pie Charts in Excel<\/h2>\r\n<ol>\r\n \t<li>Highlight <span style=\"color: #eb0000;\">columns of<\/span> cells (hold '<span style=\"color: #eb0000;\">Ctrl<\/span>' button if columns not adjacent)<\/li>\r\n \t<li>Click<span style=\"color: #eb0000;\"> Insert, Charts<\/span> and the <span style=\"color: #eb0000;\">first 2-D pie<\/span><\/li>\r\n \t<li>Click on the <span style=\"color: #eb0000;\">new pie chart<\/span> and icon <span style=\"color: #2d8659;\">+<\/span> to make changes<\/li>\r\n \t<li>Right click on wedge, choose '<span style=\"color: #eb0000;\">Add Data Labels<\/span>'<\/li>\r\n<\/ol>\r\n<table class=\"grid\" style=\"border-collapse: collapse; width: 100%;\" border=\"0\"><caption>Table 1.4 Ethnicity of Students at De Anza College Fall Term 2007 (Census Day)<\/caption>\r\n<tbody>\r\n<tr>\r\n<th style=\"width: 149.671875px;\" scope=\"col\">Ethnicity<\/th>\r\n<th style=\"width: 149.671875px;\" scope=\"col\">Frequency<\/th>\r\n<th style=\"width: 149.671875px;\" scope=\"col\">Percent<\/th>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 149.671875px;\">Asian<\/td>\r\n<td style=\"width: 149.671875px;\">8,794<\/td>\r\n<td style=\"width: 149.671875px;\">36.1%<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 149.671875px;\">Black<\/td>\r\n<td style=\"width: 149.671875px;\">1,412<\/td>\r\n<td style=\"width: 149.671875px;\">5.8%<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 149.671875px;\">Filipino<\/td>\r\n<td style=\"width: 149.671875px;\">1,298<\/td>\r\n<td style=\"width: 149.671875px;\">5.3%<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 149.671875px;\">Hispanic<\/td>\r\n<td style=\"width: 149.671875px;\">4,180<\/td>\r\n<td style=\"width: 149.671875px;\">17.1%<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 149.671875px;\">Native American<\/td>\r\n<td style=\"width: 149.671875px;\">146<\/td>\r\n<td style=\"width: 149.671875px;\">0.6%<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 149.671875px;\">Pacific Islander<\/td>\r\n<td style=\"width: 149.671875px;\">236<\/td>\r\n<td style=\"width: 149.671875px;\">1.0%<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 149.671875px;\">White<\/td>\r\n<td style=\"width: 149.671875px;\">5,978<\/td>\r\n<td style=\"width: 149.671875px;\">24.5%<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 149.671875px;\">Other<\/td>\r\n<td style=\"width: 149.671875px;\">2,338<\/td>\r\n<td style=\"width: 149.671875px;\">9.6%<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n[caption id=\"attachment_36\" align=\"aligncenter\" width=\"600\"]<img class=\"wp-image-23\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/Screen-Shot-2022-10-07-at-8.40.18-AM-e1665768896559.png\" alt=\"\" width=\"600\" height=\"387\" \/> Step 1 &amp; 2: Highlight column of cells and create 2-D Pie[\/caption]\r\n\r\n[caption id=\"attachment_36\" align=\"aligncenter\" width=\"600\"]<img class=\"wp-image-24\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-8.40.44-AM-e1665769031571.png\" alt=\"\" width=\"600\" height=\"348\" \/> Step 3 &amp; 4: Click icon + and add Data Labels[\/caption]\r\n<h2>Bar graphs in Excel<\/h2>\r\n<ol>\r\n \t<li>Highlight <span style=\"color: #eb0000;\">columns<\/span> of cells<\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Insert, Charts<\/span> and the <span style=\"color: #eb0000;\">first 2-D Column<\/span><\/li>\r\n \t<li>Click on the <span style=\"color: #eb0000;\">new bar graph<\/span> and icon <strong><span style=\"color: #2d8659;\">+<\/span><\/strong> to make changes<\/li>\r\n \t<li>Right click on wedge, choose \u2018<span style=\"color: #eb0000;\">Add Data Labels<\/span>\u2019<\/li>\r\n<\/ol>\r\n[caption id=\"attachment_36\" align=\"aligncenter\" width=\"887\"]<img class=\"wp-image-25 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bar1.png\" alt=\"\" width=\"887\" height=\"572\" \/> Step 1 &amp; 2: Highlight column of cells and insert 2-D Chart[\/caption]\r\n\r\n[caption id=\"attachment_36\" align=\"aligncenter\" width=\"560\"]<img class=\"wp-image-26 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Bar2.jpg\" alt=\"\" width=\"560\" height=\"438\" \/> Step 3 &amp; 4: Click on New Bar Graph + icon to make changes and Add Data Labels[\/caption]\r\n<h1>Frequency, Relative Frequency and Cumulative Relative Frequency<\/h1>\r\n<ul>\r\n \t<li>A <strong>frequency<\/strong> is the number of times a value of the data occurs.<\/li>\r\n \t<li>A <strong>relative frequency<\/strong> is the ratio (fraction or proportion) of the number of times a value of the data occurs in the set of all outcomes to the total number of outcomes. Relative frequencies can be written as fractions, percents, or decimals.<\/li>\r\n \t<li>A <strong>cumulative relative frequency<\/strong> is the accumulation of the previous relative frequencies.<\/li>\r\n<\/ul>\r\n<h2>Frequency in Excel<\/h2>\r\nTwenty students were asked how many hours they worked per day. Their responses, in hours, are as follows: 5; 6; 3; 3; 2; 4; 7; 5; 2; 3; 5; 6; 5; 4; 4; 3; 5; 2; 5; 3.\r\n\r\nEnter <span style=\"color: #eb0000;\">all data in column A.<\/span> Create a column for data categories (<span style=\"color: #eb0000;\">column B<\/span>).\r\n<ol>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=COUNTIF<\/span> in cell C2, click column A, comma and <span style=\"color: #eb0000;\">B2<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">C2<\/span>, move the mouse to <span style=\"color: #eb0000;\">the right bottom corner<\/span>, a little <span style=\"color: #eb0000;\">+<\/span> appears<\/li>\r\n \t<li>Click on the little <span style=\"color: #eb0000;\">+<\/span> and <span style=\"color: #eb0000;\">drag down<\/span> to repeat cell<\/li>\r\n<\/ol>\r\n[caption id=\"attachment_27\" align=\"aligncenter\" width=\"420\"]<img class=\"wp-image-27 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-1.jpg\" alt=\"\" width=\"420\" height=\"333\" \/> Step 1 &amp; 2: Enter =COUNTIF, select column A, column B, then click Enter[\/caption]\r\n\r\n[caption id=\"attachment_36\" align=\"aligncenter\" width=\"504\"]<img class=\"wp-image-28 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-2.jpg\" alt=\"\" width=\"504\" height=\"302\" \/> Step 3 &amp; 4: Click C2 and use + in bottom right corner to drag down and repeat cell[\/caption]\r\n<h2>Relative Frequency in Excel<\/h2>\r\nTwenty students were asked how many hours they worked per day. Their responses, in hours, are as follows: 5; 6; 3; 3; 2; 4; 7; 5; 2; 3; 5; 6; 5; 4; 4; 3; 5; 2; 5; 3.\r\n<ol>\r\n \t<li>In cell D2, enter <span style=\"color: #eb0000;\">=,<\/span> click cell <span style=\"color: #eb0000;\">C2<\/span>, enter <span style=\"color: #eb0000;\">\/<\/span>, and click <span style=\"color: #eb0000;\">C8 F4<\/span> (<span style=\"color: #eb0000;\">F4<\/span> holds a cell constant)<\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Enter<\/span>, 0.15 shows in D2<\/li>\r\n \t<li>Click D2, move the mouse to the <span style=\"color: #eb0000;\">right bottom corner<\/span>, a little <span style=\"color: #eb0000;\">+<\/span> shows up<\/li>\r\n \t<li>Click on the little <span style=\"color: #eb0000;\">+<\/span> and <span style=\"color: #eb0000;\">drag down<\/span> to repeat cell<\/li>\r\n<\/ol>\r\n[caption id=\"attachment_36\" align=\"aligncenter\" width=\"501\"]<img class=\"wp-image-29 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture1.jpg\" alt=\"\" width=\"501\" height=\"364\" \/> Step 1: In cell D2, enter =, click cell C2, enter \/, and click C8 F4[\/caption]\r\n\r\n[caption id=\"attachment_36\" align=\"aligncenter\" width=\"504\"]<img class=\"wp-image-30 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture2.jpg\" alt=\"\" width=\"504\" height=\"280\" \/> Step 2, 3 &amp; 4: Click Enter. Then click D2, click and drag + in bottom right corner to repeat cells[\/caption]\r\n<h2>Cumulative Relative Frequency in Excel<\/h2>\r\nTwenty students were asked how many hours they worked per day. Their responses, in hours, are as follows: 5; 6; 3; 3; 2; 4; 7; 5; 2; 3; 5; 6; 5; 4; 4; 3; 5; 2; 5; 3.\r\n<ol>\r\n \t<li>In cell E2, enter <span style=\"color: #eb0000;\">=,<\/span> click <span style=\"color: #eb0000;\">D2<\/span> and <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>In cell E3, enter <span style=\"color: #eb0000;\">=SUM($D$2:D3)<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Enter<\/span>, 0.4 shows in E3<\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">E3<\/span>, move the mouse to <span style=\"color: #eb0000;\">the right bottom corner<\/span>, a little <span style=\"color: #eb0000;\">+<\/span> shows up<\/li>\r\n \t<li>Click on the little <span style=\"color: #eb0000;\">+<\/span> and <span style=\"color: #eb0000;\">drag down<\/span> to repeat cell<\/li>\r\n<\/ol>\r\n[caption id=\"attachment_31\" align=\"aligncenter\" width=\"508\"]<img class=\"wp-image-31 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture3.jpg\" alt=\"\" width=\"508\" height=\"334\" \/> Step 1 &amp; 2: In cell E2, enter =, click D2 and Enter, then in cell E3, enter =SUM($D$2:D3)[\/caption]\r\n\r\n[caption id=\"attachment_32\" align=\"aligncenter\" width=\"524\"]<img class=\"wp-image-32 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture4.jpg\" alt=\"\" width=\"524\" height=\"280\" \/> Step 3, 4 &amp; 5: Click Enter, click E3, then click and drag + in bottom right corner to repeat cells[\/caption]\r\n<h1>Pivot Table<\/h1>\r\n<ul>\r\n \t<li>A Pivot Table helps to arrange and summarize complex data.<\/li>\r\n<\/ul>\r\n<h2>Pivot Table for Frequency in Excel<\/h2>\r\nTwenty students were asked how many hours they worked per day. Their responses, in hours, are as follows: 5; 6; 3; 3; 2; 4; 7; 5; 2; 3; 5; 6; 5; 4; 4; 3; 5; 2; 5; 3.\r\n<ol>\r\n \t<li>Enter <span style=\"color: #eb0000;\">all data in column A<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Insert<\/span>, <span style=\"color: #eb0000;\">Pivot Table<\/span><\/li>\r\n \t<li>Click on the area of <span style=\"color: #eb0000;\">Table\/Range<\/span>, <span style=\"color: #eb0000;\">highlight all data<\/span><\/li>\r\n \t<li>Click on the area of <span style=\"color: #eb0000;\">Location<\/span>, click on cell <span style=\"color: #eb0000;\">C1<\/span> on where the pivot table will display<\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">OK<\/span><\/li>\r\n<\/ol>\r\n[caption id=\"attachment_33\" align=\"aligncenter\" width=\"336\"]<img class=\"wp-image-33 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture5.jpg\" alt=\"\" width=\"336\" height=\"358\" \/> Step 1 &amp; 2: Enter all data in column A then Click Insert, Pivot Table[\/caption]\r\n\r\n[caption id=\"attachment_34\" align=\"aligncenter\" width=\"461\"]<img class=\"wp-image-34 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture6.jpg\" alt=\"\" width=\"461\" height=\"385\" \/> Step 3, 4 &amp; 5: Click on the area of Table\/Range, highlight all data then click Location, click on cell C1 where pivot table will display, click OK[\/caption]\r\n<ol start=\"6\">\r\n \t<li>Click on <span style=\"color: #eb0000;\">Working hours<\/span>, hold and drag down to <span style=\"color: #eb0000;\">Rows<\/span> area<\/li>\r\n \t<li>Click on <span style=\"color: #eb0000;\">Working hours<\/span>, hold and drag down to <span style=\"color: #eb0000;\">Values<\/span> area<\/li>\r\n \t<li>Click on the <span style=\"color: #eb0000;\">drop-down icon<\/span>, <span style=\"color: #eb0000;\">Value Field Setting<\/span><\/li>\r\n \t<li>Choose <span style=\"color: #eb0000;\">Count Numbers<\/span>, click <span style=\"color: #eb0000;\">OK<\/span><\/li>\r\n<\/ol>\r\n[caption id=\"attachment_36\" align=\"aligncenter\" width=\"526\"]<img class=\"wp-image-35 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture7.jpg\" alt=\"\" width=\"526\" height=\"440\" \/> Step 6, 7 &amp; 8: Click on Working hours, hold and drag down to Rows area, repeat the same for Values area then click on the drop-down icon, Value Field Setting[\/caption]\r\n\r\n[caption id=\"attachment_36\" align=\"aligncenter\" width=\"372\"]<img class=\"wp-image-36 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture8.jpg\" alt=\"\" width=\"372\" height=\"320\" \/> Step 9: Choose Count Numbers, click OK[\/caption]\r\n<h3>Media Attributions<\/h3>\r\n<ul>\r\n \t<li>Screenshots of Excel are used with <a href=\"https:\/\/www.microsoft.com\/en-us\/legal\/intellectualproperty\/copyright\/permissions\" target=\"_blank\" rel=\"noopener\">permission from Microsoft<\/a>.<\/li>\r\n<\/ul>","rendered":"<div class=\"textbox\">Download <a href=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2022\/10\/Sampling-and-Data-\u2013-Excel-Instruction-Data-Sets.xlsx\">Sampling and Data \u2013 Excel Instruction Data Sets [Excel]<\/a>.<\/div>\n<h1>Pie Charts and Bar Graphs<\/h1>\n<ul>\n<li>In a <strong>pie chart<\/strong>, categories of data are represented by wedges in a circle and are proportional in size to the percent of individuals in each category.<\/li>\n<li>In a <strong>bar graph<\/strong>, the length of the bar for each category is proportional to the number or percent of individuals in each category. Bars may be vertical or horizontal.<\/li>\n<\/ul>\n<h2>Pie Charts in Excel<\/h2>\n<ol>\n<li>Highlight <span style=\"color: #eb0000;\">columns of<\/span> cells (hold &#8216;<span style=\"color: #eb0000;\">Ctrl<\/span>&#8216; button if columns not adjacent)<\/li>\n<li>Click<span style=\"color: #eb0000;\"> Insert, Charts<\/span> and the <span style=\"color: #eb0000;\">first 2-D pie<\/span><\/li>\n<li>Click on the <span style=\"color: #eb0000;\">new pie chart<\/span> and icon <span style=\"color: #2d8659;\">+<\/span> to make changes<\/li>\n<li>Right click on wedge, choose &#8216;<span style=\"color: #eb0000;\">Add Data Labels<\/span>&#8216;<\/li>\n<\/ol>\n<table class=\"grid\" style=\"border-collapse: collapse; width: 100%;\">\n<caption>Table 1.4 Ethnicity of Students at De Anza College Fall Term 2007 (Census Day)<\/caption>\n<tbody>\n<tr>\n<th style=\"width: 149.671875px;\" scope=\"col\">Ethnicity<\/th>\n<th style=\"width: 149.671875px;\" scope=\"col\">Frequency<\/th>\n<th style=\"width: 149.671875px;\" scope=\"col\">Percent<\/th>\n<\/tr>\n<tr>\n<td style=\"width: 149.671875px;\">Asian<\/td>\n<td style=\"width: 149.671875px;\">8,794<\/td>\n<td style=\"width: 149.671875px;\">36.1%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149.671875px;\">Black<\/td>\n<td style=\"width: 149.671875px;\">1,412<\/td>\n<td style=\"width: 149.671875px;\">5.8%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149.671875px;\">Filipino<\/td>\n<td style=\"width: 149.671875px;\">1,298<\/td>\n<td style=\"width: 149.671875px;\">5.3%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149.671875px;\">Hispanic<\/td>\n<td style=\"width: 149.671875px;\">4,180<\/td>\n<td style=\"width: 149.671875px;\">17.1%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149.671875px;\">Native American<\/td>\n<td style=\"width: 149.671875px;\">146<\/td>\n<td style=\"width: 149.671875px;\">0.6%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149.671875px;\">Pacific Islander<\/td>\n<td style=\"width: 149.671875px;\">236<\/td>\n<td style=\"width: 149.671875px;\">1.0%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149.671875px;\">White<\/td>\n<td style=\"width: 149.671875px;\">5,978<\/td>\n<td style=\"width: 149.671875px;\">24.5%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149.671875px;\">Other<\/td>\n<td style=\"width: 149.671875px;\">2,338<\/td>\n<td style=\"width: 149.671875px;\">9.6%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<figure id=\"attachment_36\" aria-describedby=\"caption-attachment-36\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/Screen-Shot-2022-10-07-at-8.40.18-AM-e1665768896559.png\" alt=\"\" width=\"600\" height=\"387\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/Screen-Shot-2022-10-07-at-8.40.18-AM-e1665768896559.png 981w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/Screen-Shot-2022-10-07-at-8.40.18-AM-e1665768896559-300x194.png 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/Screen-Shot-2022-10-07-at-8.40.18-AM-e1665768896559-768x496.png 768w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/Screen-Shot-2022-10-07-at-8.40.18-AM-e1665768896559-65x42.png 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/Screen-Shot-2022-10-07-at-8.40.18-AM-e1665768896559-225x145.png 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/Screen-Shot-2022-10-07-at-8.40.18-AM-e1665768896559-350x226.png 350w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-36\" class=\"wp-caption-text\">Step 1 &amp; 2: Highlight column of cells and create 2-D Pie<\/figcaption><\/figure>\n<figure id=\"attachment_36\" aria-describedby=\"caption-attachment-36\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-24\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-8.40.44-AM-e1665769031571.png\" alt=\"\" width=\"600\" height=\"348\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-8.40.44-AM-e1665769031571.png 1067w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-8.40.44-AM-e1665769031571-300x174.png 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-8.40.44-AM-e1665769031571-1024x594.png 1024w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-8.40.44-AM-e1665769031571-768x446.png 768w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-8.40.44-AM-e1665769031571-65x38.png 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-8.40.44-AM-e1665769031571-225x131.png 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-8.40.44-AM-e1665769031571-350x203.png 350w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-36\" class=\"wp-caption-text\">Step 3 &amp; 4: Click icon + and add Data Labels<\/figcaption><\/figure>\n<h2>Bar graphs in Excel<\/h2>\n<ol>\n<li>Highlight <span style=\"color: #eb0000;\">columns<\/span> of cells<\/li>\n<li>Click <span style=\"color: #eb0000;\">Insert, Charts<\/span> and the <span style=\"color: #eb0000;\">first 2-D Column<\/span><\/li>\n<li>Click on the <span style=\"color: #eb0000;\">new bar graph<\/span> and icon <strong><span style=\"color: #2d8659;\">+<\/span><\/strong> to make changes<\/li>\n<li>Right click on wedge, choose \u2018<span style=\"color: #eb0000;\">Add Data Labels<\/span>\u2019<\/li>\n<\/ol>\n<figure id=\"attachment_36\" aria-describedby=\"caption-attachment-36\" style=\"width: 887px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bar1.png\" alt=\"\" width=\"887\" height=\"572\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bar1.png 887w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bar1-300x193.png 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bar1-768x495.png 768w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bar1-65x42.png 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bar1-225x145.png 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bar1-350x226.png 350w\" sizes=\"auto, (max-width: 887px) 100vw, 887px\" \/><figcaption id=\"caption-attachment-36\" class=\"wp-caption-text\">Step 1 &amp; 2: Highlight column of cells and insert 2-D Chart<\/figcaption><\/figure>\n<figure id=\"attachment_36\" aria-describedby=\"caption-attachment-36\" style=\"width: 560px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-26 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Bar2.jpg\" alt=\"\" width=\"560\" height=\"438\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Bar2.jpg 560w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Bar2-300x235.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Bar2-65x51.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Bar2-225x176.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Bar2-350x274.jpg 350w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><figcaption id=\"caption-attachment-36\" class=\"wp-caption-text\">Step 3 &amp; 4: Click on New Bar Graph + icon to make changes and Add Data Labels<\/figcaption><\/figure>\n<h1>Frequency, Relative Frequency and Cumulative Relative Frequency<\/h1>\n<ul>\n<li>A <strong>frequency<\/strong> is the number of times a value of the data occurs.<\/li>\n<li>A <strong>relative frequency<\/strong> is the ratio (fraction or proportion) of the number of times a value of the data occurs in the set of all outcomes to the total number of outcomes. Relative frequencies can be written as fractions, percents, or decimals.<\/li>\n<li>A <strong>cumulative relative frequency<\/strong> is the accumulation of the previous relative frequencies.<\/li>\n<\/ul>\n<h2>Frequency in Excel<\/h2>\n<p>Twenty students were asked how many hours they worked per day. Their responses, in hours, are as follows: 5; 6; 3; 3; 2; 4; 7; 5; 2; 3; 5; 6; 5; 4; 4; 3; 5; 2; 5; 3.<\/p>\n<p>Enter <span style=\"color: #eb0000;\">all data in column A.<\/span> Create a column for data categories (<span style=\"color: #eb0000;\">column B<\/span>).<\/p>\n<ol>\n<li>Enter <span style=\"color: #eb0000;\">=COUNTIF<\/span> in cell C2, click column A, comma and <span style=\"color: #eb0000;\">B2<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">C2<\/span>, move the mouse to <span style=\"color: #eb0000;\">the right bottom corner<\/span>, a little <span style=\"color: #eb0000;\">+<\/span> appears<\/li>\n<li>Click on the little <span style=\"color: #eb0000;\">+<\/span> and <span style=\"color: #eb0000;\">drag down<\/span> to repeat cell<\/li>\n<\/ol>\n<figure id=\"attachment_27\" aria-describedby=\"caption-attachment-27\" style=\"width: 420px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-1.jpg\" alt=\"\" width=\"420\" height=\"333\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-1.jpg 420w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-1-300x238.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-1-65x52.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-1-225x178.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-1-350x278.jpg 350w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><figcaption id=\"caption-attachment-27\" class=\"wp-caption-text\">Step 1 &amp; 2: Enter =COUNTIF, select column A, column B, then click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_36\" aria-describedby=\"caption-attachment-36\" style=\"width: 504px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-28 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-2.jpg\" alt=\"\" width=\"504\" height=\"302\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-2.jpg 504w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-2-300x180.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-2-65x39.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-2-225x135.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture-2-350x210.jpg 350w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><figcaption id=\"caption-attachment-36\" class=\"wp-caption-text\">Step 3 &amp; 4: Click C2 and use + in bottom right corner to drag down and repeat cell<\/figcaption><\/figure>\n<h2>Relative Frequency in Excel<\/h2>\n<p>Twenty students were asked how many hours they worked per day. Their responses, in hours, are as follows: 5; 6; 3; 3; 2; 4; 7; 5; 2; 3; 5; 6; 5; 4; 4; 3; 5; 2; 5; 3.<\/p>\n<ol>\n<li>In cell D2, enter <span style=\"color: #eb0000;\">=,<\/span> click cell <span style=\"color: #eb0000;\">C2<\/span>, enter <span style=\"color: #eb0000;\">\/<\/span>, and click <span style=\"color: #eb0000;\">C8 F4<\/span> (<span style=\"color: #eb0000;\">F4<\/span> holds a cell constant)<\/li>\n<li>Click <span style=\"color: #eb0000;\">Enter<\/span>, 0.15 shows in D2<\/li>\n<li>Click D2, move the mouse to the <span style=\"color: #eb0000;\">right bottom corner<\/span>, a little <span style=\"color: #eb0000;\">+<\/span> shows up<\/li>\n<li>Click on the little <span style=\"color: #eb0000;\">+<\/span> and <span style=\"color: #eb0000;\">drag down<\/span> to repeat cell<\/li>\n<\/ol>\n<figure id=\"attachment_36\" aria-describedby=\"caption-attachment-36\" style=\"width: 501px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture1.jpg\" alt=\"\" width=\"501\" height=\"364\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture1.jpg 501w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture1-300x218.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture1-65x47.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture1-225x163.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture1-350x254.jpg 350w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/><figcaption id=\"caption-attachment-36\" class=\"wp-caption-text\">Step 1: In cell D2, enter =, click cell C2, enter \/, and click C8 F4<\/figcaption><\/figure>\n<figure id=\"attachment_36\" aria-describedby=\"caption-attachment-36\" style=\"width: 504px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture2.jpg\" alt=\"\" width=\"504\" height=\"280\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture2.jpg 504w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture2-300x167.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture2-65x36.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture2-225x125.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture2-350x194.jpg 350w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><figcaption id=\"caption-attachment-36\" class=\"wp-caption-text\">Step 2, 3 &amp; 4: Click Enter. Then click D2, click and drag + in bottom right corner to repeat cells<\/figcaption><\/figure>\n<h2>Cumulative Relative Frequency in Excel<\/h2>\n<p>Twenty students were asked how many hours they worked per day. Their responses, in hours, are as follows: 5; 6; 3; 3; 2; 4; 7; 5; 2; 3; 5; 6; 5; 4; 4; 3; 5; 2; 5; 3.<\/p>\n<ol>\n<li>In cell E2, enter <span style=\"color: #eb0000;\">=,<\/span> click <span style=\"color: #eb0000;\">D2<\/span> and <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>In cell E3, enter <span style=\"color: #eb0000;\">=SUM($D$2:D3)<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">Enter<\/span>, 0.4 shows in E3<\/li>\n<li>Click <span style=\"color: #eb0000;\">E3<\/span>, move the mouse to <span style=\"color: #eb0000;\">the right bottom corner<\/span>, a little <span style=\"color: #eb0000;\">+<\/span> shows up<\/li>\n<li>Click on the little <span style=\"color: #eb0000;\">+<\/span> and <span style=\"color: #eb0000;\">drag down<\/span> to repeat cell<\/li>\n<\/ol>\n<figure id=\"attachment_31\" aria-describedby=\"caption-attachment-31\" style=\"width: 508px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture3.jpg\" alt=\"\" width=\"508\" height=\"334\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture3.jpg 508w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture3-300x197.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture3-65x43.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture3-225x148.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture3-350x230.jpg 350w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><figcaption id=\"caption-attachment-31\" class=\"wp-caption-text\">Step 1 &amp; 2: In cell E2, enter =, click D2 and Enter, then in cell E3, enter =SUM($D$2:D3)<\/figcaption><\/figure>\n<figure id=\"attachment_32\" aria-describedby=\"caption-attachment-32\" style=\"width: 524px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture4.jpg\" alt=\"\" width=\"524\" height=\"280\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture4.jpg 524w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture4-300x160.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture4-65x35.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture4-225x120.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture4-350x187.jpg 350w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><figcaption id=\"caption-attachment-32\" class=\"wp-caption-text\">Step 3, 4 &amp; 5: Click Enter, click E3, then click and drag + in bottom right corner to repeat cells<\/figcaption><\/figure>\n<h1>Pivot Table<\/h1>\n<ul>\n<li>A Pivot Table helps to arrange and summarize complex data.<\/li>\n<\/ul>\n<h2>Pivot Table for Frequency in Excel<\/h2>\n<p>Twenty students were asked how many hours they worked per day. Their responses, in hours, are as follows: 5; 6; 3; 3; 2; 4; 7; 5; 2; 3; 5; 6; 5; 4; 4; 3; 5; 2; 5; 3.<\/p>\n<ol>\n<li>Enter <span style=\"color: #eb0000;\">all data in column A<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">Insert<\/span>, <span style=\"color: #eb0000;\">Pivot Table<\/span><\/li>\n<li>Click on the area of <span style=\"color: #eb0000;\">Table\/Range<\/span>, <span style=\"color: #eb0000;\">highlight all data<\/span><\/li>\n<li>Click on the area of <span style=\"color: #eb0000;\">Location<\/span>, click on cell <span style=\"color: #eb0000;\">C1<\/span> on where the pivot table will display<\/li>\n<li>Click <span style=\"color: #eb0000;\">OK<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_33\" aria-describedby=\"caption-attachment-33\" style=\"width: 336px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture5.jpg\" alt=\"\" width=\"336\" height=\"358\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture5.jpg 336w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture5-282x300.jpg 282w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture5-65x69.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture5-225x240.jpg 225w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><figcaption id=\"caption-attachment-33\" class=\"wp-caption-text\">Step 1 &amp; 2: Enter all data in column A then Click Insert, Pivot Table<\/figcaption><\/figure>\n<figure id=\"attachment_34\" aria-describedby=\"caption-attachment-34\" style=\"width: 461px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture6.jpg\" alt=\"\" width=\"461\" height=\"385\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture6.jpg 461w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture6-300x251.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture6-65x54.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture6-225x188.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture6-350x292.jpg 350w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><figcaption id=\"caption-attachment-34\" class=\"wp-caption-text\">Step 3, 4 &amp; 5: Click on the area of Table\/Range, highlight all data then click Location, click on cell C1 where pivot table will display, click OK<\/figcaption><\/figure>\n<ol start=\"6\">\n<li>Click on <span style=\"color: #eb0000;\">Working hours<\/span>, hold and drag down to <span style=\"color: #eb0000;\">Rows<\/span> area<\/li>\n<li>Click on <span style=\"color: #eb0000;\">Working hours<\/span>, hold and drag down to <span style=\"color: #eb0000;\">Values<\/span> area<\/li>\n<li>Click on the <span style=\"color: #eb0000;\">drop-down icon<\/span>, <span style=\"color: #eb0000;\">Value Field Setting<\/span><\/li>\n<li>Choose <span style=\"color: #eb0000;\">Count Numbers<\/span>, click <span style=\"color: #eb0000;\">OK<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_36\" aria-describedby=\"caption-attachment-36\" style=\"width: 526px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-35 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture7.jpg\" alt=\"\" width=\"526\" height=\"440\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture7.jpg 526w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture7-300x251.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture7-65x54.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture7-225x188.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture7-350x293.jpg 350w\" sizes=\"auto, (max-width: 526px) 100vw, 526px\" \/><figcaption id=\"caption-attachment-36\" class=\"wp-caption-text\">Step 6, 7 &amp; 8: Click on Working hours, hold and drag down to Rows area, repeat the same for Values area then click on the drop-down icon, Value Field Setting<\/figcaption><\/figure>\n<figure id=\"attachment_36\" aria-describedby=\"caption-attachment-36\" style=\"width: 372px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture8.jpg\" alt=\"\" width=\"372\" height=\"320\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture8.jpg 372w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture8-300x258.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture8-65x56.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture8-225x194.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Picture8-350x301.jpg 350w\" sizes=\"auto, (max-width: 372px) 100vw, 372px\" \/><figcaption id=\"caption-attachment-36\" class=\"wp-caption-text\">Step 9: Choose Count Numbers, click OK<\/figcaption><\/figure>\n<h3>Media Attributions<\/h3>\n<ul>\n<li>Screenshots of Excel are used with <a href=\"https:\/\/www.microsoft.com\/en-us\/legal\/intellectualproperty\/copyright\/permissions\" target=\"_blank\" rel=\"noopener\">permission from Microsoft<\/a>.<\/li>\n<\/ul>\n","protected":false},"author":123,"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-37","chapter","type-chapter","status-publish","hentry"],"part":21,"_links":{"self":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/37","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/users\/123"}],"version-history":[{"count":6,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/37\/revisions"}],"predecessor-version":[{"id":343,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/37\/revisions\/343"}],"part":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/parts\/21"}],"metadata":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/37\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/media?parent=37"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapter-type?post=37"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/contributor?post=37"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/license?post=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}