Forum Discussion
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 points i have so far
| 24 |
| 26 |
| 30 |
| 30 |
| 32 |
| 33 |
| 33 |
| 34 |
| 36 |
| 37 |
| 37 |
| 40 |
| 40 |
| 40 |
| 41 |
| 42 |
| 45 |
| 46 |
| 48 |
| 51 |
| 53 |
| 53 |
| 53 |
| 61 |
| 62 |
| 62 |
| 66 |
| 67 |
| 70 |
| 73 |
| 75 |
| 78 |
| 79 |
| 84 |
| 90 |
| 90 |
| 92 |
| 96 |
| 97 |
| 105 |
| 108 |
| 130 |
| 134 |
| 136 |
| 211 |
- This is really a question for a statistician but the very simple answer would be
=countif(A1:A1000,"<60")/count(A1:A1000)
