Free Microsoft Excel 2013 Quick Reference

Bell Curve Charts

Hi Guys

I was tasked to do the following: "Show bell curve of Agent performance against target, i.e. no. of agents who met target "

First off, i do not know how to create a bell curve and secondly i'm not sure if the above requirements can be plotted on a bell curve.

The target that i have to work on is 582 and 24 of our agents achieved 582 or higher.

Pleeeeze could someone help me!!

Thanks!


Hey,
I'm trying to create a chart utilising the bell curve style, when I have
entered all the data and fomulae it seems to come back with an incorrect
value/result on the x-axis. ie: the highest value is 503 but it is showing up
as high as 800. I am using a guide I discovered which is located here -
http://support.microsoft.com/kb/q213930/

Does someone know of or could help make a step by step guide on how to make
a functioning bell curve chart in excel 2003.

Any help appreciated
Regards
Luke

Hey,
I'm trying to create a chart utilising the bell curve style, when I have
entered all the data and fomulae it seems to come back with an incorrect
value/result on the x-axis. ie: the highest value is 503 but it is showing up
as high as 800. I am using a guide I discovered which is located here -
http://support.microsoft.com/kb/q213930/

Does someone know of or could help make a step by step guide on how to make
a functioning bell curve chart in excel 2003.

Any help appreciated
Regards
Luke

Range of data and I want to create a bell curve of this - HOW?
Mike

26
20
35
16
84.9
15
17
42
36
22
18
26
23
49
19
16
29
20
40
26
18
20
14
45
13
19
128.5
29
16
12

how do I shade an area on a normal distribution bell curve chart?

Help! I have created a bell curve that shows me payment distribution for our sales force compensation. The bell curve works beautifully, however, I would also like to show in this same chart the budgeted average as well as the actual average. I am currently using the rectangle shape in the drawing toolbar to manually input the bars that represent these two data points. I was wondering if there is any way to have excel automatically chart these along with my bell curve.

I have an example that I can send if that helps.

Thanks!

I need to plot a bell curve in excel based on skewed data. I know how to plot
a bell curve based on data with a normal distribution . I can figure out how
to chart skewed data though. If I use the same procedure the skewed effect is
not taken into account and the graph shops negative figures which is
impossible based on the data.

Please advise

Hello
I need assistance on how to create bell curves in excel for HR Perf Mgmt and Compensation Purposes. I want to able to show the data as is, and if we wanted to move the bell, wantto know how to do that in excel. For example how much do we need to move. In the chart I want to know to how to show 2 bell curves, one created and another over laid on top of it if that is possible. I currenlty use Excell 2003. All assitance greatly apprecitated.

I am trying to compare a graph against a standard bell curve. How can I
input this into the chart?

Hello Everyone,

I am having hard time to create the bell curve. I have sorted the data (please see the attached file) according to the ditribution (only the green marked data) and I believe I will have to use different formulas to create the column graph and the curve.

I would appreciate it a lot if someone could take a look at this an advise, how to do it. I have already spend couple of hours researching how to do this but it seems to be quiet complex. Is there an easy way to create that type of chart?

Thanks,
anstasija

Is it possible to create a bell curve chart using excell?

H everyone,

I'm trying to draw a histogram and a bell curve with some data. I have the categories and frequency of each category, however I still lack a formula that takes into account the mean and standard deviation for the chart.
Please refer to the enclosed attachment.
Can someone please help and solve this problem for me please? Thank you very much.

Best Regards

Bernard

I want to create a bell chart in excel. I have already created the frequency chart and have the bin values. However the bell chart is not working. I have sample data from 1 to 50 where I want to use the original data, and also the issue is my standard deviation, lower limit, upper limit and the mean changes based on values entered.

I have attached the spreadsheet for details

Value is inputed in Cell F9, F10, F11 and sample data is entered in column E13 to E62. The standard deviation, mean value are calculated and stored in N16 and N14 column respectively. Also I want to add a line for upper and lower limit that can change based on the input in F10 and F11.

Can someone help me to create a bell curve and also a normal curve on the same bell curve chart so one can compare the results.

I would sincerely appreciate the help

If you have a contract amount for a project, and a start and end date, how do you show a bell curve revenue projection?

I have created a bell curve and I am trying to widen the curve slightly but I cant seem to do it without the curve moving from side to side, I need it to stay central but widen so is spanning above the smaller bars . Any suggestions?

Hi! My group and I are doing a Business Statistics course, and we're pretty new at Microsoft Excel, so we're hoping we'll be able to get some help here!

Microsoft Excel 2007.

Question: Develop a 95% confidence interval estimate of the mean assets for the population of money market funds (the data is on investment services).

[IMG]file:///C:/Users/Toshiba/AppData/Local/Temp/moz-screenshot.jpg[/IMG]This bell curve is what we have done so far:

We're trying to show these interval estimates

Lower Limit 599.55927 Upper Limit 3390.0585
in the diagram above. How can it be done?

Thanks

Hi all

I've tried so many times but I'm getting lost and confused the more I learn on the net about this one... please could someone help?!!

Very simply, please could someone list step-by-step how I turn any data set of numbers into a Normal Probability output (also known as Guassian) in Excel 2007?

I've played with FISHER, NORMDIST, STANDARDIZE, everything!!! I just want to simply take a set of skewed number and get them as close to Normal (Guassian) as possible.

Also, how can I test this to make sure the output is indeed Normal? (EG: Plot a bell curve graph if possible so I can see it with my own eyes!!)

So many thanks to any helpers out there.... this may be a simple question but the help available online (if you use any search engine to look at statistics webpages etc) just gets complicated...

Thank you

Holiday

i've got the "drawing a bell curve" part, thanks to Tushar Mehta's a
tutorial.

now, i'd like to draw two bell curves (w/ different height & width) side by
side with some over-lap. how do i go about?

I've got some claims data for various years of insurance liability i.e. a
claims triangulation. The pattern of data is such that say for a policy year
in 2000 you would see a few notifications and as the claims develop in
subsequent years you would see an increase in numbers and then as claims are
settled the experience would run off and if plotted on a graph you would see
the classic bell curve shape.

From what I can see there is no Bell curve trending in Excel just straight
line and a few others. Is there a download?
--
David

Hello -
I have a project that will cost $10MM to build over 12 months. I would like
to spread the costs out in a bell curve shape. For example, I would like
something similar to the following costs...
Month 1 - $100,000
Month 2 - $150,000
Month 3 - $225,000
.....
Month 7 - $2,000,000
Month 8 - $3,000,000
....
Month 11 - $150,000
Month 12 - $100,000

Is there a formula I can use where I can input the total costs and the time
period to allocate so that it will spread my costs out over that time period
in a Bell Curve fashion?

Thanks for your help!

Need to sort a data list to create a bell curve when graphed.

Hi All,

I have recently posted this in a math forum and received no reply in 4/5 days so thought I'd try my luck here with the excel guru's.

I have been given the task of working out the standard dev of some data. I now understand the concept and have managed to get the below data but my question is:

Can I plot a chart based (the bell curve chart) on the data below??

µ -£1.03
s £40.25
Max £136.95
Min -£3,495.40

Total Lines (n)............84575........100.00%
Between -1s and 1s....80078........94.68%
Between -2s and 2s....83308........98.50%
Between -3s and 3s....84573........100.00%

Thanks,
spin.

Hello All,

I am attempting to program a function in VBA that allows me to distribute costs, based on the bell curve, over a period of months. I would like that period to be dynamic, as in, the user can merely specify the beginning and end months and, given a "test" date, the function returns the percentage allocated to that month. The beginnings of the algorithm come from the attached sheet. Here is what I have come up with so far, however, I keep recieving a #NAME error when I call the function in a cell. The second sheet on the attached shows my attempted implementation of this code.

Function BellPDF(TestDate As Date, EarlyDate As Date, LongDate As Date, Dev As Long)

    Dim nMons, Mean, Factor As Double
    Dim relMo, Beta As Double
    
    nMons = (Year(LongDate) - Year(EarlyDate)) * 12 + Month(LongDate) - Month(EarlyDate)
    Factor = 1 / (1 - 2 * NormDist(0, nMos / 2, Dev, True))
    
    BellPDF = NormDist(Month(TestDate), nMos / 2, Dev, True) - NormDist(Month(TestDate) - 1, nMos / 2, Dev, True) * Factor

End Function
Any help at all would be greatly appreciated. I feel like I am literally just staring at the problem but I have been at it so long with the same eyes that I cannot see something simple I am doing incorrectly.

Cheers,
Paddon

662894(2).xls

Ok I hope this isnt too confusing, but here goes..

I work in a research greenhouse and have been taking irrigation data on driplines for the crops. Each week I go around with a PDA and record the date, line, and mins of H20 that are being delivered per day. I had this all in one table in a database. Now I want to come up with a model to work off of. Averaging all the lines per crop. For example, day 1-23 corn lines should be on for 2 mins, days 24-36 3 mins etc etc etc after calculating the averages....

How can I figure out the amount of time that has gone by for each line in relation to the ramp up (and back down) in minutes of water being delivered?

Basically I want to come up with a bell curve model for each crop after averaging all this out, for a "model" based off averages of this raw data to adapt for our watering system.

I have included an example, for "corn"

Thanks!

I am trying to make a bell curve for a class but do not know how?