28 Oct For the project, you will be analyzing a case and communicating your results with a PowerPoint presentation. In this assignment, you will be assessed based on the following outcomes
The second assignment due in Unit 6 is a project.
For the project, you will be analyzing a case and communicating your results with a PowerPoint presentation.
In this assignment, you will be assessed based on the following outcomes:
GB513-4: Evaluate real-world situations and present solutions using statistical methods.
PC-6.1: Incorporate data, inferences, and reasoning to solve problems.
The data you need for Part 2 is provided in the following Excel file. Be sure to use this file and do not type anything manually from the case or use other sources for the data.
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.
Submit your assignment to the Unit 6 Assignment Dropbox.
Harvard Business School 9-894-011 November 22, 1993
Professor George Wu prepared this case as the basis for class discussion rather than to illustrate either effective or ineffective handling of an administrative situation.
Copyright © 1993 by the President and Fellows of Harvard College. To order copies or request permission to reproduce materials, call 1-800-545-7685, write Harvard Business School Publishing, Boston, MA 02163, or go to http://www.hbsp.harvard.edu. No part of this publication may be reproduced, stored in a retrieval system, used in a spreadsheet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of Harvard Business School.
1
Colonial Broadcasting Company
Part A
Barbara Warrington, Vice-President of Programming at Colonial Broadcasting Company (CBC), sat in her office preparing for a meeting with Bruce Gold, an independent movie producer. Warrington thought that Gold would probably try to sell to CBC a movie idea based on the true story of a young boy who overcomes a debilitating illness. In recent years, the number of TV movies based on real-life events (fact-based movies) had been steadily growing. The networks seemed to believe that these movies brought higher ratings than fictional movies. But Warrington wasn't so sure. She suspected that other factors could be responsible for the high ratings of fact-based movies. Warrington had data on TV movies that were broadcast during 1992. She decided to have one of her assistants run some regressions to find out what was really driving ratings.
Colonial Broadcasting Company
Along with American Broadcasting Network (ABN) and Bellmore Broadcasting Service (BBS), Colonial Broadcasting Company is one of three major American television networks.1 Every week, each network broadcasts hundreds of hours of national programming, including news, sports, talk shows, as well as prime-time programming (theatrical and made-for-television movies;2 action, comedy, and drama series; news specials, etc.).3
Broadcasting TV Movies
TV movies were first broadcast in the mid-1960s, and in the following decades came to play a major part in network programming. By 1992, the three major networks—ABN, BBS, and CBC—
1. A fourth network, Derby Television Network (DTN), has some highly-rated national shows and is an important competitor to the three majors. However, since DTN does not have daily national prime time programming, it is not considered in this case. 2. Theatrical movies are originally released in theatres and are shown on television several years after theatrical release. In contrast, made-for-television or TV movies are made explicitly for television. 3. Prime time runs from 8–11 p.m. on the East and West Coasts and from 7–10 p.m. in the Central States. The TV season runs from September to May. Thus, the three networks jointly broadcast approximately 2,300 hours of prime-time programming annually.
For the exclusive use of A. Tuoyo, 2023.
This document is authorized for use only by Austin Tuoyo in GB513: Business Analytics_3_18_2024 taught by Christopher Osadczuk, Purdue University Global from Sep 2023 to Mar 2024.
894-011 Colonial Broadcasting Company
2
were underwriting the production costs for more than two hundred hours of TV movies annually, approximately 10% of network prime time programming.
The typical TV movie is made by an independent producer, with the cost underwritten by one of the networks. It is approximately 92 minutes long, but with commercials, it runs for two hours. TV movies are broadcast during prime time, usually beginning at 9 p.m. on the East and West Coasts and at 8 p.m. in the Central States.
The networks' aim in broadcasting TV movies is to attract a large and demographically desirable audience. Networks are funded by advertisers who pay for on-air advertising time, and advertisers pay higher prices for programs which attract larger audiences. A network's success in attracting a large audience is reflected in its Nielsen ratings.4 These ratings, expressed as a percentage of all American households with televisions, measure how many televisions are turned on to particular programs. In 1992, each rating point represented 921,000 American households. Therefore, if a movie received a 25 rating during a given half-hour time slot, about 23 million households were tuned in to that movie at that time.
The TV movie with the highest rating on record is The Day After (a movie about the aftermath of a nuclear holocaust) which garnered a rating of 46 when broadcast in 1983. The broadcast of the 1992 Super Bowl, by comparison, received a Nielsen rating of 40.
Making a TV Movie
The networks do not produce their own TV movies but instead contract with independent producers to have them made. Producers must first sell a movie concept to a network. The concepts the producer has to choose from fall into two basic categories: those drawn from fact and those drawn from fiction. A typical fact-based concept for a TV movie might be drawn from national or regional newspapers or a nonfiction book. On the other hand, a fictional movie might be based on a novel, play, screenplay, or simply the producer's brainstorming.
If necessary, the producer must arrange for an option on the story rights. If the movie concept is based on a true-life occurrence, the option takes the form of an agreement between the producer and the rights holder, usually the people involved in the real-life events. In contrast, for novels, plays, and screenplays, the producer merely needs to get an option on the appropriate copyright. In most cases, a fee is paid for an exclusive option. The option then gives the producer the right to buy a piece of material within a specified period of time (e.g., the producer might pay $10,000 for a one-year option to buy the rights to a story for an additional $100,000). Once the producer has the story-rights, he can approach the networks and pitch his concept for the movie.
The networks have several basic criteria for judging potential TV movies. Unlike television series, for which audience loyalty can be built over the course of a season or even many seasons, TV movies are usually a one-shot deal. Ideally, network executives believe, TV movies should be
"’believable’ and sensational at the same time … Characters should be simple and simply motivated, heroes familiar, stories full of conflict, endings resolved, uplift apparent, and each act should end on a note of suspense sufficient to carry the viewer through the commercial break."5
4. A. C. Nielsen Company is a major research firm which provides data on ratings and market-share for prime- time programming based on information gathered from sample households throughout the continental United States. 5. Todd Gitlin, Inside Prime Time (New York: Pantheon Books, 1983): 161, 165.
For the exclusive use of A. Tuoyo, 2023.
This document is authorized for use only by Austin Tuoyo in GB513: Business Analytics_3_18_2024 taught by Christopher Osadczuk, Purdue University Global from Sep 2023 to Mar 2024.
Colonial Broadcasting Company 894-011
3
If a movie concept generates enough interest from the network, the network will pay a script-writer to develop the idea into a full-length script.
If the script is acceptable, then the network will commit to produce the movie. Typically, the network and production company agree on a licensing fee (usually $2.60 to $2.75 million which covers the bulk of the production costs) for the network's exclusive North American right to broadcast the movie twice in four years. The licensing fee covers the bulk of the producer's production costs.6
Warrington's Decision
Warrington knew that CBC's programming decisions were motivated primarily by ratings. She made a mental list of factors that might affect a TV movies' ratings: the day of the week or month it was broadcast, the broadcasting network, whether the movie had a big-name star, whether it was scheduled against tough competition, or whether the program immediately before it on the same network had high or low ratings. Was the movie concept—fact-based or fictional—one of the factors that drove ratings? Warrington looked down at the regressions which her assistant had brought in (see Exhibits 1 and 2). What did they tell her?
6. The licensing fee paid by the network usually falls about $400,000 short of actual production costs. After the network broadcasts the movie, the rights revert to the production company. The production company covers the short-fall with national and international fees for theater and television syndication and video cassette release.
For the exclusive use of A. Tuoyo, 2023.
This document is authorized for use only by Austin Tuoyo in GB513: Business Analytics_3_18_2024 taught by Christopher Osadczuk, Purdue University Global from Sep 2023 to Mar 2024.
894-011 Colonial Broadcasting Company
4
Exhibit 1 Data on 1992 TV Movies*
Variable Description
NETWORK Broadcasting network (ABN, BBS, or CBC) MONTH 1 = January, 2 = February, …, 12 = December DAY 1 = Monday, 2 = Tuesday, …, 7 = Sunday RATING Nielsen rating for movie FACT 1 = based on true events, 0 = fictional STARS Number of actors or actresses paid over $300,000 PREVIOUS RATING Nielsen rating for program immediately preceding movie on same
network COMPETITION Average of Nielsen ratings received by the two competing networks
during the movie's broadcast
In addition, several dummy variables derived from the variables listed here are used in the regressions which follow. Examples are
ABN 1 if NETWORK = ABN, BBS 1 if NETWORK = BBS, OCT 1 if MONTH = 10, DEC 1 if MONTH = 12, APR-MAY 1 if MONTH = 4 or MONTH = 5, MON 1 if DAY = 1, SUN 1 if DAY = 7.
* All 1992 TV movies, not including sequels to old television series, movies that are part of a series, two-hour pilots for television series, or two-hour segments of a television mini-series.
For the exclusive use of A. Tuoyo, 2023.
This document is authorized for use only by Austin Tuoyo in GB513: Business Analytics_3_18_2024 taught by Christopher Osadczuk, Purdue University Global from Sep 2023 to Mar 2024.
Colonial Broadcasting Company 894-011
5
Exhibit 1 Data on 1992 TV Movies (continued)
Observation
Network
Month
Day
Rating
Fact
Stars
Previous Ratings
Competition
1 BBS 1 1 15.6 0 1 14.2 14.5
2 BBS 1 7 10.8 1 0 15.3 17.2
3 BBS 1 7 14.1 0 1 13.8 14.4
4 BBS 1 1 16.8 1 1 12.8 15.3
5 BBS 2 1 14.3 1 1 12.4 13.3
6 BBS 2 1 17.1 1 1 12.9 15.1
7 BBS 3 1 8.9 0 0 10.8 14.9
8 BBS 3 7 16.2 1 0 13.3 11.6
9 BBS 4 7 9.4 0 1 12.3 12.8
10 BBS 5 1 10.2 0 1 10.7 15.6
11 BBS 5 7 9.4 0 0 10.7 14.5
12 BBS 5 1 12.1 0 1 10.1 15.6
13 BBS 5 1 10.7 1 0 8.6 17.0
14 BBS 9 7 15.0 1 0 9.8 8.2
15 BBS 9 7 10.2 0 0 11.7 13.5
16 BBS 9 7 10.3 0 1 10.1 15.2
17 BBS 10 7 10.8 0 1 10.9 13.1
18 BBS 10 7 14.4 1 0 15.9 12.6
19 BBS 11 7 14.4 1 1 12.1 14.2
20 BBS 11 7 13.6 1 0 11.4 11.9
21 ABN 1 7 14.6 0 0 19.3 14.4
22 ABN 1 2 10.8 0 1 16.3 15.2
23 ABN 1 7 16.2 0 0 20.1 14.4
24 ABN 1 2 12.8 0 0 14.8 13.1
25 ABN 1 7 16.0 0 1 19.3 13.5
26 ABN 2 7 18.9 0 1 17.8 13.0
27 ABN 2 2 14.0 1 1 14.3 13.8
28 ABN 3 7 19.5 1 1 16.2 11.8
29 ABN 3 2 14.7 1 0 13.8 15.7
30 ABN 3 7 16.3 0 1 18.0 11.4
31 ABN 3 7 15.8 1 0 17.7 13.3
32 ABN 3 7 17.1 0 1 17.1 11.3
33 ABN 3 2 11.5 0 0 13.8 13.1
34 ABN 3 7 16.0 1 0 15.3 11.8
35 ABN 3 2 11.7 0 1 16.6 14.3
36 ABN 4 2 14.2 0 0 13.6 11.4
37 ABN 4 7 11.2 0 0 14.3 14.4
38 ABN 4 2 10.9 0 0 12.4 13.0
39 ABN 4 7 13.3 0 1 13.1 10.1
40 ABN 4 7 15.5 1 0 17.0 12.4
41 ABN 4 2 16.6 1 0 13.6 11.8
42 ABN 5 7 16.3 1 0 16.5 12.8
43 ABN 5 7 15.8 0 1 15.7 11.3
44 ABN 5 2 13.3 1 0 10.7 12.8
For the exclusive use of A. Tuoyo, 2023.
This document is authorized for use only by Austin Tuoyo in GB513: Business Analytics_3_18_2024 taught by Christopher Osadczuk, Purdue University Global from Sep 2023 to Mar 2024.
894-011 Colonial Broadcasting Company
6
Exhibit 1 Data on 1992 TV Movies (continued)
Observation
Network
Month
Day
Rating
Fact
Stars
Previous Ratings
Competition
45 ABN 9 7 15.4 0 1 17.3 10.9
46 ABN 9 2 14.7 0 0 15.5 13.9
47 ABN 9 7 15.5 0 0 17.4 12.6
48 ABN 9 2 14.7 1 0 15.3 14.0
49 ABN 10 7 15.9 1 0 18.4 10.5
50 ABN 10 7 13.8 1 0 24.7 12.1
51 ABN 10 2 10.0 0 1 14.2 12.9
52 ABN 11 7 12.9 0 1 16.9 18.6
53 ABN 11 2 15.4 1 0 15.9 12.4
54 ABN 11 7 14.5 0 2 19.4 14.2
55 ABN 12 7 18.8 0 2 16.7 14.7
56 ABN 12 2 16.7 0 0 14.9 10.1
57 ABN 12 2 12.8 0 0 16.3 12.0
58 ABN 12 7 16.8 0 1 15.7 10.1
59 CBC 1 7 14.0 0 1 8.2 14.8
60 CBC 1 1 11.3 1 0 13.0 13.2
61 CBC 1 1 13.6 0 0 13.7 15.1
62 CBC 2 7 12.9 1 0 8.8 16.0
63 CBC 2 1 13.2 1 0 13.1 17.0
64 CBC 2 7 16.0 1 0 6.9 15.8
65 CBC 2 1 14.6 1 1 13.8 17.4
66 CBC 2 7 16.6 0 1 16.8 14.4
67 CBC 3 1 17.5 1 0 14.8 14.2
68 CBC 3 7 11.6 0 0 10.0 14.0
69 CBC 4 7 8.9 0 0 8.6 13.0
70 CBC 4 1 15.6 0 0 13.3 16.8
71 CBC 4 7 9.2 0 1 6.8 12.1
72 CBC 4 1 11.8 0 0 12.9 12.0
73 CBC 4 7 11.0 0 0 5.3 14.7
74 CBC 4 1 9.5 1 0 13.0 17.3
75 CBC 9 7 11.6 0 0 10.1 12.8
76 CBC 9 1 13.3 1 0 13.1 20.3
77 CBC 9 1 13.6 1 0 14.1 18.3
78 CBC 10 1 12.4 0 0 13.6 20.2
79 CBC 10 1 13.8 1 0 10.2 16.6
80 CBC 10 7 11.9 1 0 11.8 12.2
81 CBC 10 1 14.6 0 0 14.9 14.9
82 CBC 11 1 15.8 1 1 13.4 17.2
83 CBC 11 1 15.4 0 1 13.6 16.8
84 CBC 11 1 12.8 0 0 12.7 14.6
85 CBC 12 7 12.8 0 0 12.0 18.6
86 CBC 12 1 15.1 0 0 14.1 15.5
87 CBC 12 1 11.4 0 1 11.2 16.4
88 CBC 12 1 19.1 1 0 12.6 15.4
For the exclusive use of A. Tuoyo, 2023.
This document is authorized for use only by Austin Tuoyo in GB513: Business Analytics_3_18_2024 taught by Christopher Osadczuk, Purdue University Global from Sep 2023 to Mar 2024.
Colonial Broadcasting Company 894-011
7
Exhibit 2 Regressions on 1992 TV Movies
For the exclusive use of A. Tuoyo, 2023.
This document is authorized for use only by Austin Tuoyo in GB513: Business Analytics_3_18_2024 taught by Christopher Osadczuk, Purdue University Global from Sep 2023 to Mar 2024.
894-011 Colonial Broadcasting Company
8
Questions
For Questions 1a and 1b only, consider Regression 1.
1a. Rank the networks in terms of average ratings for TV movies during 1992.
1b. On average, how much higher are the ratings for the leading network than the ratings for the second-highest network?
2a. In 1992, what were the average ratings for fact-based movies?
2b. In 1992, what were the average ratings for fictional movies?
3. Consider Regression 2. Is the difference between the ratings for fact-based and fictional movies statistically significant? Explain.
4. Compare Regression 2 and Regression 3. Do the regressions suggest that, on average,
a. a fact-based movie has fewer stars than a fictional movie; b. a fact-based movie has more stars than a fictional movie; c. a fact-based movie has just as many stars as a fictional movie; d. cannot be determined.
Choose one and explain.
For the next two questions, consider Regression 5.
5. On Sunday nights, CBC usually presents "Josette and Yvette" at 8:00 p.m., followed by the Sunday night movie at 9:00 p.m. Typical ratings for "Josette and Yvette" are 17.5. This week, Warrington is considering replacing "Josette and Yvette" with a live rock concert that is expected to garner a rating of 20 points. What is the expected change in ratings for the Sunday night movie?
6a. Warrington fears that a movie with high expected ratings might provoke the other networks to schedule better programming against CBC. Suppose that in response to CBC's programming, both ABN and BBS schedule different programs, each of which is expected to rate 2 rating points higher. What is the expected impact on the ratings of CBC's TV movie?
6b. Oskar Morgenstern, a CBC network executive, believes that network programming does not affect the size of the total television audience in a given time slot. Instead, he believes that a network's programming only determines the network's percentage share of the total audience. Does Regression 5 support Morgenstern's position? Explain.
7. Warrington believes that movies with stars tend to be shown in favorable time slots (e.g., good months, good days of the week, and following highly rated programs).
a. Are the regressions consistent with her beliefs? Explain.
b. Warrington is planning to add a fictional movie to the programming schedule. She must decide whether or not to use a star. What is the difference in expected ratings between using a star and not using a star?
8. The conventional industry wisdom is that fact-based movies have higher ratings than movies based on fictional stories. Do the regressions support or contradict this view?
For the exclusive use of A. Tuoyo, 2023.
This document is authorized for use only by Austin Tuoyo in GB513: Business Analytics_3_18_2024 taught by Christopher Osadczuk, Purdue University Global from Sep 2023 to Mar 2024.
Colonial Broadcasting Company 894-011
9
Colonial Broadcasting Company
Part B
Warrington could barely believe her ears: just minutes before, she had gotten a call from Harsanyi Electric, a leading international consumer electronics company. Harsanyi was willing to sponsor a CBC TV movie, paying CBC a fee of $7,500,000 for the 28 minutes of advertising. The only catch was that Harsanyi Electric wanted CBC to guarantee ratings of 19 points. For every point that CBC fell short of this target, Harsanyi would get a rebate of $1,000,000. If the rating exceeded 19, however, no additional fee would be paid. Fractional ratings would be pro-rated: for example, if the rating was 18.4, then Harsanyi would get a rebate of $600,000. Warrington was unsure of whether the risk was worth it: $7,500,000 was a lot of money, but 19 points was an aggressive target. If Warrington rejected Harsanyi's offer, then she could always get a fee of $5,000,000 with no risk.
For the questions below, assume it is impossible to predict the ratings for the competitor's programs.
9. Warrington wants to put the TV movie in the best possible slot so as to help ensure high ratings. She has 3 slots available:
APRIL, SUNDAY (following a show that typically receives a rating of 8.5) MARCH, MONDAY (following a show that typically receives a rating of 13.0) DECEMBER, SUNDAY (following a show that typically receives a rating of 8.5)
If Warrington wants to maximize the chance of high ratings, when should she schedule the TV movie?
10. Warrington is unsure of which TV movie to schedule. Due to the limited budget for a TV movie, CBC can choose either a fictional movie with a star or a fact-based movie without a star. Both movies are identical in all other respects. Assuming she wishes to maximize ratings, which movie should Warrington choose?
For the next two questions, assume that a normal distribution with mean m and standard deviation s, can be approximated with the following discrete 5-point distribution:
Probability Value
.20 m – 1.3s .20 m – 0.5s .20 m .20 m + 0.5s .20 m + 1.3s .
Thus, each point gets the same probability, .20.
11. Suppose that Warrington has scheduled a fact-based movie without a star for a Monday time slot in March (again, following a show that typically receives ratings of 13.0). Should Warrington accept Harsanyi Electric's offer or accept the fixed fee of $5,000,000?
12. Suppose that, prior to accepting or rejecting Harsanyi Electric's offer, Warrington could purchase a regression that would tell with virtual certainty what the Nielsen rating of the proposed movie would be. What is the most that Warrington would be willing to pay for such a regression?
For the exclusive use of A. Tuoyo, 2023.
This document is authorized for use only by Austin Tuoyo in GB513: Business Analytics_3_18_2024 taught by Christopher Osadczuk, Purdue University Global from Sep 2023 to Mar 2024.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.