Frequency Plot using Excel
Use my average data for the colors of the M&M’s. The data are given as Color, Observed Frequency: Brown, 49.67; Red, 30.33; Yellow, 28.33; Green, 21.67; Blue, 18.67; Orange, 18.33. The total n = 167. First calculate the expected frequency. Then prepare a frequency plot in Excel of observed frequency for the data and plot a straight line to show the expected frequency. Now discuss if you believe the data to be uniform over the six colors.