Every week the Florida Lottery draws six numbers between 1 and 49 ...

       Every week the Florida Lottery draws six numbers between 1 and   49. Lottery ticket buyers are naturally interested in whether certain numbers   are drawn more frequently than others. To assist players, the Sun-Sentinel   publishes the number of times each of the 49 numbers has been drawn in the   past 52 weeks. The numbers and the frequency with which each occurred were   recorded. a) If the numbers are drawn from a uniform distribution, what is   the expected frequency for each number? b) Can we infer that the data were   not generated from a uniform distribution.   Using excel,   can you show what formulas you use.   Data is   listed below.