Free Microsoft Excel 2013 Quick Reference

Plot a bell curve

Hi, I am not sure how to plot a bell curve.
Google search but still confuse.

Thanks for advice.

Excel 2007.


I have created a bell curve in excel with the mean and std. dev. and now need
to plot the actual values as they fall along the curve. Does anyone know how
I can plot these???

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

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?

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!

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 am trying to plot a logistic curve and determine r2 values for 13 data points
(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)

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?

Hello, I work in the food industry and a customer wants us to process bell peppers and achieve a target length of 2in. We've run several samples and i meassured indivudual slices of what we can realistically do consistenly. How to i plot a bell curve to see the percentage of slices that will be over and under 2in. I've followed several examples all day but i end up with negative numbers and obviously i won't have negative bell pepper lengths. in the file attached you'll see the real date i collected for slicing the tops and center of the pepper, if i can get an example of the center numbers i can replicate it on the ends (it's in the tabs name)
Thank,
Sofia

I want to find a bell curve that I cancopy and paste and make changes to in
excel. Where and how do I find it.

Hey everyone! I'm trying to find a formula that would spread out a value amongst multiple cells along a bell curve.

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

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

Hi All,

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?

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

I need to fit a logistic curve to data points on a scatter plot to determine
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.

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

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

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

Hi everyone, I'm sure there's probably a clever solution to this, but it's beyond me.

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!

Hey all,

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

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!

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