{"id":77,"date":"2022-10-07T12:21:07","date_gmt":"2022-10-07T16:21:07","guid":{"rendered":"https:\/\/opentextbc.ca\/busstatsancillary\/chapter\/discrete-random-variables-excel-tools-instruction\/"},"modified":"2023-01-20T14:19:55","modified_gmt":"2023-01-20T19:19:55","slug":"discrete-random-variables-excel-tools-instruction","status":"publish","type":"chapter","link":"https:\/\/opentextbc.ca\/busstatsancillary\/chapter\/discrete-random-variables-excel-tools-instruction\/","title":{"raw":"Discrete Random Variables - Excel Tools Instruction","rendered":"Discrete Random Variables &#8211; Excel Tools Instruction"},"content":{"raw":"<div class=\"textbox\">Download <a href=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2022\/10\/Discrete-Random-Variables-\u2013-Excel-Instructions-Data-Sets.xlsx\">Discrete Random Variables \u2013 Excel Instructions Data Sets [XLSX]<\/a>.<\/div>\r\n<h1>Binomial Distribution<\/h1>\r\n<ul>\r\n \t<li>A more valuable probability density function with many applications is the <strong>binomial distribution<\/strong>. This distribution will compute probabilities for any binomial process.<\/li>\r\n<\/ul>\r\n<h2>Binomial Distribution in Excel<\/h2>\r\nA fair coin is flipped 15 times. Each flip is independent. What is the probability of getting more than ten heads?\r\n\r\nLet X = the number of heads in 15 flips of the fair coin. X takes on the values\r\n<ol>\r\n \t<li>Enter the <span style=\"color: #eb0000;\">value of n and p<\/span>. Create <span style=\"color: #eb0000;\">a table for the probability and cumulativ<\/span>e of\u00a00, 1, 2, 3, ..., 15.<\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">=BINOM.DIST(A5,$B$1,$B$2,FALSE)<\/span> in cell <span style=\"color: #eb0000;\">B5<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">B5<\/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 drag <span style=\"color: #eb0000;\">down<\/span><\/li>\r\n<\/ol>\r\n[caption id=\"attachment_76\" align=\"aligncenter\" width=\"334\"]<img class=\"wp-image-73 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/BI1.jpg\" alt=\"\" width=\"334\" height=\"377\" \/> Step 1 &amp; 2: Enter the value of n and p. Create a table for the probability and cumulative of\u00a00, 1, 2, 3, ..., 15. Enter =BINOM.DIST(A5,$B$1,$B$2,FALSE) in cell B5, click Enter[\/caption]\r\n\r\n[caption id=\"attachment_76\" align=\"aligncenter\" width=\"328\"]<img class=\"wp-image-74 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi2.jpg\" alt=\"\" width=\"328\" height=\"376\" \/> Step 3 &amp; 4: Click B5, move the mouse to the right bottom corner, a little + shows up. Click on the little + and drag down[\/caption]\r\n<ol start=\"5\">\r\n \t<li>Enter <span style=\"color: #eb0000;\">=BINOM.DIST(A5,$B$1,$B$2,TRUE)<\/span> in cell <span style=\"color: #eb0000;\">C5<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>Click <span style=\"color: #eb0000;\">C5<\/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><\/li>\r\n<\/ol>\r\n[caption id=\"attachment_76\" align=\"aligncenter\" width=\"400\"]<img class=\"wp-image-75 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi3.jpg\" alt=\"\" width=\"400\" height=\"230\" \/> Step 5: Enter =BINOM.DIST(A5,$B$1,$B$2,TRUE) in cell C5, click Enter[\/caption]\r\n\r\n[caption id=\"attachment_76\" align=\"aligncenter\" width=\"318\"]<img class=\"wp-image-76 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi4.jpg\" alt=\"\" width=\"318\" height=\"364\" \/> Step 6 &amp; 7: Click C5, move the mouse to the right bottom corner, a little + shows up. Click on the little + and drag down[\/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\/Discrete-Random-Variables-\u2013-Excel-Instructions-Data-Sets.xlsx\">Discrete Random Variables \u2013 Excel Instructions Data Sets [XLSX]<\/a>.<\/div>\n<h1>Binomial Distribution<\/h1>\n<ul>\n<li>A more valuable probability density function with many applications is the <strong>binomial distribution<\/strong>. This distribution will compute probabilities for any binomial process.<\/li>\n<\/ul>\n<h2>Binomial Distribution in Excel<\/h2>\n<p>A fair coin is flipped 15 times. Each flip is independent. What is the probability of getting more than ten heads?<\/p>\n<p>Let X = the number of heads in 15 flips of the fair coin. X takes on the values<\/p>\n<ol>\n<li>Enter the <span style=\"color: #eb0000;\">value of n and p<\/span>. Create <span style=\"color: #eb0000;\">a table for the probability and cumulativ<\/span>e of\u00a00, 1, 2, 3, &#8230;, 15.<\/li>\n<li>Enter <span style=\"color: #eb0000;\">=BINOM.DIST(A5,$B$1,$B$2,FALSE)<\/span> in cell <span style=\"color: #eb0000;\">B5<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">B5<\/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 drag <span style=\"color: #eb0000;\">down<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_76\" aria-describedby=\"caption-attachment-76\" style=\"width: 334px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-73 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/BI1.jpg\" alt=\"\" width=\"334\" height=\"377\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/BI1.jpg 334w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/BI1-266x300.jpg 266w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/BI1-65x73.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/BI1-225x254.jpg 225w\" sizes=\"auto, (max-width: 334px) 100vw, 334px\" \/><figcaption id=\"caption-attachment-76\" class=\"wp-caption-text\">Step 1 &amp; 2: Enter the value of n and p. Create a table for the probability and cumulative of\u00a00, 1, 2, 3, &#8230;, 15. Enter =BINOM.DIST(A5,$B$1,$B$2,FALSE) in cell B5, click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_76\" aria-describedby=\"caption-attachment-76\" style=\"width: 328px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-74 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi2.jpg\" alt=\"\" width=\"328\" height=\"376\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi2.jpg 328w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi2-262x300.jpg 262w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi2-65x75.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi2-225x258.jpg 225w\" sizes=\"auto, (max-width: 328px) 100vw, 328px\" \/><figcaption id=\"caption-attachment-76\" class=\"wp-caption-text\">Step 3 &amp; 4: Click B5, move the mouse to the right bottom corner, a little + shows up. Click on the little + and drag down<\/figcaption><\/figure>\n<ol start=\"5\">\n<li>Enter <span style=\"color: #eb0000;\">=BINOM.DIST(A5,$B$1,$B$2,TRUE)<\/span> in cell <span style=\"color: #eb0000;\">C5<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>Click <span style=\"color: #eb0000;\">C5<\/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><\/li>\n<\/ol>\n<figure id=\"attachment_76\" aria-describedby=\"caption-attachment-76\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-75 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi3.jpg\" alt=\"\" width=\"400\" height=\"230\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi3.jpg 400w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi3-300x173.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi3-65x37.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi3-225x129.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi3-350x201.jpg 350w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-76\" class=\"wp-caption-text\">Step 5: Enter =BINOM.DIST(A5,$B$1,$B$2,TRUE) in cell C5, click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_76\" aria-describedby=\"caption-attachment-76\" style=\"width: 318px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-76 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi4.jpg\" alt=\"\" width=\"318\" height=\"364\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi4.jpg 318w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi4-262x300.jpg 262w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi4-65x74.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/bi4-225x258.jpg 225w\" sizes=\"auto, (max-width: 318px) 100vw, 318px\" \/><figcaption id=\"caption-attachment-76\" class=\"wp-caption-text\">Step 6 &amp; 7: Click C5, move the mouse to the right bottom corner, a little + shows up. Click on the little + and drag down<\/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":3,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-77","chapter","type-chapter","status-publish","hentry"],"part":71,"_links":{"self":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/77","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":5,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/77\/revisions"}],"predecessor-version":[{"id":345,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/77\/revisions\/345"}],"part":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/parts\/71"}],"metadata":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/77\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/media?parent=77"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapter-type?post=77"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/contributor?post=77"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/license?post=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}