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
Hello @arskhan-qh5ws, Thank you for the feedback! We will try to adjust the formatting to make the data and formulas more visible. To see the data contents and formulas and etc please check out the article: www.exceldemy.com/create-a-bell-curve-in-excel/ 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%.
