A movie analyst wants to predict revenue ("revenue") in $millions using the length of the movie...
The following output may be used in several questions. A movie industry analyst is interested in predicting box office revenue revenue") in millions of dollars using the production budget ("budget"), also in millions of dollars. A simple linear regression model has been fit. The output is shown below, with some missing values indicated by shaded areas Regression Statlstics Multiple R 0.626 R Square 0.392 Adjusted R Square 0.387 Standard Error 49.458 Observations 120 ANOVA Signficance F df SS MS F...
The ACT is a standardized test that many high school students in the U.S. take in order to apply for college (the other major admissions test is the SAT). Scores on the ACT range from 1 to 36 in one point increments. The dean of a college of business is interested in examining the relationship between ACT scores and GPAs of students in the college. After taking a random sample of 141 students, he performs a regression analysis using Excel...
Online Trailer Views (millions)
Opening Weekend Box Office Gross ($millions)
55.111
34.124
9.416
6.181
7.71
5.578
5.895
23.917
83.065
102.533
32.862
62.143
24.105
19.96
5.005
9.721
4.986
11.059
45.03
34.715
10.232
20.686
25.461
17.497
2.238
3.926
55.386
149.481
4.512
9.113
11.469
12.88
11.472
2.08
1.666
1.816
0.792
0.4
3.985
4.444
3.476
1.652
10.421
1.069
33.085
99.151
1.386
3.904
5.535
9.989
6.637
13.392
55.098
46.803
4.953
3.993
28.861
15.018
4.282
5.937
11.836
9.929
60.033
44.189
82.933
176.137
4.346
7.222
33.811
61.791...
Question 1The owner of Showtime Movie Theaters, Inc. would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. (6 points) Weekly Gross Revenue Newspaper Advertising Advertising ($1000s) Televison ($1000s) (s1000s) 96 5.0 1.5 2.0 2.0 90 95 4.0 1.5 92 2.5 2.5 3.3 95 3.0 3.5 2.3 94 2.5 4.2 94 94 3.0 2.5 b. Develop an estimated regression equation with both television advertising and news- paper advertising...
A researcher wants to determine if the number of years of education that a person's father has ("paeduc") is related to the number of years of education that the person has ("educ"). He uses simple linear regression to examine this question. The output from Excel is shown below. Regression Statistics Multiple R 0.527393938 R Square 0.278144366 Adjusted R Square 0.264776669 Standard Error 2.436826202 Observations 56 ANOVA df F Significance F 2.96139E-05 20.8072 Regression Residual Total SS MS 123.555701 123.5557 320.6585847...
We want to look at potential predictors of movie revenues. Model 1: OLS, using observations l-609 Dependent variable: USGrossM coefficient std. error t-ratio p-value --------------------------------------- ------------------------ const -52.3692 15.4296 -3.394 0.0007 *** BudgetM 0.972348 0.0484576 20.07 4.89e-069 *** RunTimemin 0.387214 0.155146 2.496 0.0128 CriticScoreRotter 0.640257 0.0953758 6.713 4.40e-011 *** Mean dependent var Sum squared resid R-squared F(3, 605) Log-likelihood Schwarz criterion 75.81977 2004759 0.517227 216.0592 -3330.345 6686.337 S.D. dependent var S.E. of regression Adjusted R-squared P-value (F) Akaike criterion Hannan-Quinn...
Many movies are released each year and it would be interesting to be able to predict the Total Gross Revenues (in $1,000,000) from the box office based on a few predictors. The following predictors have been identified for 70 movies: BUDGET: Estimated budget in $1,000,000 LENGTH: The length of each movie in minutes SCREENS: Number of Screens on Opening Weekend AWARDS: Number of Award nominations of entire cast in their careers GENRE: Type of movie: Action, Comedy or Drama recoded...
(4 points) The marketing manager at Super Foods wants to develop a regression model to predict monthly sales per store of a power bar (in the number of power bars sold in a month) and to determine what variables influence the sales. Two variables are considered here: the price of the power bar, (in cents) and the monthly budget for the in-store promotional expenditures (in dollars). Data are collected from a sample of 20 stores in a supermarket chain and...
6. (textbook) An analyst fitted a regression model to predict city MPG using as predictors Length (of car in inches), Width (of car in inches) and Weight (of car in pounds). a. Intuitively, what association do you expect between the explanatory variables and MPG? b. Do you see anything of concern about these variables being used as explanatory variables? Explain S c. What does the matrix plot done in class show you? Explain d. Write the null and alternative hypothesis...
To be done on excel: Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1,312 Chicago Cubs 274 1,000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196 626 Kansas City Royals 169 457 Los Angeles Angels of Anaheim 239 718 Los Angeles Dodgers 245 1,615 Miami Marlins 195 520 Milwaukee...