![]() ![]() The Average (the Mean), Standard Deviation, and Normal Distribution will all remain the same.īut the Bell curve graph of the same example will look different because Marks were not sorted in Ascending order. ![]() Let’s take a similar example, but data will not be sorted in ascending order this time. So arranging the data in ascending order is very important to get a smooth bell curve in Excel. Then we will not be able to get a smooth bell curve as above. So in the above example, Marks were sorted in ascending order, but what if the data is not arranged in ascending order. When Data is not sorted in Ascending Order This Bell curve helps you identify the top performer in your team and who is the lowest performer and helps you decide the employee ratings.Click on the Axis button to see two options for Horizontal Axis and Vertical Axis. After clicking on the + sign, you will see an option for Axis as below.Click on the graph to see the “+” sign on the right corner of the graph area.If you do not want to see the Vertical axis of Normal Distribution, you just need to follow the below steps. ![]() The Horizontal axis is the Marks scored, and the Vertical axis is the Normal Distribution. Only one student has scored below 83, so he is a poor performer in the class. Only 2 students have scored more than 88, so they are the best performers in the class. So I can say that they are the average performers in the class. In our example, 6 students are between 83 & 88. When you look at the Bell Curve, you can see that the maximum number of students will be 83.42 & 88.58(86-2.58 =83.42 & 86+2.58 = 88.58).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |