Thanks:  0
Likes:  0

# Thread: Statistical Analysis

1. 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

2. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•