Distibution Curve

Hi, i was wondering if someone could help.

I have a list or 100 numbers and need to build a distribution curve in a graph - I've no idea how to do it and google give me some very complex examples that I just get lost in.

It doesn't need to be anything exciting but any help will be appreciated

Andy

thanks ever so much

Originally Posted by Kaper

the distribution - you will get the data by in E1: 5 and down 6,7,.....
then select F1:F9 and insert the array formula*

Formula:

Please Login or Register  to view this content.

*)...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Hi Kaper

I've another request please....

The contents in E1:E9 is whole numbers, I need to move to 2 decimal places as per results - how can I do that as each time I try to change something it tells me I cannot change part of an array ??

Andy

Originally Posted by joeu2004

[.... deleted ....]

What does this mean ??