Should the CBC hire stars for

Should the CBC hire stars for their movies? To answer thisquestion, run a hypothesis test to see if there is a significantdifference between the ratings of movies with stars versus movieswithout stars. Use the data for CBC movies only. Use 95%confidence. Answer the following: a. What are the null andalternative hypotheses (state in full sentences)? b. Run the testusing Excel and include the output table. Use a t-test assumingequal variances. c. What is your recommendation to the executives?Justify your answer referring to the relevant figures.

Network Rating Stars
CBC 14 1
CBC 11.3 0
CBC 12.4 1
CBC 12.9 0
CBC 13.2 0
CBC 12.8 0
CBC 12.4 1
CBC 13.2 1
CBC 17.5 0
CBC 11.6 0
CBC 12.1 0
CBC 15.6 0
CBC 12.1 1
CBC 11.8 0
CBC 12.3 0
CBC 14.2 1
CBC 11.6 0
CBC 13.3 0
CBC 13.6 0
CBC 12.4 1
CBC 13.8 0
CBC 11.9 0
CBC 14.6 0
CBC 15.8 1
CBC 15.4 1
CBC 12.8 1
CBC 12.8 0
CBC 15.1 0
CBC 11.4 1
CBC 19.1 0


a) The hypothesis are:

H0 : i.e. there is no difference between the ratings of movies withstars versus movies without stars.

H1 : i.e.there is significant difference between the ratings of movieswith stars versus movies without stars.

b) Answering the excel portion:

Data in excel is :

Go under Data->Data Analytics and select the followingtest:

Use following parameters:

You will get an output like this:

c)The t statistic calculated is 0.338 which is less than thecritical value of t by a good margin ( two tailed critical value oft =2.048). So we would basically accept the null hypothesis andconclude that there is no difference between the ratings of movieswith stars versus movies without stars. Recommendation to theexecutives is that they should focus on not hiring stars, and focusthat part of the budget instead in the development of the film,creating meaningful cinema using more money in their pockets.Content superseeds stardom any day.

Please upvote. Thanks

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.