logo Hurry, Grab up to 30% discount on the entire course
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Sean WoodComputer science
(5/5)

624 Answers

Hire Me
expert
Robert DLaw
(4.8/5)

608 Answers

Hire Me
expert
Dick BentleyEnglish
(5/5)

526 Answers

Hire Me
expert
Arbaaj KhanScience
(5/5)

861 Answers

Hire Me
Others
(5/5)

Assignment Details You will be analyzing the “Colonial Broadcasting” case.

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Assignment Details You will be analyzing the “Colonial Broadcasting” case. This can be found in the course pack you needed to purchase from Harvard Business Review at the beginning of the term.

If you still need to purchase it, instructions and a link can be found in the syllabus. Begin by reading the description in the case. Then, answer the questions listed below, NOT the questions listed in the case. Ignore everything in the case document after the end of page 4.

The executives at CBC have four main areas in which they are interested: They 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. Remember that your audience is the management of CBC.

Therefore, make sure your presentation is professional. Once you present your results, you need to justify and explain your findings with properly stated conclusions. Answer the following questions: What is the average rating for all CBC movies?

How about ABN movies and BBS movies? Provide a bar chart that compares these averages. Include a table that shows the descriptive statistics using the data analysis tool pack in Excel for the ratings of the three networks (one column for each network).

Comment on how the networks are performing, by comparing and interpreting the metrics in the descriptive statistics table. Your analysis must extend beyond simply comparing the average ratings for each network.

Create a scatter 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 first, and then plot the averages.

After you create the graph, fit a linear trend line and a 2nd order polynomial 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. Which forecasting method is better? How accurate can you expect this forecast to be? 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: The null and alternative hypotheses (state in full sentences). The test results: Run the test using Excel and include the output table. Use a t-test assuming equal variances.

What is your recommendation to the executives? Justify your answer referring to the relevant figures. 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: 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?

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. 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.

Directions for Submitting your Assignment: For this project, you will prepare a PowerPoint presentation to present your findings. The first slide after the title slide should be an “Executive Summary.” It should contain a very brief overview of all the answers. Your final slide should include “conclusions” and provide an overall assessment of the analysis. Make sure you also submit the Excel file to show your work for Part 2.

You will receive a 100-point reduction if you fail to include the Excel file showing 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. All relevant content should be on the slides; do not use the notes section or leave information in the Excel file.

The executives reviewing the presentation should not need to switch to another document to see the required information. The data you need is provided to you in the Unit 6 Excel file in Course Documents. Make sure to use that file. Do not type anything in manually or download anything from the Internet.

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme