What is the average rating for all CBC movies

Assignment Help Applied Statistics

Reference no: EM131939089

Case Analysis Assignment -

You will be analyzing the "Colonial Broadcasting" case in the coursepack. 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 after the end.

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. 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 tool pack 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 tothe 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.

Attachment:- Assignment File.rar

Reference no: EM131939089

Questions Cloud

Was fbps demonstrating social responsibility : What is your evaluation of the organizational culture and organizational climate at the time the decision to close two campuses was made?

Provide an overview of the server-side hardware and software : Focus the bulk of your essay on analyzing the competitive advantage that your information system provides to users of the system.

Examine the daily share price movement of each company : FIN201 - Examine the daily share price movement of each company in the 4-week period before and after its most recent change in dividend policy

Expected value and the variance of a chi-square : The expected value and the variance of a given chi-square distribution are equal.

What is the average rating for all CBC movies : You will be analyzing the "Colonial Broadcasting" case in the coursepack. What is the average rating for all CBC movies? How about ABN movies and BBS movies

Differences between all pairwise kickback averages : Use Tukey's procedure to place a set of simultaneous 95% confidence intervals on the differences between all pairwise kickback averages

Find the debt ratio if the company purchases the equipment : Find the Debt Ratio if the company PURCHASES the equipment and Find the Debt Ratio if the company LEASES the equipment

Standard error of the difference between two means : Given that t0.0042,16 = 3.0045, use the data in to compute the minimum significant difference between kickback averages when the Bonferroni procedure is used.

Calculate cranes direct materials price variance for month : The company actually used 3,950 pounds of the plastic to produce 15,600 dive masks. Calculate Crane's direct materials price variance for the month

Reviews

len1939089

4/12/2018 3:56:04 AM

I need help with descriptive statistics with excel as well as multiple regression on this project. To answer part 2, you will prepare a PowerPoint presentation to present your findings. Make sure you also submit the Excel file to show your work for Part 2. You will receive a reduction in points if you fail to include the Excel file showing your work for Part 2. 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.

4/12/2018 3:55:55 AM

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.

Write a Review

Required(*) Message

User Account

All Pages