Finding the Frequency and Class Limits with the Help of Excel in a Frequency Distribution

[@magicmarie8403]

I need to know how to get it frequencies through formula

[@ananthunt]

me too

[@MathandStatsHelp]

About 11:30 minutes in, I use the frequency formula in this video: kzbin.info/www/bejne/l4qrfp-aoteEocksi=mD_nxQcueUUS155h

[@adetunjiademola1330]

type "=frequency(data, classes)" Note that the formula is without the quotation marks Note that classes can either be lower or upper

[@hydrantinco]

Excellent explanation thank you so Much!!

[@MathandStatsHelp]

You're welcome.

[@renejaysevilla2635]

Hi, may I ask why my last class limit exceeds my maximum value, is it fine even though I've written and followed everything correctly

[@MathandStatsHelp]

The last class limit doesn't have to be the maximum value. The maximum value just needs to be between the last class lower and upper limits, inclusive. The last class upper limit can exceed the maximum.

[@user-dn8ji2rl9p]

My last class limit is lower than the max value . What do I do?

[@MathandStatsHelp]

Did you round up the class width? If you didn't, that is probably the problem

[@user-dn8ji2rl9p]

@@MathandStatsHelp class width is range/class size 48/6=8

[@MathandStatsHelp]

@user-dn8ji2rl9p round the 8 up to 9 and the max value will fall in the last class.

[@user-rd3rc6py7j]

very helpful, thanks