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

[MocExcel]

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?

 

[shg]

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]

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

 

[shg]

Not really.