Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# How to draw a bell Curve on Excel or SSRS

Posted on 2013-01-15
Medium Priority
1,868 Views
Dear all
I want to draw a Bell Curve on Employees End Year Rating.
Rating range is from 1 to 4 and it contains decimal places.
We have around 500 employees
I want to draw a bell curve how can I do this?
My tools are Excel 2010 and SSRS R2
Thanks,
0
Question by:RamzyNEbeid
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 24

Accepted Solution

Steve earned 2000 total points
ID: 38777360
Attached is an example using the NormDist function to plot a Normal Distribution (Bell Curve).

I have also added the Frequency function to plot the histogram
NormDist.xlsx
0

LVL 5

Expert Comment

ID: 38777371
Not as easy as it seems...

have a look at this site :

http://tushar-mehta.com/excel/charts/normal_distribution/index.htm
0

Author Comment

ID: 38777935
can you explain to me what is the:
- "x axis step"
- "Frequency"
- E8 till E31

0

LVL 24

Assisted Solution

Steve earned 2000 total points
ID: 38778058
"x axis step" is just an arbitrary figure I picked out and then added up to form the x axis used to generate the curve. So I used x values going up in increments of 0.25. If you change this to .1 then the axis would increase by 0.1 ( this is just about making the graph "look right").

Frequency is the function applied to form the histogram data (an array formula: so entered using [ctrl+[shift]+[enter]) this takes the values in the table and fills the buckets to form the histogram for plotting along side the normal distribution. The histogram/Distribution buckets are in the range E8 to E31.

E8 to E31 are just the "buckets": the stages applied as per the x-axis step to give the varied "look" of the graph and to generate the points of the graph. For this it is about getting the range right so that the curve looks right on the graph, you can just type them in, but I find adding a single value to "step" makes it easier to change.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month8 days, 22 hours left to enroll