How to Create a Bell Curve in Excel
HTML-код
- Опубликовано: 23 июл 2024
- In this video, I'll guide you through two different methods to create a bell curve in Excel. You'll learn to create a bell curve with a dataset and create a bell curve without a dataset. The bell curve is a powerful statistic to analyze and understand data. With practical examples and step-by-step instructions, you can make a bell curve in your own Excel spreadsheets effortlessly.
👨🏫 Instructor: Zehad Rian Jim
🎥 Editor: Md. Riajul Islam
✨ ⯆ Resources:
Alt+F1 - To insert chart
▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
0:00 - Intro
0:36 - What Is a Bell Curve
1:20 - Creating a Bell Curve in Excel with a Dataset
8:59 - Creating a Bell Curve without Dataset in Excel
📚 ⯆ DOWNLOAD the workbook here:
www.exceldemy.com/create-a-be...
🌍 ⯆ Checkout the article here:
www.exceldemy.com/create-a-be...
💻 ⯆ Similar Videos:
• How to Create Skewed B...
• How to Create Histogra...
🚩 Stay connected with us on social media for more Excel tips and tricks!
Facebook: / exceldemy
Twitter: / exceldemy
LinkedIn: / exceldemy
🙋♂️ Stuck with an Excel formula or a VBA code? You can post your questions or upload your Excel file to get in touch with the professionals and get the solution you need.
ExcelDemy Forum: exceldemy.com/forum/
👉 If you found this video helpful, don't forget to subscribe to our channel for more Excel tutorials, tips, and tricks! Hit the subscribe button and turn on notifications so you never miss an upload. By subscribing, you'll be supporting our channel and helping us to reach more people who can benefit from our content. Thank you for watching, and we'll see you in the next video!
🔔 ⯆ Subscribe on RUclips:
/ @exceldemy2006
#excel #exceltutorial #exceltips #exceltricks
This video got me through a report due the next day for my masters degree - thank you!
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!
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 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.
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!