Statistical curve in a coordinate system

[Dbjsmed]

Hi I´m trying to make a statistcal curve that will tell me which values are most frequent. My problem is that the cuve puts my values in the highlighted order.

Please help.

[stone]

Hi David.

Could you explain better what you are trying to do?

BK
Stulli

[Dbjsmed]

I alot of differet values between ex. -0,6 and 0,6. I´d like to make a curve that shows me a frequency of the numbers.
but excel shows values one by one in a curve.
hope i helps
David
I´v also made an example i paint which illustrates what I mean.
but i can´t post i here.

[stone]

You could try to do this.

if your values are in column A (A1:A20), then write this formula in cell B1
=COUNTIF($A$1:$A$20;B1), and drag it down to cell B20.

then select A1:B20 and go to DATA->sort, and sort it by column A.

Hope this helps you a little bit.

Stulli

[Mark W.]

On 2002-05-17 04:59, Dbjsmed wrote:
I alot of differet values between ex. -0,6 and 0,6. I´d like to make a curve that shows me a frequency of the numbers.
but excel shows values one by one in a curve.
hope i helps
David
I´v also made an example i paint which illustrates what I mean.
but i can´t post i here.

Sounds like a histogram. If you haven't already done so... add the Analysis ToolPak add-in and choose the Tools | Data Analysis... menu command.

[Dbjsmed]

Ok i´m sorry.
Since i can´t illustrate what I mean, here goes.
I have alot of different mesurement from a trial production, those are my values.
The x-axis represents the values(mesurements), the y-axis represents how many of the same mesurement there are.
it dosen´t help to put them in order then you just get a rising or falling kurve.
I hope you can follow me, and maybe give me an answer.

David

[Asala42]

Hey,

From your description, it sounds like Mark and Stone did answer your question. Both explanations can lead you to a chart with distribution of your points.

In either case, you need to choose bin ranges for your data. That might be as simple as writing a list of integer values. For example's sake, lets say you do that in cells A2:A12 (A1 with a header, A2:12 holding your min through max ranges). This will be your x-axis for your chart.

Stone's approach involves then writing a countif statement. In the above example you'd likely toss these formulas in B2:B12. Then you are free to chart A1:B12 (column-chart for example) and you'd then have something like a distribution curve. Toss in a trendline if you want one as smooth as possible.

You might have to make that countif a bit more complex if you're dealing with a non-integer range (say you wanted 1.25 through 1.75 as a range). In that example you'd tweak the countif to something like =Countif(H2:H200,">="&C2)-Countif(H2:H200,"<"&D2)

where: H2:H200 contains your rawdata, C2 holds the lower value of 1.25, and D2 holds 1.75.

As a sidenote, the Histogram feature out of analysis toolpak does the same thing automatically - although you would still need to create a bin range.

Hope that helps somewhat,
Adam