Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal
Solved
How to draw a bell Curve on Excel or SSRS
Posted on 2013-01-15
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,
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,
[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
- Learn & ask questions
2
4 Comments
Active 7 days ago
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
I have also added the Frequency function to plot the histogram
NormDist.xlsx
Not as easy as it seems...
have a look at this site :
http://tushar-mehta.com/excel/charts/normal_distribution/index.htm
have a look at this site :
http://tushar-mehta.com/excel/charts/normal_distribution/index.htm
Active 7 days ago
"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.
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.
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
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.