Frequency tool creating duplicate entries?

182
1
05-16-2023 07:15 AM
JessWyatt
New Contributor

I am working with fire department incident data, and I am trying to determine the frequency of each response time.  Response time is in a double field and represents seconds (whole number).  There are over 100k records, and for some reason when I run the Frequency tool, it is breaking down some response times into multiple entries.

JessWyatt_1-1684245909408.png

This is creating 1485 duplicate entries (15,113 unique times, but 16,598 entries), with 1409 records creating duplicates.  For example, in my incident data I have 12 incidents that have a response time of 109 seconds.  Running the frequency tool is creating 3 separate records for 109 seconds

JessWyatt_2-1684246302096.png

I cannot figure out why it is grouping them this way.

I was able to use the summary statistics tool to create a new table that consolidated the duplicates, but I was wondering if anyone knew exactly what went wrong here, or if they were having the same issue.

0 Kudos
1 Reply
DavidPike
MVP Frequent Contributor

Do you maybe have some significant figure display set on that field?  e.g values are actually 109.1, 109.2, 109.4

0 Kudos