Bell Curve

In this Article we will learn about the creation of Bell curve in Excel.

Let us create a blank excel file with the following data :

Data Distribution Average Standard Deviation

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24 And so on

 

Now we will add the formulas for the Distribution, average and standard deviation.

Distribution: =NORM.DIST(A2,$C$2,$D$2,FALSE)

Average:= =AVERAGE(A2:A52)

Standard deviation : =STDEV(A2:A52)

 

We will get the following results:

Data Distribution Average Standard Deviation

6 0.006525439 31 14.86606875

7 0.00729047

8 0.008108418

9 0.008977422

10 0.009894686

11 0.010856435

12 0.011857888

13 0.012893247

14 0.013955717

15 0.015037542

16 0.016130076

17 0.017223875

18 0.018308812

19 0.019374224

20 0.020409077

21 0.021402143

22 0.022342205

23 0.023218259

24 0.024019732

25 0.024736687

26 0.02536003

27 0.025881704

28 0.026294858

29 0.026594

30 0.026775116

31 0.026835762

32 0.026775116

33 0.026594

34 0.026294858

35 0.025881704

36 0.02536003

37 0.024736687

38 0.024019732

39 0.023218259

40 0.022342205

41 0.021402143

42 0.020409077

43 0.019374224

44 0.018308812

45 0.017223875

46 0.016130076

47 0.015037542

48 0.013955717

49 0.012893247

50 0.011857888

51 0.010856435

52 0.009894686

53 0.008977422

54 0.008108418

55 0.00729047

56 0.006525439

 

Now let's plot the scatter with smooth lines and markers chart for the same:

Scatter With Smooth Lines

 

We got the perfect example of a bell curve as the result:

Bell Curve

 

Please find attached the Excel file for reference.