Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Time analysis

Copper Contributor

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
1 Reply
This is really a question for a statistician but the very simple answer would be
=countif(A1:A1000,"<60")/count(A1:A1000)