{"id":67,"date":"2022-10-07T12:18:00","date_gmt":"2022-10-07T16:18:00","guid":{"rendered":"https:\/\/opentextbc.ca\/busstatsancillary\/chapter\/descriptive-statistics-excel-tools-instruction\/"},"modified":"2023-01-20T14:24:14","modified_gmt":"2023-01-20T19:24:14","slug":"descriptive-statistics-excel-tools-instruction","status":"publish","type":"chapter","link":"https:\/\/opentextbc.ca\/busstatsancillary\/chapter\/descriptive-statistics-excel-tools-instruction\/","title":{"raw":"Descriptive Statistics - Excel Tools Instruction","rendered":"Descriptive Statistics &#8211; Excel Tools Instruction"},"content":{"raw":"<div class=\"textbox\">Download <a href=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2022\/10\/Descriptive-Statistics-\u2013-Excel-Instructions-Data-Sets.xlsx\">Descriptive Statistics \u2013 Excel Instructions Data Sets [XLSX]<\/a>.<\/div>\r\n<h1>Histogram<\/h1>\r\n<ul>\r\n \t<li>A <strong>histogram<\/strong> consists of contiguous (adjoining) boxes. It has both a horizontal axis and a vertical axis. The horizontal axis is labeled with what the data represents (for instance, distance from your home to school). The vertical axis is labeled either <strong>frequency<\/strong> or <strong>relative frequency<\/strong> (or percent frequency or probability). The graph will have the same shape with either label. The histogram (like the stemplot) can give you the shape of the data, the center, and the spread of the data.<\/li>\r\n<\/ul>\r\n<h2>Histogram in Excel<\/h2>\r\nThe following data are the heights (in inches to the nearest half inch) of 100 male semiprofessional soccer players. The heights are continuous data, since height is measured.\r\n\r\n60; 60.5; 61; 61; 61.5; 63.5; 63.5; 63.5; 64; 64; 64; 64; 64; 64; 64; 64.5; 64.5; 64.5; 64.5; 64.5; 64.5; 64.5; 64.5 66; 66; 66; 66; 66; 66; 66; 66; 66; 66; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 67; 67; 67; 67; 67; 67; 67; 67; 67; 67; 67; 67; 67.5; 67.5; 67.5; 67.5; 67.5; 67.5; 67.5; 68; 68; 69; 69; 69; 69; 69; 69; 69; 69; 69; 69; 69.5; 69.5; 69.5; 69.5; 69.5; 70; 70; 70; 70; 70; 70; 70.5; 70.5; 70.5; 71; 71; 71; 72; 72; 72; 72.5; 72.5; 73; 73.5; 74\r\n<ol>\r\n \t<li>Enter <span style=\"color: #eb0000;\">the data<\/span> into column A. Create <span style=\"color: #eb0000;\">bins Range<\/span> into column C<\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Data<\/span>, <span style=\"color: #eb0000;\">Data Analysis<\/span>, <span style=\"color: #eb0000;\">Histogram<\/span> and <span style=\"color: #eb0000;\">OK<\/span><\/li>\r\n \t<li>Specify <span style=\"color: #eb0000;\">Input Range ($A$1:$A$101)<\/span>, <span style=\"color: #eb0000;\">Bin Range ($C$1:$C$9)<\/span>, and <span style=\"color: #eb0000;\">Output Range ($E$1)<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Labels<\/span>, <span style=\"color: #eb0000;\">Chart Output<\/span> and <span style=\"color: #eb0000;\">OK<\/span><\/li>\r\n \t<li>Make <span style=\"color: #eb0000;\">changes<\/span> for the Histogram (i.e. delete <span style=\"color: #eb0000;\">Frequency<\/span>, <span style=\"color: #eb0000;\">More<\/span> on the right side)<\/li>\r\n \t<li>Click on <span style=\"color: #eb0000;\">one blue rectangle<\/span>, right click, click <span style=\"color: #eb0000;\">Format Data Series<\/span><\/li>\r\n<\/ol>\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"422\"]<img class=\"wp-image-41 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/OER1.jpg\" alt=\"\" width=\"422\" height=\"305\" \/> Step 1, 2, 3 &amp; 4: Enter data into column A, create bins Range into column C. Click Data, Data Analysis, Histogram and click OK. Specify Input Range ($A$1:$A$101), Bin Range ($C$1:$C$9), and Output Range ($E$1), then click Labels, Chart Output and OK[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"422\"]<img class=\"wp-image-42 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER2.jpg\" alt=\"\" width=\"422\" height=\"301\" \/> Step 5 &amp; 6: Make changes for the Histogram, click on one blue rectangle, right click, click Format Data Series[\/caption]\r\n<ol start=\"7\">\r\n \t<li>To change the \u2018gap width\u2019, click on symbol \u0131 under <span style=\"color: #eb0000;\">Gap Width<\/span> slide line, hold and slide it to <span style=\"color: #eb0000;\">0%<\/span><\/li>\r\n \t<li>Click on the <span style=\"color: #eb0000;\">Histogram<\/span> and icon <strong><span style=\"color: #2d8659;\">+<\/span><\/strong> to make changes<\/li>\r\n \t<li>Change Axis Titles<\/li>\r\n<\/ol>\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"534\"]<img class=\"wp-image-43 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER3.jpg\" alt=\"\" width=\"534\" height=\"226\" \/> Step 7: To change the \u2018gap width\u2019, click on symbol \u0131 under Gap Width slide line, hold and slide it to 0%[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"488\"]<img class=\"wp-image-44 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER4.jpg\" alt=\"\" width=\"488\" height=\"209\" \/> Step 8 &amp; 9: Click on the Histogram and icon + to make changes, Change Axis Titles[\/caption]\r\n\r\nTo change the <span style=\"color: #eb0000;\">bin range<\/span> on the histogram table, change the values in the X-Axis data.\r\n\r\n<img class=\"alignnone size-full wp-image-45\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.03.26-AM.png\" alt=\"\" width=\"1835\" height=\"723\" \/>\r\n<h1>Line Chart<\/h1>\r\n<ul>\r\n \t<li>A <strong>line chart<\/strong> is often used to represent a set of data values in which a quantity varies with time. These graphs are useful for finding trends. That is, finding a general pattern in data sets including temperature, sales, employment, company profit or cost over a period of time.<\/li>\r\n<\/ul>\r\n<h2>Line chart in Excel<\/h2>\r\n<ol>\r\n \t<li>Enter the data (Year and Annual) into <span style=\"color: #eb0000;\">column A, B<\/span><\/li>\r\n \t<li>Highlight the columns of data, click <span style=\"color: #eb0000;\">Insert<\/span>, <span style=\"color: #eb0000;\">Line Chart<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">\u201cMore Line Charts\u201d<\/span><\/li>\r\n \t<li>Choose the graph with a single line.<\/li>\r\n<\/ol>\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"870\"]<img class=\"wp-image-46 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.05.43-AM.png\" alt=\"\" width=\"870\" height=\"413\" \/> Table 2.19 Construct a line chart for the Annual Consumer Price Index data only[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"810\"]<img class=\"wp-image-47 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER8.png\" alt=\"\" width=\"810\" height=\"739\" \/> Step 1, 2 &amp; 3: Enter the data (Year and Annual) into column A, B, then highlight the columns of data, click Insert, Line Chart. Click \u201cMore Line Charts\u201d[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"916\"]<img class=\"wp-image-48 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER9.png\" alt=\"\" width=\"916\" height=\"682\" \/> Step 4: Choose the graph with a single line[\/caption]\r\n<ol start=\"5\">\r\n \t<li>Click on <span style=\"color: #eb0000;\">Y-axis data<\/span>, <span style=\"color: #eb0000;\">right click<\/span>, <span style=\"color: #eb0000;\">Format Axis<\/span><\/li>\r\n \t<li>Change <span style=\"color: #eb0000;\">Minimum<\/span> and <span style=\"color: #eb0000;\">Maximum values<\/span> which suit your data best, click <span style=\"color: #eb0000;\">Enter<\/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 Axis title changes<\/li>\r\n<\/ol>\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"482\"]<img class=\"wp-image-49 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER10.jpg\" alt=\"\" width=\"482\" height=\"305\" \/> Step 5: Click on Y-axis data, right click, Format Axis[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"552\"]<img class=\"wp-image-50 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER11.jpg\" alt=\"\" width=\"552\" height=\"218\" \/> Step 6: Change Minimum and Maximum values which suit your data best, click Enter[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"783\"]<img class=\"wp-image-51 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER12.png\" alt=\"\" width=\"783\" height=\"468\" \/> Step 7: Click on the new bar graph and icon + to make Axis title changes[\/caption]\r\n<h1>Mean, Median &amp; Mode<\/h1>\r\n<ul>\r\n \t<li><strong>Mean:<\/strong> a number that measures the central tendency of the data; a common name for mean is 'average'.<\/li>\r\n \t<li><strong>Median:<\/strong> a number that separates ordered data into halves; half the values are the same number or smaller than the median and half the values are the same number or larger than the median. The median may or may not be part of the data.<\/li>\r\n \t<li><strong>Mode:<\/strong> the value that appears most frequently in a set of data.<\/li>\r\n<\/ul>\r\n<h2>Mean, Median &amp; Mode in Excel\u00a0(<span style=\"color: #eb0000;\">Formula tool<\/span>)<\/h2>\r\nUse the following information to answer the next three exercises: The following data show the lengths of boats moored in a marina. The data are ordered from smallest to largest:\r\n\r\n16; 17; 19; 20; 20; 21; 23; 24; 25; 25; 25; 26; 26; 27; 27; 27; 28; 29; 30; 32; 33; 33; 34; 35; 37; 39; 40\r\n<ol>\r\n \t<li>Enter the <span style=\"color: #eb0000;\">data<\/span> into <span style=\"color: #eb0000;\">column A<\/span><\/li>\r\n \t<li>Create a table for <span style=\"color: #eb0000;\">Mean, Median<\/span> and <span style=\"color: #eb0000;\">Mode<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=AVERAGE(A:A)<\/span> in cell <span style=\"color: #eb0000;\">D2<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=MEDIAN(A:A)<\/span> in cell <span style=\"color: #eb0000;\">D3<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=MODE(A:A)<\/span> in cell <span style=\"color: #eb0000;\">D4<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n<\/ol>\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"429\"]<img class=\"wp-image-52 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER13.jpg\" alt=\"\" width=\"429\" height=\"240\" \/> Step 1, 2 &amp; 3: Enter the data into column A. Create a table for Mean, Median and Mode. Enter =AVERAGE(A:A) in cell D2, click Enter[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"400\"]<img class=\"wp-image-53 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER14.jpg\" alt=\"\" width=\"400\" height=\"241\" \/> Step 4: Enter =MEDIAN(A:A) in cell D3, click Enter[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"406\"]<img class=\"wp-image-54 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER15.jpg\" alt=\"\" width=\"406\" height=\"241\" \/> Step 5: Enter =MODE(A:A) in cell D4, click Enter[\/caption]\r\n<h2>Mean, Median &amp; Mode in Excel (<span style=\"color: #eb0000;\">Data Analysis tool<\/span>)<\/h2>\r\nUse the following information to answer the next three exercises: The following data show the lengths of boats moored in a marina. The data are ordered from smallest to largest:\r\n\r\n16; 17; 19; 20; 20; 21; 23; 24; 25; 25; 25; 26; 26; 27; 27; 27; 28; 29; 30; 32; 33; 33; 34; 35; 37; 39; 40\r\n<ol>\r\n \t<li>Enter the <span style=\"color: #eb0000;\">data<\/span> into <span style=\"color: #eb0000;\">column A<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Data<\/span>, <span style=\"color: #eb0000;\">Data Analysis<\/span><\/li>\r\n \t<li>Click Descriptive Statistics, OK<\/li>\r\n \t<li>Specify <span style=\"color: #eb0000;\">Input Range ($A$1:$A$28)<\/span>, <span style=\"color: #eb0000;\">Output Range ($C$1)<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Labels in first row,<\/span> <span style=\"color: #eb0000;\">Summary statistics<\/span> and <span style=\"color: #eb0000;\">OK<\/span><\/li>\r\n \t<li>Find Mean, Median and Mode in the Summary statistics table<\/li>\r\n<\/ol>\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"325\"]<img class=\"wp-image-55 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER16.jpg\" alt=\"\" width=\"325\" height=\"285\" \/> Step 1 &amp; 2: Enter the data into column A and Click Data, Data Analysis[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"320\"]<img class=\"wp-image-56 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER17.jpg\" alt=\"\" width=\"320\" height=\"281\" \/> Step 3, 4 &amp; 5: Click Descriptive Statistics, click OK. Specify Input Range ($A$1:$A$28), Output Range ($C$1). Click Labels in first row, Summary statistics and OK[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"290\"]<img class=\"wp-image-57 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER18.jpg\" alt=\"\" width=\"290\" height=\"282\" \/> Step 6: Find Mean, Median and Mode in the Summary statistics table[\/caption]\r\n<h1>Variance &amp; Standard Deviation<\/h1>\r\n<ul>\r\n \t<li>The <strong>variance<\/strong> is the <strong>average of the squares of the deviations<\/strong>.<\/li>\r\n \t<li>If x is a number, then the difference \"x minus the mean\" is called its <strong>deviation<\/strong>. The standard deviation is a number that is equal to the square root of the variance and measures how far data values are\r\nfrom their mean.<\/li>\r\n \t<li>Notation: s for sample standard deviation and \u03c3 for population standard deviation.<\/li>\r\n<\/ul>\r\n<h2>Variance and Standard Deviation in Excel (<span style=\"color: #eb0000;\">Formula tool<\/span>)<\/h2>\r\nIn a fifth-grade class, the teacher was interested in the average age and the sample standard deviation of the ages of her students. The following data are the ages for a SAMPLE of n = 20 fifth grade students. The ages are rounded to the nearest half year: 9; 9.5; 9.5; 10; 10; 10; 10; 10.5; 10.5; 10.5; 10.5; 11; 11; 11; 11; 11; 11; 11.5; 11.5; 11.5;\r\n<ol>\r\n \t<li>Enter the <span style=\"color: #eb0000;\">data<\/span> into <span style=\"color: #eb0000;\">column A<\/span><\/li>\r\n \t<li>Create a table for <span style=\"color: #eb0000;\">Variance<\/span> and <span style=\"color: #eb0000;\">Standard deviation<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=VAR.S(A:A)<\/span> in cell <span style=\"color: #eb0000;\">D2<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=STDEV.S(A:A)<\/span> in cell <span style=\"color: #eb0000;\">D3<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n<\/ol>\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"422\"]<img class=\"wp-image-58 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER19.jpg\" alt=\"\" width=\"422\" height=\"266\" \/> Step 1, 2 &amp; 3: Enter the data into column A and create a table for Variance and Standard deviation. Enter =VAR.S(A:A) in cell D2, click Enter[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"409\"]<img class=\"wp-image-59 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER20.jpg\" alt=\"\" width=\"409\" height=\"268\" \/> Step 4: Enter =STDEV.S(A:A) in cell D3, click Enter[\/caption]\r\n<h2>Variance and Standard Deviation in Excel (<span style=\"color: #eb0000;\">Data Analysis tool<\/span>)<\/h2>\r\nIn a fifth-grade class, the teacher was interested in the average age and the sample standard deviation of the ages of her students. The following data are the ages for a SAMPLE of n = 20 fifth grade students. The ages are rounded to the nearest half year: 9; 9.5; 9.5; 10; 10; 10; 10; 10.5; 10.5; 10.5; 10.5; 11; 11; 11; 11; 11; 11; 11.5; 11.5; 11.5;\r\n<ol>\r\n \t<li>Enter the <span style=\"color: #eb0000;\">data<\/span> into <span style=\"color: #eb0000;\">column A<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Data<\/span>, <span style=\"color: #eb0000;\">Data Analysis<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Descriptive Statistics<\/span>, <span style=\"color: #eb0000;\">OK<\/span><\/li>\r\n \t<li>Specify <span style=\"color: #eb0000;\">Input Range ($A$1:$A$21)<\/span>, <span style=\"color: #eb0000;\">Output Range ($C$6)<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">Labels in first row<\/span>, <span style=\"color: #eb0000;\">Summary statistics<\/span> and <span style=\"color: #eb0000;\">OK<\/span><\/li>\r\n \t<li>Find <span style=\"color: #eb0000;\">Variance<\/span> and <span style=\"color: #eb0000;\">Standard Deviation<\/span> in the Summary statistics table<\/li>\r\n<\/ol>\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"324\"]<img class=\"wp-image-60 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER21.jpg\" alt=\"\" width=\"324\" height=\"325\" \/> Step 1 &amp; 2: Enter the data into column A and Click Data, Data Analysis[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"376\"]<img class=\"wp-image-61 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER22.jpg\" alt=\"\" width=\"376\" height=\"325\" \/> Step 3, 4 &amp; 5: Click Descriptive Statistics, click OK. Specify Input Range ($A$1:$A$21), Output Range ($C$6). Click Labels in first row, Summary statistics and OK[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"286\"]<img class=\"wp-image-62 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER23.jpg\" alt=\"\" width=\"286\" height=\"324\" \/> Step 6: Find Variance and Standard Deviation in the Summary statistics table[\/caption]\r\n<h1>Quartiles<\/h1>\r\n<ul>\r\n \t<li><strong>Quartiles<\/strong> are the numbers that separate the data into quarters; quartiles may or may not be part of the data. The second quartile is the median of the data.<\/li>\r\n<\/ul>\r\n<h2>Quartiles in Excel<\/h2>\r\nUse the following data (first exam scores) from Susan Dean's spring pre-calculus class:\r\n\r\n33; 42; 49; 49; 53; 55; 55; 61; 63; 67; 68; 68; 69; 69; 72; 73; 74; 78; 80; 83; 88; 88; 88; 90; 92; 94; 94; 94; 94; 96; 100\r\n<ol>\r\n \t<li>Enter the <span style=\"color: #eb0000;\">data<\/span> into <span style=\"color: #eb0000;\">column A<\/span>, and <span style=\"color: #eb0000;\">sort them<\/span><\/li>\r\n \t<li>Create a table for <span style=\"color: #eb0000;\">Q1, Q2, Q3<\/span> and <span style=\"color: #eb0000;\">Q3-Q1<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=QUARTILE.EXC($A:$A,1)<\/span> in cell <span style=\"color: #eb0000;\">D2<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=QUARTILE.EXC($A:$A,2)<\/span> in cell <span style=\"color: #eb0000;\">D3<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=QUARTILE.EXC($A:$A,3)<\/span> in cell <span style=\"color: #eb0000;\">D4<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=<\/span> in cell <span style=\"color: #eb0000;\">D5<\/span>, click on cell <span style=\"color: #eb0000;\">D4<\/span>, enter <span style=\"color: #eb0000;\">-<\/span>, clike on cell <span style=\"color: #eb0000;\">D2<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n<\/ol>\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"376\"]<img class=\"wp-image-63 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q1.jpg\" alt=\"\" width=\"376\" height=\"182\" \/> Step 1, 2 &amp; 3: Enter the data into column A, and sort them. Create a table for Q1, Q2, Q3 and Q3-Q1. Enter =QUARTILE.EXC($A:$A,1) in cell D2, click Enter[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"373\"]<img class=\"wp-image-64 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q2.jpg\" alt=\"\" width=\"373\" height=\"166\" \/> Step 4: Enter =QUARTILE.EXC($A:$A,2) in cell D3, click Enter[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"362\"]<img class=\"wp-image-65 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q3.jpg\" alt=\"\" width=\"362\" height=\"160\" \/> Step 5: Enter =QUARTILE.EXC($A:$A,3) in cell D4, click Enter[\/caption]\r\n\r\n[caption id=\"attachment_66\" align=\"aligncenter\" width=\"374\"]<img class=\"wp-image-66 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q4.jpg\" alt=\"\" width=\"374\" height=\"166\" \/> Step 6: Enter = in cell D5, click on cell D4, enter -, clike on cell D2, click Enter[\/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\/Descriptive-Statistics-\u2013-Excel-Instructions-Data-Sets.xlsx\">Descriptive Statistics \u2013 Excel Instructions Data Sets [XLSX]<\/a>.<\/div>\n<h1>Histogram<\/h1>\n<ul>\n<li>A <strong>histogram<\/strong> consists of contiguous (adjoining) boxes. It has both a horizontal axis and a vertical axis. The horizontal axis is labeled with what the data represents (for instance, distance from your home to school). The vertical axis is labeled either <strong>frequency<\/strong> or <strong>relative frequency<\/strong> (or percent frequency or probability). The graph will have the same shape with either label. The histogram (like the stemplot) can give you the shape of the data, the center, and the spread of the data.<\/li>\n<\/ul>\n<h2>Histogram in Excel<\/h2>\n<p>The following data are the heights (in inches to the nearest half inch) of 100 male semiprofessional soccer players. The heights are continuous data, since height is measured.<\/p>\n<p>60; 60.5; 61; 61; 61.5; 63.5; 63.5; 63.5; 64; 64; 64; 64; 64; 64; 64; 64.5; 64.5; 64.5; 64.5; 64.5; 64.5; 64.5; 64.5 66; 66; 66; 66; 66; 66; 66; 66; 66; 66; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 66.5; 67; 67; 67; 67; 67; 67; 67; 67; 67; 67; 67; 67; 67.5; 67.5; 67.5; 67.5; 67.5; 67.5; 67.5; 68; 68; 69; 69; 69; 69; 69; 69; 69; 69; 69; 69; 69.5; 69.5; 69.5; 69.5; 69.5; 70; 70; 70; 70; 70; 70; 70.5; 70.5; 70.5; 71; 71; 71; 72; 72; 72; 72.5; 72.5; 73; 73.5; 74<\/p>\n<ol>\n<li>Enter <span style=\"color: #eb0000;\">the data<\/span> into column A. Create <span style=\"color: #eb0000;\">bins Range<\/span> into column C<\/li>\n<li>Click <span style=\"color: #eb0000;\">Data<\/span>, <span style=\"color: #eb0000;\">Data Analysis<\/span>, <span style=\"color: #eb0000;\">Histogram<\/span> and <span style=\"color: #eb0000;\">OK<\/span><\/li>\n<li>Specify <span style=\"color: #eb0000;\">Input Range ($A$1:$A$101)<\/span>, <span style=\"color: #eb0000;\">Bin Range ($C$1:$C$9)<\/span>, and <span style=\"color: #eb0000;\">Output Range ($E$1)<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">Labels<\/span>, <span style=\"color: #eb0000;\">Chart Output<\/span> and <span style=\"color: #eb0000;\">OK<\/span><\/li>\n<li>Make <span style=\"color: #eb0000;\">changes<\/span> for the Histogram (i.e. delete <span style=\"color: #eb0000;\">Frequency<\/span>, <span style=\"color: #eb0000;\">More<\/span> on the right side)<\/li>\n<li>Click on <span style=\"color: #eb0000;\">one blue rectangle<\/span>, right click, click <span style=\"color: #eb0000;\">Format Data Series<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 422px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-41 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/OER1.jpg\" alt=\"\" width=\"422\" height=\"305\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/OER1.jpg 422w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/OER1-300x217.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/OER1-65x47.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/OER1-225x163.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/OER1-350x253.jpg 350w\" sizes=\"auto, (max-width: 422px) 100vw, 422px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 1, 2, 3 &amp; 4: Enter data into column A, create bins Range into column C. Click Data, Data Analysis, Histogram and click OK. Specify Input Range ($A$1:$A$101), Bin Range ($C$1:$C$9), and Output Range ($E$1), then click Labels, Chart Output and OK<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 422px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-42 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER2.jpg\" alt=\"\" width=\"422\" height=\"301\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER2.jpg 422w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER2-300x214.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER2-65x46.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER2-225x160.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER2-350x250.jpg 350w\" sizes=\"auto, (max-width: 422px) 100vw, 422px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 5 &amp; 6: Make changes for the Histogram, click on one blue rectangle, right click, click Format Data Series<\/figcaption><\/figure>\n<ol start=\"7\">\n<li>To change the \u2018gap width\u2019, click on symbol \u0131 under <span style=\"color: #eb0000;\">Gap Width<\/span> slide line, hold and slide it to <span style=\"color: #eb0000;\">0%<\/span><\/li>\n<li>Click on the <span style=\"color: #eb0000;\">Histogram<\/span> and icon <strong><span style=\"color: #2d8659;\">+<\/span><\/strong> to make changes<\/li>\n<li>Change Axis Titles<\/li>\n<\/ol>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 534px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-43 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER3.jpg\" alt=\"\" width=\"534\" height=\"226\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER3.jpg 534w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER3-300x127.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER3-65x28.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER3-225x95.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER3-350x148.jpg 350w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 7: To change the \u2018gap width\u2019, click on symbol \u0131 under Gap Width slide line, hold and slide it to 0%<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 488px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-44 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER4.jpg\" alt=\"\" width=\"488\" height=\"209\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER4.jpg 488w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER4-300x128.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER4-65x28.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER4-225x96.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER4-350x150.jpg 350w\" sizes=\"auto, (max-width: 488px) 100vw, 488px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 8 &amp; 9: Click on the Histogram and icon + to make changes, Change Axis Titles<\/figcaption><\/figure>\n<p>To change the <span style=\"color: #eb0000;\">bin range<\/span> on the histogram table, change the values in the X-Axis data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-45\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.03.26-AM.png\" alt=\"\" width=\"1835\" height=\"723\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.03.26-AM.png 1835w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.03.26-AM-300x118.png 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.03.26-AM-1024x403.png 1024w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.03.26-AM-768x303.png 768w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.03.26-AM-1536x605.png 1536w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.03.26-AM-65x26.png 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.03.26-AM-225x89.png 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.03.26-AM-350x138.png 350w\" sizes=\"auto, (max-width: 1835px) 100vw, 1835px\" \/><\/p>\n<h1>Line Chart<\/h1>\n<ul>\n<li>A <strong>line chart<\/strong> is often used to represent a set of data values in which a quantity varies with time. These graphs are useful for finding trends. That is, finding a general pattern in data sets including temperature, sales, employment, company profit or cost over a period of time.<\/li>\n<\/ul>\n<h2>Line chart in Excel<\/h2>\n<ol>\n<li>Enter the data (Year and Annual) into <span style=\"color: #eb0000;\">column A, B<\/span><\/li>\n<li>Highlight the columns of data, click <span style=\"color: #eb0000;\">Insert<\/span>, <span style=\"color: #eb0000;\">Line Chart<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">\u201cMore Line Charts\u201d<\/span><\/li>\n<li>Choose the graph with a single line.<\/li>\n<\/ol>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 870px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-46 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.05.43-AM.png\" alt=\"\" width=\"870\" height=\"413\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.05.43-AM.png 870w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.05.43-AM-300x142.png 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.05.43-AM-768x365.png 768w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.05.43-AM-65x31.png 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.05.43-AM-225x107.png 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.05.43-AM-350x166.png 350w\" sizes=\"auto, (max-width: 870px) 100vw, 870px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Table 2.19 Construct a line chart for the Annual Consumer Price Index data only<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER8.png\" alt=\"\" width=\"810\" height=\"739\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER8.png 810w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER8-300x274.png 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER8-768x701.png 768w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER8-65x59.png 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER8-225x205.png 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER8-350x319.png 350w\" sizes=\"auto, (max-width: 810px) 100vw, 810px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 1, 2 &amp; 3: Enter the data (Year and Annual) into column A, B, then highlight the columns of data, click Insert, Line Chart. Click \u201cMore Line Charts\u201d<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 916px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-48 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER9.png\" alt=\"\" width=\"916\" height=\"682\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER9.png 916w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER9-300x223.png 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER9-768x572.png 768w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER9-65x48.png 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER9-225x168.png 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER9-350x261.png 350w\" sizes=\"auto, (max-width: 916px) 100vw, 916px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 4: Choose the graph with a single line<\/figcaption><\/figure>\n<ol start=\"5\">\n<li>Click on <span style=\"color: #eb0000;\">Y-axis data<\/span>, <span style=\"color: #eb0000;\">right click<\/span>, <span style=\"color: #eb0000;\">Format Axis<\/span><\/li>\n<li>Change <span style=\"color: #eb0000;\">Minimum<\/span> and <span style=\"color: #eb0000;\">Maximum values<\/span> which suit your data best, click <span style=\"color: #eb0000;\">Enter<\/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 Axis title changes<\/li>\n<\/ol>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 482px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER10.jpg\" alt=\"\" width=\"482\" height=\"305\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER10.jpg 482w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER10-300x190.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER10-65x41.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER10-225x142.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER10-350x221.jpg 350w\" sizes=\"auto, (max-width: 482px) 100vw, 482px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 5: Click on Y-axis data, right click, Format Axis<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 552px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER11.jpg\" alt=\"\" width=\"552\" height=\"218\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER11.jpg 552w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER11-300x118.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER11-65x26.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER11-225x89.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER11-350x138.jpg 350w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 6: Change Minimum and Maximum values which suit your data best, click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 783px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER12.png\" alt=\"\" width=\"783\" height=\"468\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER12.png 783w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER12-300x179.png 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER12-768x459.png 768w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER12-65x39.png 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER12-225x134.png 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER12-350x209.png 350w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 7: Click on the new bar graph and icon + to make Axis title changes<\/figcaption><\/figure>\n<h1>Mean, Median &amp; Mode<\/h1>\n<ul>\n<li><strong>Mean:<\/strong> a number that measures the central tendency of the data; a common name for mean is &#8216;average&#8217;.<\/li>\n<li><strong>Median:<\/strong> a number that separates ordered data into halves; half the values are the same number or smaller than the median and half the values are the same number or larger than the median. The median may or may not be part of the data.<\/li>\n<li><strong>Mode:<\/strong> the value that appears most frequently in a set of data.<\/li>\n<\/ul>\n<h2>Mean, Median &amp; Mode in Excel\u00a0(<span style=\"color: #eb0000;\">Formula tool<\/span>)<\/h2>\n<p>Use the following information to answer the next three exercises: The following data show the lengths of boats moored in a marina. The data are ordered from smallest to largest:<\/p>\n<p>16; 17; 19; 20; 20; 21; 23; 24; 25; 25; 25; 26; 26; 27; 27; 27; 28; 29; 30; 32; 33; 33; 34; 35; 37; 39; 40<\/p>\n<ol>\n<li>Enter the <span style=\"color: #eb0000;\">data<\/span> into <span style=\"color: #eb0000;\">column A<\/span><\/li>\n<li>Create a table for <span style=\"color: #eb0000;\">Mean, Median<\/span> and <span style=\"color: #eb0000;\">Mode<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">=AVERAGE(A:A)<\/span> in cell <span style=\"color: #eb0000;\">D2<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">=MEDIAN(A:A)<\/span> in cell <span style=\"color: #eb0000;\">D3<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">=MODE(A:A)<\/span> in cell <span style=\"color: #eb0000;\">D4<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 429px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER13.jpg\" alt=\"\" width=\"429\" height=\"240\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER13.jpg 429w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER13-300x168.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER13-65x36.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER13-225x126.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER13-350x196.jpg 350w\" sizes=\"auto, (max-width: 429px) 100vw, 429px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 1, 2 &amp; 3: Enter the data into column A. Create a table for Mean, Median and Mode. Enter =AVERAGE(A:A) in cell D2, click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER14.jpg\" alt=\"\" width=\"400\" height=\"241\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER14.jpg 400w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER14-300x181.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER14-65x39.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER14-225x136.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER14-350x211.jpg 350w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 4: Enter =MEDIAN(A:A) in cell D3, click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 406px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER15.jpg\" alt=\"\" width=\"406\" height=\"241\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER15.jpg 406w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER15-300x178.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER15-65x39.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER15-225x134.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER15-350x208.jpg 350w\" sizes=\"auto, (max-width: 406px) 100vw, 406px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 5: Enter =MODE(A:A) in cell D4, click Enter<\/figcaption><\/figure>\n<h2>Mean, Median &amp; Mode in Excel (<span style=\"color: #eb0000;\">Data Analysis tool<\/span>)<\/h2>\n<p>Use the following information to answer the next three exercises: The following data show the lengths of boats moored in a marina. The data are ordered from smallest to largest:<\/p>\n<p>16; 17; 19; 20; 20; 21; 23; 24; 25; 25; 25; 26; 26; 27; 27; 27; 28; 29; 30; 32; 33; 33; 34; 35; 37; 39; 40<\/p>\n<ol>\n<li>Enter the <span style=\"color: #eb0000;\">data<\/span> into <span style=\"color: #eb0000;\">column A<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">Data<\/span>, <span style=\"color: #eb0000;\">Data Analysis<\/span><\/li>\n<li>Click Descriptive Statistics, OK<\/li>\n<li>Specify <span style=\"color: #eb0000;\">Input Range ($A$1:$A$28)<\/span>, <span style=\"color: #eb0000;\">Output Range ($C$1)<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">Labels in first row,<\/span> <span style=\"color: #eb0000;\">Summary statistics<\/span> and <span style=\"color: #eb0000;\">OK<\/span><\/li>\n<li>Find Mean, Median and Mode in the Summary statistics table<\/li>\n<\/ol>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 325px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER16.jpg\" alt=\"\" width=\"325\" height=\"285\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER16.jpg 325w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER16-300x263.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER16-65x57.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER16-225x197.jpg 225w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 1 &amp; 2: Enter the data into column A and Click Data, Data Analysis<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 320px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-56 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER17.jpg\" alt=\"\" width=\"320\" height=\"281\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER17.jpg 320w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER17-300x263.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER17-65x57.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER17-225x198.jpg 225w\" sizes=\"auto, (max-width: 320px) 100vw, 320px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 3, 4 &amp; 5: Click Descriptive Statistics, click OK. Specify Input Range ($A$1:$A$28), Output Range ($C$1). Click Labels in first row, Summary statistics and OK<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 290px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER18.jpg\" alt=\"\" width=\"290\" height=\"282\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER18.jpg 290w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER18-65x63.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER18-225x219.jpg 225w\" sizes=\"auto, (max-width: 290px) 100vw, 290px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 6: Find Mean, Median and Mode in the Summary statistics table<\/figcaption><\/figure>\n<h1>Variance &amp; Standard Deviation<\/h1>\n<ul>\n<li>The <strong>variance<\/strong> is the <strong>average of the squares of the deviations<\/strong>.<\/li>\n<li>If x is a number, then the difference &#8220;x minus the mean&#8221; is called its <strong>deviation<\/strong>. The standard deviation is a number that is equal to the square root of the variance and measures how far data values are<br \/>\nfrom their mean.<\/li>\n<li>Notation: s for sample standard deviation and \u03c3 for population standard deviation.<\/li>\n<\/ul>\n<h2>Variance and Standard Deviation in Excel (<span style=\"color: #eb0000;\">Formula tool<\/span>)<\/h2>\n<p>In a fifth-grade class, the teacher was interested in the average age and the sample standard deviation of the ages of her students. The following data are the ages for a SAMPLE of n = 20 fifth grade students. The ages are rounded to the nearest half year: 9; 9.5; 9.5; 10; 10; 10; 10; 10.5; 10.5; 10.5; 10.5; 11; 11; 11; 11; 11; 11; 11.5; 11.5; 11.5;<\/p>\n<ol>\n<li>Enter the <span style=\"color: #eb0000;\">data<\/span> into <span style=\"color: #eb0000;\">column A<\/span><\/li>\n<li>Create a table for <span style=\"color: #eb0000;\">Variance<\/span> and <span style=\"color: #eb0000;\">Standard deviation<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">=VAR.S(A:A)<\/span> in cell <span style=\"color: #eb0000;\">D2<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">=STDEV.S(A:A)<\/span> in cell <span style=\"color: #eb0000;\">D3<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 422px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER19.jpg\" alt=\"\" width=\"422\" height=\"266\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER19.jpg 422w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER19-300x189.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER19-65x41.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER19-225x142.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER19-350x221.jpg 350w\" sizes=\"auto, (max-width: 422px) 100vw, 422px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 1, 2 &amp; 3: Enter the data into column A and create a table for Variance and Standard deviation. Enter =VAR.S(A:A) in cell D2, click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 409px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-59 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER20.jpg\" alt=\"\" width=\"409\" height=\"268\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER20.jpg 409w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER20-300x197.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER20-65x43.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER20-225x147.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER20-350x229.jpg 350w\" sizes=\"auto, (max-width: 409px) 100vw, 409px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 4: Enter =STDEV.S(A:A) in cell D3, click Enter<\/figcaption><\/figure>\n<h2>Variance and Standard Deviation in Excel (<span style=\"color: #eb0000;\">Data Analysis tool<\/span>)<\/h2>\n<p>In a fifth-grade class, the teacher was interested in the average age and the sample standard deviation of the ages of her students. The following data are the ages for a SAMPLE of n = 20 fifth grade students. The ages are rounded to the nearest half year: 9; 9.5; 9.5; 10; 10; 10; 10; 10.5; 10.5; 10.5; 10.5; 11; 11; 11; 11; 11; 11; 11.5; 11.5; 11.5;<\/p>\n<ol>\n<li>Enter the <span style=\"color: #eb0000;\">data<\/span> into <span style=\"color: #eb0000;\">column A<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">Data<\/span>, <span style=\"color: #eb0000;\">Data Analysis<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">Descriptive Statistics<\/span>, <span style=\"color: #eb0000;\">OK<\/span><\/li>\n<li>Specify <span style=\"color: #eb0000;\">Input Range ($A$1:$A$21)<\/span>, <span style=\"color: #eb0000;\">Output Range ($C$6)<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">Labels in first row<\/span>, <span style=\"color: #eb0000;\">Summary statistics<\/span> and <span style=\"color: #eb0000;\">OK<\/span><\/li>\n<li>Find <span style=\"color: #eb0000;\">Variance<\/span> and <span style=\"color: #eb0000;\">Standard Deviation<\/span> in the Summary statistics table<\/li>\n<\/ol>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 324px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER21.jpg\" alt=\"\" width=\"324\" height=\"325\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER21.jpg 324w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER21-300x300.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER21-150x150.jpg 150w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER21-65x65.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER21-225x226.jpg 225w\" sizes=\"auto, (max-width: 324px) 100vw, 324px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 1 &amp; 2: Enter the data into column A and Click Data, Data Analysis<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 376px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER22.jpg\" alt=\"\" width=\"376\" height=\"325\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER22.jpg 376w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER22-300x259.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER22-65x56.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER22-225x194.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER22-350x303.jpg 350w\" sizes=\"auto, (max-width: 376px) 100vw, 376px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 3, 4 &amp; 5: Click Descriptive Statistics, click OK. Specify Input Range ($A$1:$A$21), Output Range ($C$6). Click Labels in first row, Summary statistics and OK<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 286px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER23.jpg\" alt=\"\" width=\"286\" height=\"324\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER23.jpg 286w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER23-265x300.jpg 265w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER23-65x74.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/OER23-225x255.jpg 225w\" sizes=\"auto, (max-width: 286px) 100vw, 286px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 6: Find Variance and Standard Deviation in the Summary statistics table<\/figcaption><\/figure>\n<h1>Quartiles<\/h1>\n<ul>\n<li><strong>Quartiles<\/strong> are the numbers that separate the data into quarters; quartiles may or may not be part of the data. The second quartile is the median of the data.<\/li>\n<\/ul>\n<h2>Quartiles in Excel<\/h2>\n<p>Use the following data (first exam scores) from Susan Dean&#8217;s spring pre-calculus class:<\/p>\n<p>33; 42; 49; 49; 53; 55; 55; 61; 63; 67; 68; 68; 69; 69; 72; 73; 74; 78; 80; 83; 88; 88; 88; 90; 92; 94; 94; 94; 94; 96; 100<\/p>\n<ol>\n<li>Enter the <span style=\"color: #eb0000;\">data<\/span> into <span style=\"color: #eb0000;\">column A<\/span>, and <span style=\"color: #eb0000;\">sort them<\/span><\/li>\n<li>Create a table for <span style=\"color: #eb0000;\">Q1, Q2, Q3<\/span> and <span style=\"color: #eb0000;\">Q3-Q1<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">=QUARTILE.EXC($A:$A,1)<\/span> in cell <span style=\"color: #eb0000;\">D2<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">=QUARTILE.EXC($A:$A,2)<\/span> in cell <span style=\"color: #eb0000;\">D3<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">=QUARTILE.EXC($A:$A,3)<\/span> in cell <span style=\"color: #eb0000;\">D4<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">=<\/span> in cell <span style=\"color: #eb0000;\">D5<\/span>, click on cell <span style=\"color: #eb0000;\">D4<\/span>, enter <span style=\"color: #eb0000;\">&#8211;<\/span>, clike on cell <span style=\"color: #eb0000;\">D2<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 376px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q1.jpg\" alt=\"\" width=\"376\" height=\"182\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q1.jpg 376w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q1-300x145.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q1-65x31.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q1-225x109.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q1-350x169.jpg 350w\" sizes=\"auto, (max-width: 376px) 100vw, 376px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 1, 2 &amp; 3: Enter the data into column A, and sort them. Create a table for Q1, Q2, Q3 and Q3-Q1. Enter =QUARTILE.EXC($A:$A,1) in cell D2, click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 373px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q2.jpg\" alt=\"\" width=\"373\" height=\"166\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q2.jpg 373w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q2-300x134.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q2-65x29.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q2-225x100.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q2-350x156.jpg 350w\" sizes=\"auto, (max-width: 373px) 100vw, 373px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 4: Enter =QUARTILE.EXC($A:$A,2) in cell D3, click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 362px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q3.jpg\" alt=\"\" width=\"362\" height=\"160\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q3.jpg 362w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q3-300x133.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q3-65x29.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q3-225x99.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q3-350x155.jpg 350w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 5: Enter =QUARTILE.EXC($A:$A,3) in cell D4, click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_66\" aria-describedby=\"caption-attachment-66\" style=\"width: 374px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q4.jpg\" alt=\"\" width=\"374\" height=\"166\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q4.jpg 374w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q4-300x133.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q4-65x29.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q4-225x100.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Q4-350x155.jpg 350w\" sizes=\"auto, (max-width: 374px) 100vw, 374px\" \/><figcaption id=\"caption-attachment-66\" class=\"wp-caption-text\">Step 6: Enter = in cell D5, click on cell D4, enter -, clike on cell D2, click Enter<\/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":5,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":"cc-by"},"chapter-type":[],"contributor":[],"license":[53],"class_list":["post-67","chapter","type-chapter","status-publish","hentry","license-cc-by"],"part":39,"_links":{"self":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/67","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":8,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/67\/revisions"}],"predecessor-version":[{"id":349,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/67\/revisions\/349"}],"part":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/parts\/39"}],"metadata":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/67\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/media?parent=67"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapter-type?post=67"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/contributor?post=67"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/license?post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}