# Question: Continuing Problems 6 and 15 on the 2006 2007 movie data

Continuing Problems 6 and 15 on the 2006–2007 movie data in the file P02_02.xlsx, create a new variable Total Revenue that is the sum of Total US Gross, International Gross, and US DVD Sales. How well can this new variable be predicted from the data in columns C–F? For Distributor, relabel the categories so that there are only two: Large Distributor and Small Distributor.

The former is any distributor that had at least 12 movies in this period, and the latter is all the rest. For Genre, relabel the categories to be Comedy, Drama, Adventure, Action, Thriller/Suspense, and Other. Interpret the coefficients of the estimated regression equation. How would you explain the results to someone in the movie business? Do you think that predictions of total revenue from this regression equation will be very accurate? Why?

The former is any distributor that had at least 12 movies in this period, and the latter is all the rest. For Genre, relabel the categories to be Comedy, Drama, Adventure, Action, Thriller/Suspense, and Other. Interpret the coefficients of the estimated regression equation. How would you explain the results to someone in the movie business? Do you think that predictions of total revenue from this regression equation will be very accurate? Why?

**View Solution:**## Answer to relevant Questions

Continuing Problem 18, suppose that the antique collector believes that the rate of increase of the auction price with the age of the item will be driven upward by a large number of bidders. How would you revise the multiple ...Management of a home appliance store would like to understand the growth pattern of the monthly sales of Blu-ray disc players over the past two years. Managers have recorded the relevant data in the file P10_09.xlsx.a. ...The file P10_48.xlsx contains monthly sales and price of a popular candy bar.a. Describe the type of relationship between price and sales (linear/nonlinear, strong/weak).b. What percentage of variation in monthly sales is ...The file P10_56.xlsx contains some interesting data on the U.S. presidential elections from 1880 through 2008. The variable definitions are on the Source sheet. The question is whether the Vote variable can be predicted very ...Suppose you run a regression on a data set of Xs and Ys and obtain a least squares line of Y = 12 - 3X.a. If you double each value of X, what is the new least squares line?b. If you triple each value of Y, what is the new ...Post your question