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!

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!

- Creating bell curve in excel
- Creating bell curve in excel
- Creating Bell Curve Chart
- HOW DO I SHADE AN AREA ON A BELL CURVE?
- Combining a Bell Curve and another chart type
- Charting a skewed bell curve
- Excel Charts - Need Help Creating Bell Curves
- Bell Curve Graph
- How to create a bell curve / normal distribution graph
- How do you create a bell chart for sigma using excell?
- Forumula for Excel Bell Curve and Histogram
- Creating a Bell Chart in Excel
- How do you show Bell Curve Revenue Projections?
- Widening The Curve Of A Bell Curve
- Question regarding how to plot interval estimates for a bell curve
- Transforming data to Normal (Guassian) bell curve
- How do i draw two bell curves side by side w/ some over-lap?
- Trend Line - Bell Curve
- Bell Curve
- Sort function to sort for bell curve
- Standard Dev Chart
- VBA - Applying Costs Via A Bell Curve
- Trying to develop a bell curve model
- How can I make a bell curve in excel?

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

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

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

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

Thanks!

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

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?

input this into the chart?

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

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

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

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

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?

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

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!

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.

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 FunctionAny 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

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!

No luck finding an answer? You could always try Google.