1. Answer the following questions:
   1. What is the average rating for all CBC movies? How about ABN movies and BBS movies? Provide a bar chart that compares these averages.
2. The executives wish to know if they should hire stars for their programs. To answer this question, run a hypothesis test to see if the ratings of shows with stars are higher compared to those without stars. Use the data for CBC movies only. Use 95% confidence. Your answer should include the following:
   1. The null and alternative hypotheses (state in full sentences).
   2. The test results: Run the test using Excel and include the output table. Use a t-test assuming equal variances.
   3. What is your recommendation to the executives? Justify your answer referring to the relevant figures.
3. Run a multiple regression where the dependent variable is ratings and the independent variables are star and fact. Use data from CBC only. CBC Management has several questions:
   1. Executives wish to know how much being fact-based or having one star contributes to a movies rating. What can you tell them about this?
   2. Are either, both, or neither of the independent variables significantly related to the ratings at 95% confidence? Justify your answers referring to the relevant figures.
   3. How well does this regression analysis explain the ratings? Should the executives count on the results from this analysis? Justify your answers referring to the relevant figures.