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