Forum Discussion
nf227
Dec 01, 2023Copper Contributor
Time analysis
I'm looking to take a dataset that shows time to complete a task in seconds and calculate the likelihood that the task is finished in less the 60 seconds. how can i go about this? here are the data ...
mtarler
Dec 01, 2023Silver Contributor
This is really a question for a statistician but the very simple answer would be
=countif(A1:A1000,"<60")/count(A1:A1000)
=countif(A1:A1000,"<60")/count(A1:A1000)