I have 4 yrs worth of data I need compiled into a Normal Distribution bell curve. I've found lots of info for single columns of data, but none for multiple columns (see attached). Am I just missing something?
I have 4 yrs worth of data I need compiled into a Normal Distribution bell curve. I've found lots of info for single columns of data, but none for multiple columns (see attached). Am I just missing something?
Before anyone can help, you'll need to tell us what it is you're trying to display or demonstrate. There are multiple ways you can approach the data (the columnar data is in the second tab of the spreadsheet)--by month across x years, year by year etc.--what are you hoping to accomplish?
Like this? Just "copy" the formulas, they allow for multiple columns. Just remember to array the frequency or you get wackey numbers (look in Excel help files)
There are four or five attachments to posts in this thread with various methods of creating curves in Excel. Have you tried any of them? If not, you should, and let us know how it works out. If you have tried them and they're not working for you for some reason or another, let us know about that too, and exactly what it is you're trying to do.
To add my two cents; my experience is manipulate/structure the data in excel; analyze and conduct tests/experiments with Minitab.....it will make your life easier.
Absent Minitab, the best site I have found for mostly MS products, with great response is a site started by Woody Leonard an MS techie
It is possible without any add-ins and Minitab???.i also having the same doubt, i am searching lot but i cannot get a correct answer(understandable for me).if it is possible can any one tell with examples??
It is possible without any add-ins and Minitab???.i also having the same doubt, i am searching lot but i cannot get a correct answer(understandable for me).if it is possible can any one tell with examples??
The easy ?? way (2 x axis) http://elsmar.com/Forums/showthread.php?t=10729#3
The trouble with the easy way is that as far as I know the new versions of Excel, is a little difficult to change the X axis to a secondary axis (the interface doesn't help, maybe because it was something, that somebody evaluated as wacky). So it's posible that you would need a macro to do the change (just once).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to the use of cookies.