Hello @mahmoudkhan9058, Thanks for your appreciation. Glad to hear that you found it well explained Keep learning Excel with ExcelDemy! Regards ExcelDemy
Dear @shinztest3524, Thank you for reaching out, and we appreciate your feedback. The calculation of average and standard deviation uses the student scores from the dataset. Based on these, the normal values have been obtained. So the “values” are dependent on the student scores. Make sure to stay connected with Exceldemy! 🎉❤. Have a good day. Regards, Exceldemy
Hello @VikasVk-i9n, The choice of 65 instead of 62 for the bell curve's x-values likely relates to its representation in the context of the curve. Often, specific values correspond to key statistical thresholds or points of interest that illustrate data distribution more effectively. Regards ExcelDemy
Hello @VikasVk-i9n, The reason why applying NORM.DIST directly to the score values (in column C) doesn't create a bell curve is likely due to how the normal distribution is plotted. For a bell curve, you typically need to generate a range of x-values (e.g., a sequence of scores) and then apply the NORM.DIST function to these x-values, rather than using it directly to the raw scores. The bell curve represents the probability distribution, not the actual scores themselves. Regards ExcelDemy
Dear, Thanks for your questions! First, calculate the average and standard deviation to check if your 6 data points are normally distributed. For this, you can use the AVERAGE and STDEV.P functions. Later, you can calculate the normal distribution values using the formula: =NORM.DIST(Data_Point, Mean, Standard_Deviation, FALSE) Lastly, you can apply the empirical rule (68-95-99.7 rule). If your data points follow the 68-95-99.7 rule, you can say that your data are likely normally distributed.
Very nice video. Informative step by step.
Very well explained
Hello @mahmoudkhan9058,
Thanks for your appreciation. Glad to hear that you found it well explained Keep learning Excel with ExcelDemy!
Regards
ExcelDemy
Values are not dependable on score?
Dear @shinztest3524,
Thank you for reaching out, and we appreciate your feedback. The calculation of average and standard deviation uses the student scores from the dataset. Based on these, the normal values have been obtained. So the “values” are dependent on the student scores.
Make sure to stay connected with Exceldemy! 🎉❤. Have a good day.
Regards,
Exceldemy
What does values signifying why not H7 corresponding to 62(score) why 65 only???
Hello @VikasVk-i9n,
The choice of 65 instead of 62 for the bell curve's x-values likely relates to its representation in the context of the curve.
Often, specific values correspond to key statistical thresholds or points of interest that illustrate data distribution more effectively.
Regards
ExcelDemy
@@exceldemy2006 If I directly apply Norm.dist on score (column : C) and then plot score vs Normal values then it’s not bell curve any reason?
Hello @VikasVk-i9n,
The reason why applying NORM.DIST directly to the score values (in column C) doesn't create a bell curve is likely due to how the normal distribution is plotted.
For a bell curve, you typically need to generate a range of x-values (e.g., a sequence of scores) and then apply the NORM.DIST function to these x-values, rather than using it directly to the raw scores. The bell curve represents the probability distribution, not the actual scores themselves.
Regards
ExcelDemy
@@exceldemy2006 Thanks alot for clarification! Understood!
Hello @VikasVk-i9n,
You are most welcome. Thanks for your appreciation. Keep learning Excel with ExcelDemy!
Regards
ExcelDemy
Say i have 6 data and need to check whether these data is normally distribution or not. How can i check?
Dear, Thanks for your questions! First, calculate the average and standard deviation to check if your 6 data points are normally distributed. For this, you can use the AVERAGE and STDEV.P functions. Later, you can calculate the normal distribution values using the formula: =NORM.DIST(Data_Point, Mean, Standard_Deviation, FALSE)
Lastly, you can apply the empirical rule (68-95-99.7 rule). If your data points follow the 68-95-99.7 rule, you can say that your data are likely normally distributed.
Helpful, but i still had to go on and learn to display the standard Dev outside of this video.