How well does this regression analysis explain the ratings

Assignment Help Basic Statistics

Reference no: EM133411744

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

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

Provide Excel steps and explaination.

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

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

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

Reference no: EM133411744

Questions Cloud

Determine if the netflix shows differed in quality : determine if the Netflix shows differed in quality. What type of analysis should they use

Which step of the cp production process is the bottleneck : How many workers does Elizabeth have and what does each of them do? What type of work does Elizabeth do for the CP product line? How long does it take

What is an advantage of having a specialized structure : Lysosomes are used for digestion in eukaryotes. What is an advantage of having a specialized structure for this purpose?

Identifying the organisms : Should microbes just use the classical biochemical approach to identifying organisms? Maybe all of the organisms should be reclassified based on genetic informa

How well does this regression analysis explain the ratings : How well does this regression analysis explain the ratings? Should the executives count on the results from this analysis? Justify your answers referring

What is customer benefit package : What is Customer Benefit Package? What is primary goods and services? What is peripheral goods and services? What is Variant?

The sixth principle of finance is reputation matters : The sixth principle of finance is reputation matters. The unethical behavior of corporate leaders has been well documented and publicized in previous years.

Company investment banker in connection : what is the purpose of issuing investors a prospectus and what are the responsibilities do you have as a company's investment banker in connection

How the feedback was delivered : how the feedback was delivered (either by you or by another person to you, depending on which option you chose above) AND discuss either

User Account

All Pages