Afterward, select the Marks column cells and Normal Distribution Points column cells.

Consequently, you can see the dataset is now sorted by the marks of the students from smallest to largest value.

Select the Continue with the current selection option and click on the OK button. As a result, the Sort Warning window will appear.So, select the cells of this column > go to the Home tab > Editing group > Sort & Filter tool > Sort Smallest to Largest option. In order to do this, at the very beginning, you have to sort the Marks column.Now, you have to plot the normal distribution by the extracted points. Step 3: Plotting Normal Distribution Chart in Excel

Thus, you will have all the points to plot the normal distribution of this dataset. At this time, the fill handle will appear. Now, place your cursor in the bottom right position of your cell.To do this, press the F4 key or put the dollar sign ($) before the row and column heading. Here the mean argument and standard_dev argument should be absolute. Afterward, click on the merged E5 cell and insert the following formula.Subsequently, merge the E5:E14 cells and merge the F5:F14 cells. To do this, first and foremost select new columns named Mean, Standard Deviation, and Normal Distribution Points.Step 1: Calculating Mean & Standard Deviation in ExcelĪt first, you need to calculate the mean and standard deviation to plot a normal distribution. If you face any problems regarding Excel versions, let us know by dropping a comment in the comment section. You can use any other Excel version and still achieve your target by following these steps. Here, we have used Microsoft Office 365 to accomplish this. Follow the step-by-step guidelines below to accomplish this. Now, you need to plot the normal distribution of the marks of the students with mean and standard deviation. Say, you have a dataset of 10 students with their IDs, names, and marks for the final exam. Standard_dev: This is the standard deviation of your dataset.Ĭumulative: This is mainly a TRUE or FALSE value, where the TRUE value represents the cumulative distribution function and the FALSE value represents the probability mass function. Mean: This is the average value of your dataset. X: This is the data for which you are calculating the normal distribution. The NORM.DIST function is mainly used to find the normal distribution points for each data of a given dataset. You can calculate this by the STDEV function. Standard Deviation:It is mainly the measurement of the deviation of your data from the mean value of your data. In Excel, you can find this by using the AVERAGE function. Mean:Mean is the average value of all of your data. Afterward, you will need to find the normal distribution points and thus plot the graph.

To plot normal distribution, you need to find the mean and standard deviation of the data at the very beginning. This graph generally looks like a bell curve. The normal distribution is mainly the probability distribution of data. Regarding this, you have landed in the right place for sure! In this article, I will show you all the steps to plot normal distribution in Excel with mean and standard deviation. It might happen frequently that you have a large dataset and you need to find the data distribution. A normal distribution graph is a great tool to measure the probability distribution of a given dataset.

Excel plot mean and standard deviation