2] To create a bell curve in excel, we need three values, average, standard deviation, and normal distribution. Let’s calculate the average of the data first.

How to calculate Standard Deviation in Excel The Standard Deviation is a term used in statistics. The term describes how much the numbers if a set of data vary from the mean.

By using Excel or Google Sheets to create impactful graphs, you'll be able to captivate your audience, facilitate meaningful discussions, and drive home the key points of your presentation.

Figure A You need the People Graph add-in for Excel. To populate an Excel people chart, you need some data. Figure B shows a simple data set along with the dummy chart.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.