Please create an excel file to answer Question No.2 & 3. Once you complete the table for chi-square value, run the hypothesis test with your conclusion.

1.In a particular market there are three commercial television stations, each with its own evening news program from 6:00 to 6:30 P.M. According to a report in this mornings local newspaper, a random sample of 150 viewers last night revealed 53 watched the news on WNAE (channel 5), 64 watched on WRRN (channel 11), and 33 on WSPD (channel 13). At the .05 significance level, is there a difference in the proportion of viewers watching the three channels?

3. Where do you get your travel information? In order to create a behavioral profile of pleasure travelers, M. Bonn (Florida State University), L. Forr (Georgia Southern University), and A. Susskind (Cornell University) interviewed 5,026 pleasure travelers in the Tampa Bay region (Journal of Travel Research, May 1999). Two of the characteristics they investigated were the travelers' education level and their use of the Internet to seek travel information. The table below (saved in the NETRAVEL file) summarizes the results of the interviews. The researchers concluded that travelers who use the Internet to search for travel information are likely to be people who are college educated. Do you agree