GB 513 RANK Imagine Your Future /gb513rank.com GB 513 RANK Imagine Your Future /gb513rank.com | Page 13

This is your final project . You will prepare a PowerPoint presentation to present your findings . This assignment requires you to use Excel ; make sure you also submit the Excel file to show your work . Place all calculations for each of the questions on a separate worksheet . Then , using the results of your work from Excel , prepare PowerPoint slides to answer the questions in a presentation format . Search the Internet to ensure that you are using the best PowerPoint tips to display an appropriate presentation . Check the Webliography tab at the top of the course page for help . For the final project , you will be analyzing the “ Colonial Broadcasting ” case . Answer the questions listed below , NOT the questions listed in the case . Ignore everything in the case after the end of page 6 . The executives at CBC want to see how they are doing in ratings against the other networks and how the ratings will continue to change in the upcoming months . They also want to know if hiring stars makes a difference and the impact of fact based programming compared to hiring stars . You will create a PowerPoint presentation to answer the questions below . Remember that your audience is the management of CBC : Make sure your presentation is professional and provides sufficient explanation . 1 . Descriptive statistics : What is the average rating for all CBC movies ? How about ABN movies and BBS movies ? Include a table that shows the average and the other descriptive statistics for the ratings of the three networks ( one column for each network ). Comment on which network is doing best and what you learn from the other key metrics in the table . 2 . Charting :