In this e-project, you will explore TV ratings and analyze them with Excel. Download the Excel file called Ch07_NielsenRatings. This file contains ratings for popular network programs for two separate weeks in 2013. (http://www.nielsen.com/us/en/top10s.html). The rating represents the percent of U.S. households that were watching that channel at the time (of those whose TV was turned on).

7-35. Answer the following questions:

a. Which show gains the largest number of viewers from July 4 to July 11?

b. Which show is the biggest loser from July 4 to July 11, in terms of change in ratings?

c. Compute the total viewers for these shows for July 4 to July 11. How many total viewers watched one of the TV shows in this list during the week of July 4?

d. What is the percent change in total viewers for the shows in this list from July 4 to July 11?