Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

fQUESTION 13 [10 point: in total] One of the great unanswered questions in the entertainment industry is: What really makes a W show a hit?

image text in transcribedimage text in transcribed
\fQUESTION 13 [10 point: in total] One of the great unanswered questions in the entertainment industry is: "What really makes a W show a hit?\" In an attempt to shed some light on thisr data was collected on a random sample of television shows that ran in the US. in 2019. The data is available in the "Final.xlsx" Excel le. Use this data in the excel le and run a regression model as discussed below and answer the questions that follow. Email me your output Excel le. The variables are dened as: SetSpend: The amount in thousands of dollars per week, spent on the physical set where the show is taped: background, props, landscaping, lighljng, wardrobes, etc. EastSpend: The amount, in thousands of dollars per week, spent on salaries for the actors in the show. Revenue: Weekly revenues, in thousands of dollars, from advertising earned by that show. This is the dependent variable {Yvariable). Now, estimate Revenue as a function of the following 2 variables: Em and m. m. [1 points] What is die estimated intercept? n. [1 points] What is the estimated slope of SetSpend? o. [1 points] What is the p-value of the estimated slope of SetSpend? p. [1 points] What is die estimated slope of Cable? q. [1 points] What is die p-value of the estimated slope of Cable? r. [1 points] What is the Adjusted R2 of die model? s. [1 points] What is the standard error of estimates? t. [1 points] What is the p-value of the F-test? u. [2 points] Is the model useful? Give 2 reasons. Forthe tool bar, press ALT+F10{PC} orALT+FN+F1D{MacI

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics

Authors: Douglas Bernheim, Michael Whinston

2nd edition

73375853, 978-0073375854

Students also viewed these Mathematics questions

Question

List noteworthy changes that were implemented in DSM-5.

Answered: 1 week ago