which network is doing best and what you learn from the other key metrics in the table . 2 . Charting : Create a line graph of the monthly average ratings for CBC for the year . Note that there are multiple ratings data for the months ; you will need to calculate an average for each month and then plot the averages . After you create the graph , fit a linear trend line , displaying the formula and the r-squared . Explain to the executives if you can use this time series data to forecast the ratings of upcoming months . How accurate can you expect this forecast to be ? 3 . Hypothesistesting : Should the CBC hire stars for their movies ? To answer this question , run a hypothesis test to see if there is a significant difference between the ratings of movies with stars vs . movies without stars . Use the data for CBC movies only . Use 95 % confidence . Explain your answer- do not simply say yes or no without referring to the relevant figures . 4 . Regression : CBC Management has several questions : Which has more impact on a movie ’ s rating : that it is fact based or that it has one star ? How much does each of these factors change the ratings ? Do you expect a fact based movie that does not have any stars to get better ratings than a fiction movie with one star ? Run a multiple regression where the dependent variable is ratings and the independent variables are star and fact . Use data from all networks , not just CBC movies . How well does this regression analysis explain the ratings ? Justify your answers based on the results .
which network is doing best and what you learn from the other key metrics in the table . 2 . Charting : Create a line graph of the monthly average ratings for CBC for the year . Note that there are multiple ratings data for the months ; you will need to calculate an average for each month and then plot the averages . After you create the graph , fit a linear trend line , displaying the formula and the r-squared . Explain to the executives if you can use this time series data to forecast the ratings of upcoming months . How accurate can you expect this forecast to be ? 3 . Hypothesistesting : Should the CBC hire stars for their movies ? To answer this question , run a hypothesis test to see if there is a significant difference between the ratings of movies with stars vs . movies without stars . Use the data for CBC movies only . Use 95 % confidence . Explain your answer- do not simply say yes or no without referring to the relevant figures . 4 . Regression : CBC Management has several questions : Which has more impact on a movie ’ s rating : that it is fact based or that it has one star ? How much does each of these factors change the ratings ? Do you expect a fact based movie that does not have any stars to get better ratings than a fiction movie with one star ? Run a multiple regression where the dependent variable is ratings and the independent variables are star and fact . Use data from all networks , not just CBC movies . How well does this regression analysis explain the ratings ? Justify your answers based on the results .
===================================================================================