The standard deviation of our data is 6.09918. Again, in this formula, B2 represents the data in the B2 cell, and B11 represents the data in the B11 cell. Like mean, you can calculate the standard deviation in any cell, I have calculated it in B14 cell. For this, you have to enter the following formula: =STDEV.P(B2:B11) Here, cell B2 contains the first number and cell B11 contains the last number for the calculation of average.ģ] Now, let’s calculate the standard deviation of the data. Do note that you have to enter the correct cell address in the average formula. You can calculate the average in any cell, I have calculated it in B13 cell. For this, enter the following formula and press the “ Enter” button: =Average(B2:B10) Let’s calculate the average of the data first. After selecting this option, a popup window will appear on the screen with two options, “ Expand the Selection” and “ Continue with the Current Selection.” You have to select the first option as it will arrange the students’ marks in ascending order along with their names.Ģ] To create a bell curve in excel, we need three values, average, standard deviation, and normal distribution.
For this, select the entire column of marks, click on the “ Sort Filter” button on the toolbar and select the “ Sort Smallest to Largest” option. The marks are out of 100.ġ] First, you have to arrange the entire data in ascending order. To teach you the process of making a bell curve in Excel, I have taken sample data of 10 students’ marks in a particular subject.
#EXCEL AVERAGE AND STANDARD DEVIATION IN GRAPH HOW TO#
In this article, we will see how to create a bell curve in Excel. You can use this chart to analyze the performance of a particular person in different phases or a team in a particular phase. Similarly, the graph can also be used in schools to track the performance of students. Many companies use the bell chart to track the performance of their employees. A bell curve or normal distribution chart is a performance analyzer graph.
0 kommentar(er)
