User Account

All Pages

Create a line graph of the monthly average ratings

Assignment Help Finance Basics
Reference no: EM131500398

Problem -

Analyzing the "Colonial Broadcasting" case. Begin by reading the description in the case. Then, answer the questions listed below, NOT the questions listed in the case.

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. Therefore, make sure your presentation is professional and provides sufficient explanation.

1. Answer the following questions:

a. What is the average rating for all CBC movies? How about ABN movies and BBS movies?

b. Include a table that shows the average and the other descriptive statistics (using the data analysis toolpack in Excel) for the ratings of the three networks (one column for each network). Explain what you learn from each of the metrics in the table.

c. Comment on which network is doing best.

2. 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 first, 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. 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 versus movies without stars. Use the data for CBC movies only. Use 95% confidence. Answer the following: 

a. What are the null and alternative hypotheses (state in full sentences)?

b. Run the test using Excel and include the output table. Use a t-test assuming equal variances.

c. What is your recommendation to the executives? Justify your answer referring to the relevant figures.

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

a. Which has more impact on a movie's rating: Being fact-based or having one star? How much does each of these factors change the ratings?

b. How well does this regression analysis explain the ratings? Justify your answers referring to the relevant figures.

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

Attachment:- Assignment Files.rar

Verified Expert

The assignment contains two parts. One is the document in which the case study has to be solved using the Microsoft Excel. The other one is the power-point presentation based on the questions of the case study. There are total four questions. The questions includes the concept of descriptive statistics, Anova test, t test and trend forecasting. The trend chart is also used with the trend line.

Reference no: EM131500398

Questions Cloud

Bond dealer purchased the bonds with a yield to maturity : A bond dealer purchased the following bonds with a yield to maturity of 8 %. Afterwards, yield fell to 7%.
Prove the both startegies are simultaneously optimal : Use the result of problem to describe all optimal strategies for Morra.
Effectiveness of an airline organization : In this research paper, you will research information on the effectiveness of an airline organization's maintenance and engineering.
Issues about the sociology of media : Provide an opportunity to synthesize many of the issues about the sociology of media discussed throughout the modules .
Create a line graph of the monthly average ratings : Create a line graph of the monthly average ratings for CBC for the year. Note that there are multiple ratings data for the months
Can you articulate a legal claim against pennys plastic : Is Mr. Santos, as an undocumented alien, entitled to collect back pay remedy? Can you articulate a legal claim against Penny's Plastic?
Perspectives of operations management : This week, you will look at the element of design applied to operations management via product design and service design.
What is effective annual rate for higher yielding security : What is the effective annual rate (EAR) for the higher yielding security?
Discuss the positive and negative sides of moral relativism : Discuss the positive and negative sides of moral relativism. Do you agree with Ruth Benedict who argues that ethical relativism is necessary in modern world?

Reviews

len1500398

5/18/2017 5:33:13 AM

Subject: Basic Finance. This is your final. 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. You will receive a 100-point deduction 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 linked from the spreadsheet icon in the course. Make sure to use that file.

len1500398

5/18/2017 5:33:06 AM

For your final, you will be analyzing the “Colonial Broadcasting” case. Begin by reading the description in the case. Then, answer the questions listed below, NOT the questions listed in the case. Ignore verything in the case after the end of page 4. Correct table showing the average and other descriptive statistics for the ratings of the three networks, using one column for each network. Correct line graph using the calculated average monthly ratings of CBC for the year, showing r-squared and the formula. Correct null and alternative hypotheses stated in full sentences. Appropriate explanation on what has more impact on a movie’s rating: Whether the movie includes a star or whether it is fact-based.

Write a Review

Finance Basics Questions & Answers

  Computation of the price of the forward contract

Computation of the price of the forward contract and position and what are the forward price and the value of the short position in the forward contract

  What is the bond worth today

Wilson owns a bond with a coupon of 6%. He bought it when the current yield was 7%. The current yield is now 5%. How much did he pay for the bond? What is the bond worth today? If he sold it what would his gain or loss be?

  What is the value of a perpetuity with an annual payment

What is the value of a perpetuity with an annual payment of $50 and a discount rate of 4%?

  Although a promising two-year project had returned 22 in

although a promising two-year project had returned 22 in its first year overall it lost half of its value. what was

  Cllaghan motors bonds have 16 years remaining to maturity

callaghan motors bonds have 16 years remaining to maturity. interest is paid annually they have a 1000 par value the

  Sinking store tables demonstrate

Sinking store tables demonstrates that Re. 0.296349 contributed every year will create Re.1 toward the end of 3 years at 12% for every annum. The ventures are sold for Rs. 28,500.

  Definitions for strengths-weaknesses-opportunities

Prepare, in a table format, a SWOTT analysis on any real company in the auto industry. As you prepare your analysis, it must be based on the following definitions for strengths, weaknesses, opportunities, threats, and trends.

  How much money will you receive

Eighteen months later, you decide to go to the Rocky Mountains to become a ski instructor rather than continue in school, so you close out your account. How much money will you receive?

  Explain the premium for taking on risk

Shortcomings of the dividend pricing models suggest that we need a pricing model that is more inclusive than the dividend models and that provides expected returns for companies based on aspects besides their historical dividend patterns.

  Determine the market return for an investment

Determine the market return for an investment with a required rate of return of 15%, a Beta of 1.10 and the risk free rate is 4 percent?

  Find realization principle as desirable accounting principle

The realization principle, which recognizes revenues at point of sale, is said to be an accounting principle that improves the quality of reporting.

  Explain which method of inquiry you are using here

Suppose that, after reading about a recent murder in your town, you want to learn more about what causes people to kill.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd