Excel 2013 Statistical Analysis #40: Normal (Bell) Probability Distribution Area Chart, X & Z Values Download files: people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:10) Dynamic Area Chart for displaying cumulative probability for a Normal (Bell0 Probability Distribution 2. (01:25) Formulas for Cumulative Probability Chart including x value, z value, NORM.DIST function for density function, IF function for cumulative probability and various text formulas to display cumulative probability in Legend 3. (07:55) Multiple steps to plot both z values, x values and cumulative probability on an area chart
Dear Mr. Excel Expert, Your Excel Statistical Analysis videos are excellent. Thank you very much for sharing your knowledge. I wonder if is it possible to draw 2 graphs of 2 different populations and means on the same chart using excel?
Awesome stuff again. But you know, I've been fiddling around with the charts and I can't seem to reckon why the vertical lines from a point on the x-axis to its corresponding point on the P(x)-axis are not perpendicular: they seem jigged by one point. Any ideas?
Mine are jiggly too. I do not know how to avoid that. However, the main point is that we have a visual for our calculations. The visual inaccuracy does not affect the accuracy of the function / formula calculating the probability. If you figure out a fix, let me know!
You nailed it man !... Completed excel in less than half a month only because of you
Hats off to you .. I'd love from content like this from you
Excel 2013 Statistical Analysis #40: Normal (Bell) Probability Distribution Area Chart, X & Z Values
Download files: people.highline.edu/mgirvin/excelisfun.htm
Topics in this video:
1. (00:10) Dynamic Area Chart for displaying cumulative probability for a Normal (Bell0 Probability Distribution
2. (01:25) Formulas for Cumulative Probability Chart including x value, z value, NORM.DIST function for density function, IF function for cumulative probability and various text formulas to display cumulative probability in Legend
3. (07:55) Multiple steps to plot both z values, x values and cumulative probability on an area chart
Sir, I need your help to make a data base. Please help me.
Outstanding. Best regards; from Limón, Costa Rica
Thanks!
Awesome chart making process
Dear Mr. Excel Expert,
Your Excel Statistical Analysis videos are excellent. Thank you very much for sharing your knowledge. I wonder if is it possible to draw 2 graphs of 2 different populations and means on the same chart using excel?
Thanks
You are welcome! This is a fun one with chart and Area : )
Awesome stuff again. But you know, I've been fiddling around with the charts and I can't seem to reckon why the vertical lines from a point on the x-axis to its corresponding point on the P(x)-axis are not perpendicular: they seem jigged by one point. Any ideas?
Mine are jiggly too. I do not know how to avoid that. However, the main point is that we have a visual for our calculations. The visual inaccuracy does not affect the accuracy of the function / formula calculating the probability. If you figure out a fix, let me know!
Why did you 34 + 1? Why did you add up + 1 instead of for example 5?
Please, can some one help me about the plotting of the curve for two sample - two tail z-test . thank you