Overview
Exercise:
For one month last year, the television audience was distributed as follows: 36% NBC, 22% ABC, 24% CBS and 18% FOX. This year, during that same month, a random sample of 50 homes provided the data shown. Use Excel to test with ? = .05 whether the audience proportions have changed.
ABC
FOX
ABC
FOX
ABC
ABC
CBS
NBC
FOX
FOX
NBC
ABC
CBS
ABC
NBC
NBC
NBC
CBS
FOX
ABC
ABC
FOX
NBC
CBS
CBS
NBC
NBC
ABC
FOX
FOX
NBC
NBC
NBC
NBC
FOX
ABC
FOX
NBC
FOX
CBS
CBS
CBS
FOX
FOX
NBC
CBS
FOX
CBS
FOX
NBC
1-Build the contingency table for this data.
2-Determine if there are statistically significant differences in this year's preferences compared to last year.(Perform the required calculations in an Excel sheet, and include a formal answer to this question.)