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
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.
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
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.