Dear, We are glad you found it simple. Your appreciation means a lot to us and we're grateful for viewers like you who appreciate our content. Stay tuned for more exciting videos!
Dear @angelmarie8856, Thank you for your question. We appreciate your feedback. Regarding your question on the values of the first deviations left and right. Follow the steps below: Here the first deviation right refers to the value that is 1 standard deviation greater than the mean value. 58.125 + 9.03379 = 67.15 (2 d.p) Similarly, the first deviation left gives a value that is 1 standard deviation less than the mean value. 58.125 - 9.03379 = 49.09 (2 d.p) Make sure to stay connected with Exceldemy!🎉❤ Have a good day. Regards, Exceldemy
Dear, Thanks for your questions! The GAP refers to the distance between each point on the Bell Curve. In other words, the gap is the difference between these points divided by the number of intervals you want. Without a proper gap, the points might be too close or too far apart, distorting the curve.
Dear, Thanks for your question! When working with normal distribution, you must be familiar with the 68-95-99.7 rule, also known as the Empirical rule. Based on this rule, 68% of the data falls within one standard deviation, 95% within two, and 99.7% within three standard deviations from the mean. So, the 68.2% is not directly calculated here. It is a known property of the normal distribution.
Dear @milannagar4485, Thank you for your feedback. Regarding your question on the use of -3 and +3 in low and high values. Based on the Empirical rule for normally distributed data: 68% of data lies within one standard deviation from the mean. 95% of data lies within two standard deviations from the mean 99.7% of data lies within three standard deviations from the mean According to this rule, we can say almost all of the data lies within 3 standard deviations from the mean (3-sigma limit). So we can use these formulas to calculate the 3-sigma limit 99.7% Low: Mean - 3 x Standard deviation 99.7% High: Mean + 3 x Standard deviation Likewise, if you wanted to calculate the 2-sigma limit (2 standard deviations from the mean) then the formula would be as follows: 95% Low: Mean - 2 x Standard deviation 95% High: Mean + 2 x Standard deviation Hopefully, this answers your question. Make sure to stay connected with ExcelDemy!🎉❤ Have a good day. Regards, ExcelDemy
@@exceldemy2006 Dear Rafiul, I have a problem that the low 99.7% is a negative number because I have a high St Dev or in another data set, the mean is a low number. After this, all the following calculations become distorted.
@@okubista Dear, Thanks for sharing your problem! When the data has a high standard deviation or a very low mean, it might not perfectly follow a normal distribution. Unfortunately, the built-in Excel features and function for creating a bell curve need a normal distribution. If your data is not normally distributed, you can try transforming it before making a bell curve.
Dear @matteoalexander239, Thank you for your question. Regarding your question on the calculation of the first and second standard deviations. Follow the steps below: Here the first deviation right refers to the value that is 1 standard deviation greater than the mean value. 58.125 + 9.03379 = 67.15 (2 d.p) The first deviation left gives a value that is 1 standard deviation less than the mean value. 58.125 - 9.03379 = 49.09 (2 d.p) Similarly, the second deviation right. 58.125 + 2*9.03379 = 76.19 (2 d.p) The second deviation left. 58.125 - 2*9.03379 = 40.05 (2 d.p) Make sure to stay connected with Exceldemy!🎉❤ Have a good day. Regards, Exceldemy
Hello @sherlygaligao8287, It is one of the standard features of a normal distribution, often visualized as a Bell Curve. The percentages of a perfectly normal distribution are: 1. 68% of the data falls within one standard deviation of the mean. 2. 95% is within two standard deviations. 3. 99.7% lies within three standard deviations. Regards ExcelDemy
@@condesmarlounn.6538 Dear, Thanks for raising a great question! The 68%, 95%, and 99.7% represent different levels of certainty within the bell curve. Here, we did not mention how to choose the percentage. However, if you need a precise range and are only interested in the most common data points, use 68%. Use 95% for a moderately wide range to capture a larger portion of the data. If you want to capture almost all the data points and are less concerned about precision, use 99.7%.
Explained in a very simple manner .
Dear,
We are glad you found it simple. Your appreciation means a lot to us and we're grateful for viewers like you who appreciate our content. Stay tuned for more exciting videos!
This video got me through a report due the next day for my masters degree - thank you!
What happens if my 99.7 low value is negative. Is that okay? It's been too long since I've taken statistics
Dear, it's okay if the 99.7% low value is negative. A standard statistical distribution can sometimes expand into negative numbers.
Great video! How did you get the first deviation right and first deviation left?
Dear @angelmarie8856,
Thank you for your question. We appreciate your feedback. Regarding your question on the values of the first deviations left and right. Follow the steps below:
Here the first deviation right refers to the value that is 1 standard deviation greater than the mean value.
58.125 + 9.03379 = 67.15 (2 d.p)
Similarly, the first deviation left gives a value that is 1 standard deviation less than the mean value.
58.125 - 9.03379 = 49.09 (2 d.p)
Make sure to stay connected with Exceldemy!🎉❤ Have a good day.
Regards,
Exceldemy
What is gap used for/what does it mean?
Dear, Thanks for your questions! The GAP refers to the distance between each point on the Bell Curve. In other words, the gap is the difference between these points divided by the number of intervals you want. Without a proper gap, the points might be too close or too far apart, distorting the curve.
How did you calculate 68.2%?
Dear, Thanks for your question!
When working with normal distribution, you must be familiar with the 68-95-99.7 rule, also known as the Empirical rule. Based on this rule, 68% of the data falls within one standard deviation, 95% within two, and 99.7% within three standard deviations from the mean.
So, the 68.2% is not directly calculated here. It is a known property of the normal distribution.
Why do we -3 or +3 in Low and High?
Dear @milannagar4485,
Thank you for your feedback. Regarding your question on the use of -3 and +3 in low and high values. Based on the Empirical rule for normally distributed data:
68% of data lies within one standard deviation from the mean.
95% of data lies within two standard deviations from the mean
99.7% of data lies within three standard deviations from the mean
According to this rule, we can say almost all of the data lies within 3 standard deviations from the mean (3-sigma limit). So we can use these formulas to calculate the 3-sigma limit
99.7% Low: Mean - 3 x Standard deviation
99.7% High: Mean + 3 x Standard deviation
Likewise, if you wanted to calculate the 2-sigma limit (2 standard deviations from the mean) then the formula would be as follows:
95% Low: Mean - 2 x Standard deviation
95% High: Mean + 2 x Standard deviation
Hopefully, this answers your question. Make sure to stay connected with ExcelDemy!🎉❤ Have a good day.
Regards,
ExcelDemy
@@exceldemy2006 Thank you, I was struggling with my assessment but your explanation helped me through it
You are most welcome. Please stay connected with us.
@@exceldemy2006 Dear Rafiul, I have a problem that the low 99.7% is a negative number because I have a high St Dev or in another data set, the mean is a low number. After this, all the following calculations become distorted.
@@okubista Dear, Thanks for sharing your problem! When the data has a high standard deviation or a very low mean, it might not perfectly follow a normal distribution. Unfortunately, the built-in Excel features and function for creating a bell curve need a normal distribution. If your data is not normally distributed, you can try transforming it before making a bell curve.
Wheres the calculation from 1st and 2nd deviation?
Dear @matteoalexander239,
Thank you for your question. Regarding your question on the calculation of the first and second standard deviations. Follow the steps below:
Here the first deviation right refers to the value that is 1 standard deviation greater than the mean value.
58.125 + 9.03379 = 67.15 (2 d.p)
The first deviation left gives a value that is 1 standard deviation less than the mean value.
58.125 - 9.03379 = 49.09 (2 d.p)
Similarly, the second deviation right.
58.125 + 2*9.03379 = 76.19 (2 d.p)
The second deviation left.
58.125 - 2*9.03379 = 40.05 (2 d.p)
Make sure to stay connected with Exceldemy!🎉❤ Have a good day.
Regards,
Exceldemy
Where did you get 99.7%😢😢
Hello @sherlygaligao8287,
It is one of the standard features of a normal distribution, often visualized as a Bell Curve.
The percentages of a perfectly normal distribution are:
1. 68% of the data falls within one standard deviation of the mean.
2. 95% is within two standard deviations.
3. 99.7% lies within three standard deviations.
Regards
ExcelDemy
@@exceldemy2006 but how can we determine if we gonna use 68%,95%,99.7%?
@@condesmarlounn.6538 Dear, Thanks for raising a great question! The 68%, 95%, and 99.7% represent different levels of certainty within the bell curve. Here, we did not mention how to choose the percentage.
However, if you need a precise range and are only interested in the most common data points, use 68%. Use 95% for a moderately wide range to capture a larger portion of the data. If you want to capture almost all the data points and are less concerned about precision, use 99.7%.
@@exceldemy2006 Thank you for clarification!!!!
@@condesmarlounn.6538 You are very welcome!