Answered step by step
Verified Expert Solution
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?
\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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started