Hi- Does anyone know how to make a bell curve with Excel?
I have read up about it online but can find a solution.
See attached data.
Any help would be much appreciated.
Thanks.
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
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
How do I find the Standard Normal Loss value in Excel?
I can find the function for Standard Normal, but I also need the Loss value.
James
Hi folks,
I'm looking for a macro that I can use to thange all Normal text to bold & all Italic text to normal. I would like it to do the entire current sheet.
Any help is appreciated.
Is there a way to plot data against a normal curve in Excel to see the standard deviations and such of the data? Or do you need a different program?
Hi I am looking for a way to generate a random number from a LTN distribution and LN distribution with known mean value and deviation.
For instance:
LTN
mean 1,3
dev 0,2
LN
mean 1,3
dev 0,2
How is this done in excel?
Hi,
I have a sheet with 2300 rows. If I try to copy a range from eg. A12:AO12 and then make a "Insert copied cells with shiftdown" it takes about 1 minute to complete and the CPU is at 100%.
If I do a normal "insert row" its done instantanteously. Unfortunately I can't use this because there are some formulas which I'd like to copy over.
I assume this delay is because all formulas have to be recalculated, right?
Thanks in advance for any insight....or solutions
Max
Hi, everyone,
I have a quick question for normal distribution in Excel.
There's a construction project with the following monthly expenditures:
JUL 2008 $ 4,903
AUG 2008 $ 3,591
SEP 2008 $ 15,452
OCT 2008 $ 12,806
NOV 2008 $ 59,988
DEC 2008 $ 121,808
JAN 2009 $ 261,162
FEB 2009 $ 264,769
MAR 2009 $ 306,240
APR 2009 $ 438,695
MAY 2009 $ 397,569
JUN 2009 $ 345,190
The project's allocated amount is $12 million and the time period is from July 2008 to December 2010. Is there anyway I can forecast future monthly expenditures (from July 2009 & onwards) based on normal distribution model using Excel 2003?
Your input is greatly appreciated.
Thank you.
Excel Noob.
Hi, everyone,
I have a quick question for normal distribution in Excel.
There's a construction project with the following monthly expenditures:
JUL 2008 $ 4,903
AUG 2008 $ 3,591
SEP 2008 $ 15,452
OCT 2008 $ 12,806
NOV 2008 $ 59,988
DEC 2008 $ 121,808
JAN 2009 $ 261,162
FEB 2009 $ 264,769
MAR 2009 $ 306,240
APR 2009 $ 438,695
MAY 2009 $ 397,569
JUN 2009 $ 345,190
The project's allocated amount is $12 million and the time period is from July 2008 to December 2010. Is there anyway I can forecast future monthly expenditures (from July 2009 & onwards) based on normal distribution model using Excel 2003?
Your input is greatly appreciated.
Thank you.
Mega Excel Noob
