Statistical Analysis

[aabbasi]

Could someone help me!
I have 3 columns. Lets say in column A, I have values 2,13,46,5,16...upto 70 enteries. In column B I have values 1,32,15,8,20...upto 70 values. And finally in column C there is a difference of Column A-Column B.

I want to find out the PROBABILITY based on column C values that
-- How many of my values will fall between range 5 & 10 or lets say between -1 and 10 and so on.

Any help will be highly appreciated. Thank you

 

[Aladin Akyurek]

On 2002-03-05 18:50, aabbasi wrote:
Could someone help me!
I have 3 columns. Lets say in column A, I have values 2,13,46,5,16...upto 70 enteries. In column B I have values 1,32,15,8,20...upto 70 values. And finally in column C there is a difference of Column A-Column B.

I want to find out the PROBABILITY based on column C values that
-- How many of my values will fall between range 5 & 10 or lets say between -1 and 10 and so on.

Any help will be highly appreciated. Thank you

Sounds like you want a count of diff values between two criteria:

In D1 enter: 5
In E1 enter: 10

In F1 enter:

=COUNTIF(C:C,">"$D1)-COUNTIF(C:C,">="$E1)

The above formula does count according an exclusive between condition.