- HOW TO GRAPH MEAN AND STANDARD DEVIATION EXCEL SERIES
- HOW TO GRAPH MEAN AND STANDARD DEVIATION EXCEL TV
HOW TO GRAPH MEAN AND STANDARD DEVIATION EXCEL SERIES
This means that our series for the area needs to have 0 as Y values up until X = 30, then when X = 30 we will list 30 twice (one with Y value of 0 and one with Y value equal to the result of the NORM.DIST function), from 31 to 49 Y will be equal to the NORM.DIST function, and when X = 50 we will again list it twice, one with Y value of NORM.DIST and one with Y value of 0, finally for X > 50 we will have Y values of 0. We know that these values lie between 30 and 50 (40 – 10) and (40 + 10). Now it would be nice to add 3 different areas to our chart: one that highlights the range that lies within one standard deviation from the mean, one that highlights the one that lies within two standard deviations from the mean and one that highlights the one that lies within three standard deviations from the mean. Thanks to this, I will choose the minimum and maximum of our X axis to lie between 4 standard deviations from the mean (0 and 80). Plotting the Normal Distribution in Excelīefore plotting the data, we need to remember the 68-95-99 rule which states that roughly 68% of the values lie between one standard deviation from the mean, in our example above, this translates that roughly 68% of the values lie between 30 and 50 (40 – 10 and 40+10), about 95% of the values lie between two standard deviations from the mean, in our example 95% of values lie between 20 and 60 (40-(10*2) and 40+(10*2), and about 99.7% of the values lie between 3 standard deviations from the mean, in our example between 10 and 70 (40-(10*3) and 40+(10*3).
![how to graph mean and standard deviation excel how to graph mean and standard deviation excel](https://i.ytimg.com/vi/sZG3igFtdMg/maxresdefault.jpg)
HOW TO GRAPH MEAN AND STANDARD DEVIATION EXCEL TV
Using our example above, if we wanted to answer the question: How many minutes of TV can I watch maximum per day to be in the bottom 10%, the answer would be NORM.INV(0.1,40,10) = 27.18 minutes, which also means that in order to be in the top 90% I must watch more than 27.18 minutes of TV per day. The NORM.INV function is the inverse of the NORM.DIST function. If 40 represented the average minutes a person watches TV per day, with a standard deviation of 10, and your friend came to you saying she watches only 20 minutes of TV per day, now you would know that the probability of her watching exactly 20 minutes of TV per day is NORM.DIST(20,40,10,FALSE) = 0.54%, whereas the probability of her watching maximum 20 minutes of TV per day is NORM.DIST(20,40,10,TRUE) = 2.28%, which means that the probability of her watching TV more than 20 minutes a day is 1-0.028 = 97.72% Suppose that your observations have a mean of 40 and standard deviation of 10, by doing NORM.DIST(X,40,10,FALSE) the NORM.DIST function will return the probability of the value X occurring, whereas NORM.DIST(X,40,10,TRUE) will return the cumulative probability of all the values less than or equal to X. The NORM.DIST function can return two different probabilities depending on the last argument whether you set it to TRUE or FALSE. The NORM.DIST function, as its name implies, returns the normal distribution (continuous probability function) given the mean and the standard deviation of your observations. Livio / Ap/ Excel, Excel Charts, Excel Formulas / 0 comments The NORM.DIST Function