Question

In: Statistics and Probability

A motion picture industry analyst is studying movies based on epic novels. The following data were...

A motion picture industry analyst is studying movies based on epic novels. The following data were obtained for 10 Hollywood movies made in the past five years. Each movie was based on an epic novel. For these data, x1 = first-year box office receipts of the movie, x2 = total production costs of the movie, x3 = total promotional costs of the movie, and x4 = total book sales prior to movie release. All units are in millions of dollars.

x1 x2 x3 x4
85.1 8.5 5.1 4.7
106.3 12.9 5.8 8.8
50.2 5.2 2.1 15.1
130.6 10.7 8.4 12.2
54.8 3.1 2.9 10.6
30.3 3.5 1.2 3.5
79.4 9.2 3.7 9.7
91.0 9.0 7.6 5.9
135.4 15.1 7.7 20.8
89.3 10.2 4.5 7.9

(a) Generate summary statistics, including the mean and standard deviation of each variable. Compute the coefficient of variation for each variable. (Use 2 decimal places.)

x s CV
x1 %
x2 %
x3 %
x4 %

Relative to its mean, which variable has the largest spread of data values?

x3

x1     

x4

x2


Why would a variable with a large coefficient of variation be expected to change a lot relative to its average value? Although x1 has the largest standard deviation, it has the smallest coefficient of variation. How does the mean of x1 help explain this?

A variable with a large CV has large s relative to x. Here, x1 has a small CV because we divide by a large mean.

A variable with a large CV has small s relative to x. Here, x1 has a small CV because we divide by a large mean.    

A variable with a large CV has small s relative to x. Here, x1 has a small CV because we divide by a small mean.

A variable with a large CV has large s relative to x. Here, x1 has a small CV because we divide by a small mean.



(b) For each pair of variables, generate the correlation coefficient r. Compute the corresponding coefficient of determination r2. (Use 3 decimal places.)

r r2
x1, x2
x1, x3
x1, x4
x2, x3
x2, x4
x3, x4

Which of the three variables x2, x3, and x4 has the least influence on box office receipts?

x3

x2     

x4



What percent of the variation in box office receipts can be attributed to the corresponding variation in production costs? (Use 1 decimal place.)
%

(c) Perform a regression analysis with x1 as the response variable. Use x2, x3, and x4 as explanatory variables. Look at the coefficient of multiple determination. What percentage of the variation in x1 can be explained by the corresponding variations in x2, x3, and x4 taken together? (Use 1 decimal place.)
%

(d) Write out the regression equation. (Use 2 decimal places.)

x1 = +  x2 +  x3 +  x4

Explain how each coefficient can be thought of as a slope.

If we hold all explanatory variables as fixed constants, the intercept can be thought of as a "slope."If we look at all coefficients together, each one can be thought of as a "slope."     If we hold all other explanatory variables as fixed constants, then we can look at one coefficient as a "slope."If we look at all coefficients together, the sum of them can be thought of as the overall "slope" of the regression line.



If x2 (production costs) and x4 (book sales) were held fixed but x3 (promotional costs) were increased by 0.7 million dollars, what would you expect for the corresponding change in x1 (box office receipts)? (Use 2 decimal places.)


(e) Test each coefficient in the regression equation to determine if it is zero or not zero. Use level of significance 5%. (Use 2 decimal places for t and 3 decimal places for the P-value.)

t P-value
β2
β3
β4

Conclusion

Reject the null for β2 and β3. Fail to reject the null for β4.

Reject the null for all tests.     

Reject the null for β2 and β4. Fail to reject the null for β3.

Reject the null for β3 and β4. Fail to reject the null for β2.


Explain why book sales x4 probably are not contributing much information in the regression model to forecast box office receipts x1.

From the previous tests, we can conclude that the coefficient for x4 is different than 0. Thus it belongs in the model.

From the previous tests, we can conclude that the coefficient for x4 is not different than 0. Thus it does not belong in the model.     

From the previous tests, we can conclude that the coefficient for x4 is not different than 0. Thus it belongs in the model.

From the previous tests, we can conclude that the coefficient for x4 is different than 0. Thus it does not belong in the model.



(f) Find a 90% confidence interval for each coefficient. (Use 2 decimal places.)

lower limit upper limit
β2
β3
β4


(g) Suppose a new movie (based on an epic novel) has just been released. Production costs were x2 = 11.4 million; promotion costs were x3 = 4.7 million; book sales were x4 = 8.1 million. Make a prediction for x1 = first-year box office receipts and find an 85% confidence interval for your prediction (if your software supports prediction intervals). (Use 1 decimal place.)

prediction
lower limit
upper limit


(h) Construct a new regression model with x3 as the response variable and x1, x2, and x4 as explanatory variables. (Use 2 decimal places.)

x3 = +  x1 +  x2 +  x4


Suppose Hollywood is planning a new epic movie with projected box office sales x1 = 100 million and production costs x2 = 12 million. The book on which the movie is based had sales of x4 = 9.2 million. Forecast the dollar amount (in millions) that should be budgeted for promotion costs x3 and find an 80% confidence interval for your prediction.

prediction
lower limit
upper limit

Solutions

Expert Solution


Related Solutions

A motion picture industry analyst is studying movies based on epic novels. The following data were...
A motion picture industry analyst is studying movies based on epic novels. The following data were obtained for 10 Hollywood movies made in the past five years. Each movie was based on an epic novel. For these data, x1 = first-year box office receipts of the movie, x2 = total production costs of the movie, x3 = total promotional costs of the movie, and x4 = total book sales prior to movie release. All units are in millions of dollars....
A motion picture industry analyst is studying movies based on epic novels. The following data were...
A motion picture industry analyst is studying movies based on epic novels. The following data were obtained for 10 Hollywood movies made in the past five years. Each movie was based on an epic novel. For these data, x1 = first-year box office receipts of the movie, x2 = total production costs of the movie, x3 = total promotional costs of the movie, and x4 = total book sales prior to movie release. All units are in millions of dollars....
The motion Picture Industry is a competitive business. More than 50 studios produce a total of...
The motion Picture Industry is a competitive business. More than 50 studios produce a total of 300 to 400 new motion pictures each year, and financial success of each motion picture varies considerably. The opening weekend gross sales ($millions), the total gross sales ($millions), the number of theaters the movie was shown in, and the number of weeks the motion picture was in the top 60 for gross sales are common variables used to measure the success of a motion...
The motion picture industry is a competitive business. More than 50 studios produce a total of...
The motion picture industry is a competitive business. More than 50 studios produce a total of 300 to 400 new motion pictures each year, and the financial success of each motion picture varies considerably. Gross sales for the opening weekend, the total gross sales, the number of theaters the movie was shown in, and the number of weeks the motion picture was open are common variables used to measure the success of a motion picture. Data collected for a sample...
The motion picture industry is a competitive business. More than 50 studios produce a total of...
The motion picture industry is a competitive business. More than 50 studios produce a total of 300 to 400 new motion pictures each year, and the financial success of each motion picture varies considerably. Gross sales for the opening weekend, the total gross sales, the number of theaters the movie was shown in, and the number of weeks the motion picture was open are common variables used to measure the success of a motion picture. Data collected for a sample...
In EXCEL: The motion picture industry is a competitive business. More than 60 studios produce a...
In EXCEL: The motion picture industry is a competitive business. More than 60 studios produce a total of 300 to 400 new motion pictures each year, and the financial success of each motion picture varies considerably. The opening weekend gross sales ($ millions) are often used to predict the success of a motion picture. Data collected for a sample of 30 motion pictures is shown below. Round and label your answers properly! Opening Weekend Gross Sales        ($ millions) Total Gross...
Case Study 2: Forecasting Box Office Returns For years, people in the motion picture industry –...
Case Study 2: Forecasting Box Office Returns For years, people in the motion picture industry – critics, film historians, and others – have eagerly awaited the second issue in January of Variety. Long considered the show business bible, Variety is a weekly trade newspaper that reports on all aspects of the entertainment industry; movies, television, recordings, concert tours, and so on. The second issue in January, called the Anniversary Edition, summarizes how the entertainment industry fared in the previous year,...
The motion picture industry is a competitive business. More than 50 studios produce several hundred new...
The motion picture industry is a competitive business. More than 50 studios produce several hundred new motion pictures each year, and the financial success of the motion pictures varies considerably. The opening weekend gross sales, the total gross sales ($ millions), the total gross sales ($millions), the number of theaters the movie was shown in, and the number of weeks the motion picture was in release are common variables used to measure the success of a movie. Data on the...
he motion picture industry is a competitive business. More than 50 studios produce several hundred new...
he motion picture industry is a competitive business. More than 50 studios produce several hundred new motion pictures each year, and the financial success of the motion pictures varies considerably. The opening weekend gross sales, the total gross sales, the number of theaters the movie was shown in, and the number of weeks the motion picture was in release are common variables used to measure the success of a motion picture. Data on the top 100 grossing motion pictures released...
In studying the occurrence of genetic characteristics, the following sample data were obtained. You would like...
In studying the occurrence of genetic characteristics, the following sample data were obtained. You would like to test the claim that the characteristics occur with the same frequency at the 0.05 significance level. What is value of the test statistic? Characteristic | Frequency A|28 B|30 C|45 D|48 E|39 F|39
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT