Hello there,
I have a guideline that suggest when you are driving looking at your Smartphone for greater than 2 seconds within any 6 second period leads to an increased risk of a crash. I have an Excel sheet with two columns, one is the length of time of a single glance, and the other is where the driver is looking, see below. (For your information 5 is looking forward and 6 is at the phone).
<colgroup><col style="width: 48pt;" span="2" width="64"> <tbody>
</tbody>
So how can I calculate: 1) On how many occasions the times associated with 5 were greater than 2 seconds (this is the total time for all 5 within this period) within any rolling 6 second period (or as close to but greater than 6 seconds). 2) More difficult, but is it possible to calculate an average time looking at the phone (5) for any rolling 6 second period.
I hope this makes sense, if it doesn't I can clarify.
Thanks,
Stewart.
I have a guideline that suggest when you are driving looking at your Smartphone for greater than 2 seconds within any 6 second period leads to an increased risk of a crash. I have an Excel sheet with two columns, one is the length of time of a single glance, and the other is where the driver is looking, see below. (For your information 5 is looking forward and 6 is at the phone).
5 | 1.212 |
6 | 0.276 |
5 | 0.596 |
6 | 0.412 |
5 | 1.21575 |
6 | 0.356 |
5 | 0.664 |
6 | 0.3 |
5 | 0.684 |
6 | 0.424 |
5 | 0.92 |
6 | 0.384 |
5 | 2.61975 |
6 | 0.42 |
5 | 1.212 |
6 | 0.284 |
5 | 0.53575 |
6 | 0.496 |
4 | 0.232 |
5 | 0.852 |
2 | 0.596 |
5 | 2.112 |
6 | 0.29975 |
5 | 0.628 |
8 | 0.376 |
5 | 1.888 |
2 | 0.536 |
5 | 0.96 |
8 | 0.35575 |
<colgroup><col style="width: 48pt;" span="2" width="64"> <tbody>
</tbody>
So how can I calculate: 1) On how many occasions the times associated with 5 were greater than 2 seconds (this is the total time for all 5 within this period) within any rolling 6 second period (or as close to but greater than 6 seconds). 2) More difficult, but is it possible to calculate an average time looking at the phone (5) for any rolling 6 second period.
I hope this makes sense, if it doesn't I can clarify.
Thanks,
Stewart.