Ask Your Question

Apparent discrepancy in frequency function

asked 2018-01-30 03:08:43 +0200

ve3oat gravatar image

I am having trouble with FREQUENCY in Calc. For example, my data have five measurements between 116 and 116.99, yet FREQUENCY calculates zero occurrences for "116" and five for "117". This is not what I expected from my experience in engineering and math. Have I specified the ranges incorrectly? Thanks for any help.

edit retag flag offensive close merge delete


See the function in help. I am sure that your "116" is actually 116.00..01 or something.

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-30 03:15:49 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-01-30 03:32:00 +0200

ve3oat gravatar image

updated 2018-01-30 03:42:42 +0200

Yes, I specified bin values (not sure what you call them) of 115, 116, 117, etc., and expected that all five of the measurements between 116.0 and 116.99 would be collected or counted in the bin called "116". That did not happen and I don't understand why. Should have mentioned that I am using LO v5.4.4.

Thanks, Mike, the help link that you gave explains what happened. FREQUENCY counts the values that are equal to or less than the bin values, rather than equal to or greater than (but less than the next bin value) that I had expected. This will definitely affect my stats. Thanks for your help.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-30 03:08:43 +0200

Seen: 64 times

Last updated: Jan 30 '18