Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to draw a bell Curve on Excel or SSRS

Posted on 2013-01-15
4
Medium Priority
?
1,910 Views
Last Modified: 2013-02-14
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
Comment
Question by:RamzyNEbeid
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
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

by:LazyFolk
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

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

please
0
 
LVL 24

Assisted Solution

by:Steve
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question