![]() ![]() You can also have these in cells and use the cell references in the formula. Note that here I have hardcoded the value of mean and standard deviation.In the cell adjacent to 35, enter the formula: =NORM.DIST(A1,65,10,FALSE).You can do this quickly by using the autofill option, or use the fill handle and drag it down to fill the cells. In the cell below it enter 36 and create a series from 35 to 95 (where 95 is Mean + 3* Standard Deviation).This value can be calculated using Mean – 3* Standard Deviation (65-3*10). Here are the steps to create a bell curve for this dataset: (You can calculate the mean using the AVERAGE function in Excel and Standard Deviation using the STDEV.P function). The mean score of the class is 65 and the standard deviation is 10. Let’s take an example of a class of students that have been scored in an exam. Now let’s see how to create a bell curve in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |