{"id":88,"date":"2022-10-07T12:25:15","date_gmt":"2022-10-07T16:25:15","guid":{"rendered":"https:\/\/opentextbc.ca\/busstatsancillary\/chapter\/the-normal-distribution-excel-tools-instruction\/"},"modified":"2023-01-20T14:22:05","modified_gmt":"2023-01-20T19:22:05","slug":"the-normal-distribution-excel-tools-instruction","status":"publish","type":"chapter","link":"https:\/\/opentextbc.ca\/busstatsancillary\/chapter\/the-normal-distribution-excel-tools-instruction\/","title":{"raw":"The Normal Distribution - Excel Tools Instruction","rendered":"The Normal Distribution &#8211; Excel Tools Instruction"},"content":{"raw":"<div class=\"textbox\">Download <a href=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2022\/10\/The-Normal-Distribution-\u2013-Excel-Instructions-Data-Sets.xlsx\">The Normal Distribution \u2013 Excel Instructions Data Sets [XLSX]<\/a>.<\/div>\r\n<h1>Normal Distribution<\/h1>\r\n<ul>\r\n \t<li>The <strong>normal distribution<\/strong>, which is continuous, is the most important of all the probability distributions. Its graph is bellshaped. This bell-shaped curve is used in almost all disciplines. Since it is a continuous distribution, the total area under the curve is one. The parameters of the normal are the mean \u00b5 and the standard deviation \u03c3. A special normal distribution, called the standard normal distribution is the distribution of z-scores. Its mean is zero, and its standard deviation is one.<\/li>\r\n<\/ul>\r\n<h2>Normal Distribution in Excel<\/h2>\r\nThe final exam scores in a statistics class were normally distributed with a mean of 63 and a standard deviation of five.\r\n<ol type=\"a\">\r\n \t<li>Find the probability that a randomly selected student scored more than 65 on the exam.<\/li>\r\n \t<li>Find the probability that a randomly selected student scored less than 85.<\/li>\r\n<\/ol>\r\n<ol>\r\n \t<li>Find out what is <span style=\"color: #eb0000;\">x, mean, standard deviation<\/span> for question a and b.<\/li>\r\n \t<li>For question a, to compute cumulative normal probabilities <span style=\"color: #eb0000;\">P(X&gt;65)<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">P(X&gt;65)<\/span> in cell <span style=\"color: #eb0000;\">A2<\/span>, enter<span style=\"color: #eb0000;\">=1-NORMDIST(65,63,5,TRUE)<\/span> in cell <span style=\"color: #eb0000;\">B2<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n \t<li>For question b, to compute cumulative normal probabilities <span style=\"color: #eb0000;\">P(X&lt;85)<\/span><\/li>\r\n \t<li>Enter <span style=\"color: #eb0000;\">P(X&lt;85)<\/span> in cell <span style=\"color: #eb0000;\">A4<\/span>, enter<span style=\"color: #eb0000;\">=NORMDIST(85,63,5,TRUE)<\/span> in cell <span style=\"color: #eb0000;\">B4<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\r\n<\/ol>\r\n[caption id=\"attachment_86\" align=\"aligncenter\" width=\"376\"]<img class=\"wp-image-83 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/N1.jpg\" alt=\"\" width=\"376\" height=\"84\" \/> Step 1 &amp; 2: Find out what is x, mean, standard deviation for question a. Compute cumulative normal probabilities P(X&gt;65)[\/caption]\r\n\r\n[caption id=\"attachment_86\" align=\"aligncenter\" width=\"376\"]<img class=\"wp-image-84 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N2.jpg\" alt=\"\" width=\"376\" height=\"81\" \/> Step 3: Enter P(X&gt;65) in cell A2, enter=1-NORMDIST(65,63,5,TRUE) in cell B2, click Enter[\/caption]\r\n\r\n[caption id=\"attachment_86\" align=\"aligncenter\" width=\"352\"]<img class=\"wp-image-85 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N3.jpg\" alt=\"\" width=\"352\" height=\"124\" \/> Step 4: Find out what is x, mean, standard deviation for question b. Compute cumulative normal probabilities P(X&lt;85)[\/caption]\r\n\r\n[caption id=\"attachment_86\" align=\"aligncenter\" width=\"354\"]<img class=\"wp-image-86 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N4.jpg\" alt=\"\" width=\"354\" height=\"128\" \/> Step 5: Enter P(X&lt;85) in cell A4, enter=NORMDIST(85,63,5,TRUE) in cell B4, click Enter[\/caption]\r\n\r\nFor a reference to calculate a different value with typing a different formula\r\n<img class=\"alignnone size-full wp-image-87\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.24.31-AM.png\" alt=\"\" width=\"1402\" height=\"887\" \/>\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\/The-Normal-Distribution-\u2013-Excel-Instructions-Data-Sets.xlsx\">The Normal Distribution \u2013 Excel Instructions Data Sets [XLSX]<\/a>.<\/div>\n<h1>Normal Distribution<\/h1>\n<ul>\n<li>The <strong>normal distribution<\/strong>, which is continuous, is the most important of all the probability distributions. Its graph is bellshaped. This bell-shaped curve is used in almost all disciplines. Since it is a continuous distribution, the total area under the curve is one. The parameters of the normal are the mean \u00b5 and the standard deviation \u03c3. A special normal distribution, called the standard normal distribution is the distribution of z-scores. Its mean is zero, and its standard deviation is one.<\/li>\n<\/ul>\n<h2>Normal Distribution in Excel<\/h2>\n<p>The final exam scores in a statistics class were normally distributed with a mean of 63 and a standard deviation of five.<\/p>\n<ol type=\"a\">\n<li>Find the probability that a randomly selected student scored more than 65 on the exam.<\/li>\n<li>Find the probability that a randomly selected student scored less than 85.<\/li>\n<\/ol>\n<ol>\n<li>Find out what is <span style=\"color: #eb0000;\">x, mean, standard deviation<\/span> for question a and b.<\/li>\n<li>For question a, to compute cumulative normal probabilities <span style=\"color: #eb0000;\">P(X&gt;65)<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">P(X&gt;65)<\/span> in cell <span style=\"color: #eb0000;\">A2<\/span>, enter<span style=\"color: #eb0000;\">=1-NORMDIST(65,63,5,TRUE)<\/span> in cell <span style=\"color: #eb0000;\">B2<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<li>For question b, to compute cumulative normal probabilities <span style=\"color: #eb0000;\">P(X&lt;85)<\/span><\/li>\n<li>Enter <span style=\"color: #eb0000;\">P(X&lt;85)<\/span> in cell <span style=\"color: #eb0000;\">A4<\/span>, enter<span style=\"color: #eb0000;\">=NORMDIST(85,63,5,TRUE)<\/span> in cell <span style=\"color: #eb0000;\">B4<\/span>, click <span style=\"color: #eb0000;\">Enter<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_86\" aria-describedby=\"caption-attachment-86\" style=\"width: 376px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/N1.jpg\" alt=\"\" width=\"376\" height=\"84\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/N1.jpg 376w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/N1-300x67.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/N1-65x15.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/N1-225x50.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2019\/07\/N1-350x78.jpg 350w\" sizes=\"auto, (max-width: 376px) 100vw, 376px\" \/><figcaption id=\"caption-attachment-86\" class=\"wp-caption-text\">Step 1 &amp; 2: Find out what is x, mean, standard deviation for question a. Compute cumulative normal probabilities P(X&gt;65)<\/figcaption><\/figure>\n<figure id=\"attachment_86\" aria-describedby=\"caption-attachment-86\" style=\"width: 376px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N2.jpg\" alt=\"\" width=\"376\" height=\"81\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N2.jpg 376w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N2-300x65.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N2-65x14.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N2-225x48.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N2-350x75.jpg 350w\" sizes=\"auto, (max-width: 376px) 100vw, 376px\" \/><figcaption id=\"caption-attachment-86\" class=\"wp-caption-text\">Step 3: Enter P(X&gt;65) in cell A2, enter=1-NORMDIST(65,63,5,TRUE) in cell B2, click Enter<\/figcaption><\/figure>\n<figure id=\"attachment_86\" aria-describedby=\"caption-attachment-86\" style=\"width: 352px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N3.jpg\" alt=\"\" width=\"352\" height=\"124\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N3.jpg 352w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N3-300x106.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N3-65x23.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N3-225x79.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N3-350x123.jpg 350w\" sizes=\"auto, (max-width: 352px) 100vw, 352px\" \/><figcaption id=\"caption-attachment-86\" class=\"wp-caption-text\">Step 4: Find out what is x, mean, standard deviation for question b. Compute cumulative normal probabilities P(X&lt;85)<\/figcaption><\/figure>\n<figure id=\"attachment_86\" aria-describedby=\"caption-attachment-86\" style=\"width: 354px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-86 size-full\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N4.jpg\" alt=\"\" width=\"354\" height=\"128\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N4.jpg 354w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N4-300x108.jpg 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N4-65x24.jpg 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N4-225x81.jpg 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/N4-350x127.jpg 350w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><figcaption id=\"caption-attachment-86\" class=\"wp-caption-text\">Step 5: Enter P(X&lt;85) in cell A4, enter=NORMDIST(85,63,5,TRUE) in cell B4, click Enter<\/figcaption><\/figure>\n<p>For a reference to calculate a different value with typing a different formula<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-87\" src=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.24.31-AM.png\" alt=\"\" width=\"1402\" height=\"887\" srcset=\"https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.24.31-AM.png 1402w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.24.31-AM-300x190.png 300w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.24.31-AM-1024x648.png 1024w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.24.31-AM-768x486.png 768w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.24.31-AM-65x41.png 65w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.24.31-AM-225x142.png 225w, https:\/\/opentextbc.ca\/busstatsancillary\/wp-content\/uploads\/sites\/426\/2023\/01\/Screen-Shot-2022-10-07-at-9.24.31-AM-350x221.png 350w\" sizes=\"auto, (max-width: 1402px) 100vw, 1402px\" \/><\/p>\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-88","chapter","type-chapter","status-publish","hentry"],"part":81,"_links":{"self":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/88","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\/88\/revisions"}],"predecessor-version":[{"id":346,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/88\/revisions\/346"}],"part":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/parts\/81"}],"metadata":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapters\/88\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/media?parent=88"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/pressbooks\/v2\/chapter-type?post=88"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/contributor?post=88"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/opentextbc.ca\/busstatsancillary\/wp-json\/wp\/v2\/license?post=88"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}