![]() ![]() The final example of this section explains the origin of the proportions given in the Empirical Rule. We can see from the first line of the table that the area to the left of \(-5.22\) must be so close to \(0\) that to four decimal places it rounds to \(0.0000\). Similarly, here we can read directly from the table that the area under the density curve and to the left of \(2.15\) is \(0.9842\), but \(-5.22\) is too far to the left on the number line to be in the table.The NORM.S.DIST function can be used to determine the probability that a random variable that is standard normally distributed would be less than 0.5. ![]() ![]() It will calculate the Excel Standard Normal Distribution function for a given value. We can see from the last row of numbers in the table that the area to the left of \(4.16\) must be so close to 1 that to four decimal places it rounds to \(1.0000\). The NORM.S.DIST Function is categorized under Excel Statistical functions. We obtain the value \(0.8708\) for the area of the region under the density curve to left of \(1.13\) without any problem, but when we go to look up the number \(4.16\) in the table, it is not there. \) by looking up the numbers \(1.13\) and \(4.16\) in the table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |