Hi, I am not sure how to plot a bell curve.

Google search but still confuse.

Thanks for advice.

Excel 2007.

Google search but still confuse.

Thanks for advice.

Excel 2007.

- Can you plot individual numbers on a bell curve in excel, and how.
- Charting a skewed bell curve
- Widening The Curve Of A Bell Curve
- Combining a Bell Curve and another chart type
- Transforming data to Normal (Guassian) bell curve
- How do i plot a logistic curve?
- Trying to develop a bell curve model
- How can I make a bell curve in excel?
- Bell Curve for target value
- Where do I find A bell curve I can copy and paste
- Need a formula to distribute a value along a bell curve.
- How do I create a Bell Curve Graph in Excel
- A bell curve
- Creating a Bell Curve in Excel 2010
- Question regarding how to plot interval estimates for a bell curve
- How do I plot a logistic curve
- VBA - Applying Costs Via A Bell Curve
- How to create a bell curve / normal distribution graph
- HOW DO I SHADE AN AREA ON A BELL CURVE?
- Doing a "best fit" bell-curve analysis
- Plotting a Lorenz Curve
- Bell Curve Charts
- How do you show Bell Curve Revenue Projections?
- How do i draw two bell curves side by side w/ some over-lap?

to plot the actual values as they fall along the curve. Does anyone know how

I can plot these???

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 have an example that I can send if that helps.

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

(0,38558),(10,49371),(20,62980),(30,76212),(40,922 28),(50,106022),(60,123203),(70,132165),(80,151326 ),(90,179323),(100,203212),(110,226546),(120,24871 0),(130,281422)

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!

Thank,

Sofia

excel. Where and how do I find it.

Say I have $x,xxx. I want to spread that amount out in a certain proportion, regardless of how many cells I'm spreading it throughout.

Say I have a $10,000 project. I want to be able to spread it out like a bell curve in the cells I choose. For instance, if it was a five month project it would be distributed as

January - $1,000

February - $2,500

March - $3,000

April - $2,500

May - $1,000

If I added another month it would change to

January - $833.33

February - $1,666.66

March - $2,500.00

April - $2,500.00

May - $1,666.66

June - $833.33

I already thought of manually adding percentages to each cell, but the formula needs to be dynamic.

Thanks!

I am trying to create a Bell Curve Graph in Excel but have ground to a halt,

I using Excel 9

I using Excel 9

I'm trying to do a bell curve (to column B, Visits). I've tried several guides, but always get ridiculous result.

This was my last attempt, based on this video:

http://www.youtube.com/watch?v=refaA0jvqE8

And the attached file is what i get.

Help please!

Question.xlsx

I've been trying all day to create a bell curve for my stats class. Here is the data I'm using

(population mean) µ = 30,833.46

(standard deviation) σ = 16,947.09727

(sample population) n = 47

(mean of the sample) Xbar = 24,451.51064

Can someone please 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

if regression (r^2) values are closer to 1, then linear or exponential

regression lines. The formula is Y = N/1+Ab^-t where N = 281422, A =

281421, b = %increase/time (slope), and t = time (x axis) my data points are

as follows:

(0,38558),(10,49371),(20,62980),(30,76212),(40,922 28),(50,106022),(60,123203),(70,132165),(80,151326 ),(90,179323),(100,203212),(110,226546),(120,24871 0),(130,281422) examples are greatly appreciated.

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 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 have a dataset that represents the varying sales prices of a particular product.

My goal is to come up with what would be a "substantive" price for the product, and want to use a bell-curve approach. My methodology is that any price that is within 20% of the "substantive" price would be deemed acceptable, but prices that deviate by more than 20% are not acceptable.

If my values were evenly distributed, I could use the median or an average price to define my "substantive" price, but my population of prices isn't evenly distributed. So, the most "substantive" price may not necessarily be the median or the average.

I can figure this out myself by using goal seek (ex., if substantive price = $2,000, then 15 out of 20 sales are within range, if substantive price = $2,100, then 14 out of 20 sales are within range, etc.). However, I don't want to hunt and peck. I want a function that will automatically calculate the best fit to the bell-curve.

I've uploaded an example of what I'm talking about.

Any suggestions?

Thanks!

I am trying to plot a basic lorenz curve

bottom of the graph being 10- 100 in increments of 10 and the label "Cumulative Population in %"

Left axis being 5-50 in increments of 5 and the label being "Cumulative Income/GDP in %"

with the following data points:

@ 20% 7.0

@ 40% 11.5

@ 60% 15.8

@ 80% 21.8

@ 100% 43.9

Im having a really hard time figuring out how to do this and the explanations I have found online so far have been a bit confusing

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!

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?

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