# Question About Probability, Travel Distance, and What Function to Use?

#### MocExcel

##### New Member
Hello!

I'm trying to figure out what is the probability of a unit traveling greater than X given my data set. I am testing what is the % chance of the distance being greater on 1 try.

Here is some info about the data set:
Mean Travel Distance: 33.8
Median Travel Distance: 25
Standard Deviation: 31.3
Sample Size: 2139
Max Distance: 192
Min Distance: 0

I was using the below equation, but I do not know if it is the right function because the data is skewed right instead of a normal distribution:

=1-NORM.DIST(Travel Distance Being Tested,Mean,Standard Deviation,TRUE)

Should I be using a different function based on my data set?

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

#### shg

##### MrExcel MVP
Reckon someone would have to look at the data to see if they could fit a better distribution, but you could certainly use a formula to count the fraction of samples > x:

=countif(data, ">" & x) / count(data)

• MocExcel

#### MocExcel

##### New Member
Not sure if this helps to better describe the data, but the =SKEW function is 1.63

Not really.

Replies
10
Views
538
Replies
1
Views
243
Replies
3
Views
279
Replies
3
Views
324
Replies
1
Views
2K