Easy Frequency Distribution For Bingo Numbers in Excel – 2430

Candace is using a third-party Bingo app to generate numbers for a bingo game. Some people are complaining that the app is not fair and that it is calling some numbers too frequently. Candace manually keyed the numbers into Excel and wants to analyze to see if the numbers are uniformly distributed.
This episode will show you how to test to see the distribution between the five columns and between the 75 numbers. Note that while this could have been done with the FREQUENCY function, I chose a pivot table instead.