Show work on Excel

Many studies have been done that consistently show a negative correlation between seasons of popular tv shows and ratings based on those seasons (meaning the more years a show is on, the lower the ratings tend to be). Thgyastumajgtyugf these studies are done using comedies. For this assignment u will focus on a non-comedy genre of your choice. There are a W lot of different genres to choose from so for the sake of consistency, pick one ofthe genres listed on this page: htt s: tvtro es.or mwiki mwiki. h Main ShowGenres. List your choice of genre here: Now choose 4 shows from that genre that have had AT LEAST 5 seasons. Note that they can still be currently airing new shows, but there must be at least 5 seasons worth of data. FOR THOSE OF YOU DOING A HW MAKEUP Using Excel or a similar program (if you use an online calculator, you will need to take a screenshot of the site you used and attach it to this assignment), compile data for your 4 chosen shows where the dependent variable (y) is the ratings, and then you need 3 independent variables. One of those 3 independent variables must be the season, but the other two variables you choose are up to you as long as it's numeric data that can be measured per season, it'll work. DO NOT use other ratings sites for the other independents. Make sure there are no spaces between your data sets if you're using Excel. Now run multiple regression on your data. Which of the independent variables appears to have the strongest correlation to the dependent variable based on p-value? Now, construct a multiple regression equation and use it to make a prediction about the ratings of a season (your choice which season) of another show that isn't one of your original 4. After making that prediction, subtract the value you get from the actual value you find online to calculate the residual. Are you surprised by the result? Any bias that needs to be discussed