Help with Bell Curve

[itshere]

Hello -

I want to create a bell curve that shows the frequency of people under each score..

These are the scores I have.

2
1
1
4
5
5
3
1
5
5


based on that i want a bell curve that shows the frequence of scores for each number. (i.e. those who scored 1 will have a higher curve)

[Nisha Dhawan]

Hi itshere,

Please find the attached file.

To create the Bell curve you just follow few steps:-

• Select the range on which you want to create the bell curve.
• Go to Insert tab and Click on the More Chart option.
• You will get the window of Insert chart.
• Select X Y Scatter, you will get the options, where you need to click on "Scatter with Smooth Lines".
• Chart will get insert, right click on the chart and click on Format series.
• In the format Series option you have to select Vertical(Value Axis).
• Under the Axis option, tick on the box of "Value in Reverse order", it will help to show 1 as higher curve.