The motion picture industry is an extremely competitive business. Dozens of movie studios produce hundreds of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The motion picture industry is an extremely competitive business. Dozens of movie studios produce hundreds of movies each year, many of which cost hundreds of millions of dollars to produce and distribute. Some of these movies will go on to cam hundreds of millions of dollars in box office revenues, while others will earn much less than their production cost. Data from 50 of the top box-office-receipt-generating movies are provided in the file Top5OMovies. The following table shows the first 10 movies contained in this data set. The categorical variables included in the data set for each movie are the rating and genre. Quantitative variables for the movie's release year, inflation- and noninflation-adjusted box-office receipts in the United States, budget, and the world box-office receipts are also included. U.S. Box- Office Receipts World U.S. Box- Office Receipts (inflation- adjusted Released millions $) Rating Genre Box-Office Receipts (noninflation- (noninflation- (noninflation- adjusted millions S) Budget adjusted millions $) adjusted millions S) Year Title 1,650 Drama 3 391 199 Gone with the Wind 1939 Star Wars 1977 1,426 PG Scifi/fantasy 11 798 461 The Sound of 1965 1,145 Musical 163 163 Music E.T. 1,132 PG Scifi/fantasy 757 435 1982 1997 1,096 PG-13 Drama 200 2,185 659 Titanic 1956 1,053 G Drama 14 80 B0 The Ten Commandments 1975 1,029 PG Action 12 471 260 Jaws 973 PG-13 Drama 11 112 112 Doctor Zhivago 1965 871 G Animated 206 142 The Jungle Book 1967 Animated 185 185 Snow White and 1937 854 the Seven Dwarfs 1939 1,650 Drama 3. 391 1977 1,426 PG 11 798 461 Scifi/fantasy 163 163 1965 1,145 Musical 757 435 1982 1,132 PG Scifi/fantasy 1997 1,096 PG-13 Drama 200 2,185 659 1956 1,053 G Drama 14 80 80 12 471 260 1975 1,029 PG Action 1965 973 PG-13 Drama 11 112 112 206 142 1967 871 G Animated 185 185 1937 854 Animated Managerial Report Use the data-visualization methods presented in this chapter to explore these data and discover relationships between the variables. Include the following in your report: 1. Create a scatter chart to examine the relationship between the year released and the inflation-adjusted U.S. box office receipts. Include a trendline for this scatter chart. What does the scatter chart indicate about inflation-adjusted U.S. box office receipts over time for these top 50 movies? 2. Create a scatter chart to examine the relationship between the budget and the noninflation-adjusted world box office receipts. (Note: You may have to adjust the data in Excel to ignore the missing budget data values to create your scatter chart. The motion picture industry is an extremely competitive business. Dozens of movie studios produce hundreds of movies each year, many of which cost hundreds of millions of dollars to produce and distribute. Some of these movies will go on to cam hundreds of millions of dollars in box office revenues, while others will earn much less than their production cost. Data from 50 of the top box-office-receipt-generating movies are provided in the file Top5OMovies. The following table shows the first 10 movies contained in this data set. The categorical variables included in the data set for each movie are the rating and genre. Quantitative variables for the movie's release year, inflation- and noninflation-adjusted box-office receipts in the United States, budget, and the world box-office receipts are also included. U.S. Box- Office Receipts World U.S. Box- Office Receipts (inflation- adjusted Released millions $) Rating Genre Box-Office Receipts (noninflation- (noninflation- (noninflation- adjusted millions S) Budget adjusted millions $) adjusted millions S) Year Title 1,650 Drama 3 391 199 Gone with the Wind 1939 Star Wars 1977 1,426 PG Scifi/fantasy 11 798 461 The Sound of 1965 1,145 Musical 163 163 Music E.T. 1,132 PG Scifi/fantasy 757 435 1982 1997 1,096 PG-13 Drama 200 2,185 659 Titanic 1956 1,053 G Drama 14 80 B0 The Ten Commandments 1975 1,029 PG Action 12 471 260 Jaws 973 PG-13 Drama 11 112 112 Doctor Zhivago 1965 871 G Animated 206 142 The Jungle Book 1967 Animated 185 185 Snow White and 1937 854 the Seven Dwarfs 1939 1,650 Drama 3. 391 1977 1,426 PG 11 798 461 Scifi/fantasy 163 163 1965 1,145 Musical 757 435 1982 1,132 PG Scifi/fantasy 1997 1,096 PG-13 Drama 200 2,185 659 1956 1,053 G Drama 14 80 80 12 471 260 1975 1,029 PG Action 1965 973 PG-13 Drama 11 112 112 206 142 1967 871 G Animated 185 185 1937 854 Animated Managerial Report Use the data-visualization methods presented in this chapter to explore these data and discover relationships between the variables. Include the following in your report: 1. Create a scatter chart to examine the relationship between the year released and the inflation-adjusted U.S. box office receipts. Include a trendline for this scatter chart. What does the scatter chart indicate about inflation-adjusted U.S. box office receipts over time for these top 50 movies? 2. Create a scatter chart to examine the relationship between the budget and the noninflation-adjusted world box office receipts. (Note: You may have to adjust the data in Excel to ignore the missing budget data values to create your scatter chart.
Expert Answer:
Related Book For
Essentials of Modern Business Statistics with Microsoft Excel
ISBN: 978-0840062383
5th edition
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Posted Date:
Students also viewed these accounting questions
-
Use the data visualization methods presented in this chapter to explore these data and discover relationships between the variables. Include the following, in your report: 1. Create a scatter chart...
-
The motion picture industry has undergone significant changes since the 1960s. Originally, companies such as Paramount Pictures had to rely solely on domestic and foreign screenings of their movies...
-
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...
-
Two moles of an ideal monatomic gas go through the cycle abc. For the complete cycle, 800 J of heat flows out of the gas. Process ab is at constant pressure, and process bc is at constant volume....
-
Provincial governments across Canada have had to re-examine their delivery of services, such as health care, to avoid expensive duplication, and yet provide fair access to their citizens. The...
-
a. What are the advantages and disadvantages of conventional budgeting versus zero-based budgeting? b. What organizational characteristics create likely candidates for zero-based budgeting?
-
Fantastic Sams and Defendants PSTEVO, LLC and Jeremy Baker entered into a franchise agreement pursuant to which Fantastic Sams granted PSTEVO a franchise to operate a Fantastic Sams Salon. According...
-
Liang Company began operations on January 1, 2012. During its first two years, the company completed a number of transactions involving sales on credit, accounts receivable collections, and bad...
-
Joe is 25 and has a wage of $30,000. He is single with no dependents, and files as single. He rents and makes no contributions to charity. He contributed $800 to a Roth IRA in 2022. What is his Total...
-
Holman Electronics manufactures audio equipment, selling it through various distributors. Holmans days sales outstanding (Accounts receivable/Average daily credit sales) figures increased steadily in...
-
Assuming the role of a graduate auditor, you will be completing the audit work relating to the confirmation of accounts receivable for Instrumair Limited. You should note the senior on the audit has...
-
Two blocks of masses m = 13,7 kg and m = 9, 4 kg are connected by a rope that hangs over a pulley as shown in the figure. The pulley is a uniform disk of radius R = 0,5 m and the mass M = 8,9 kg. The...
-
Examine the following table of values of a quadratic function f. X -5 -4 -3 -2 -1 0 f(x) -6 -3 -2 -3 -6 -11 a. What is the equation of the axis of symmetry of the associated parabola? Justify your...
-
The current in a 150 resistor is i = 10e-2tu(t) A. What is the energy dissipated in the resistor associated with the frequency band 0 w 23 rad/s? Hint1. Parseval's theorem states that the energy of...
-
The function Y is defined as Y + k. Based on the table shown, what is the value of k? k XO-2345 VROLONG 0 1 Y 15 10 7 6 7 10 Y VAWANNN 12
-
If f(x) = 6 + Find '(1). Find (x). Find f"(1). 7 X + 2 2 find f'(x). > O
-
Advertising Examine the following ad and answer the questions below: https://www.youtube.com/watch?v=mls_7WXZHP4 ( SYNERGY Raw Kombucha - Begin Within GT's Living Foods) 1. What is the key message?...
-
Calculate I, , and a for a 0.0175 m solution of Na 3 PO 4 at 298 K. Assume complete dissociation. How confident are you that your calculated results will agree with experimental results?
-
Out-of-state tuition and fees at the top graduate schools of business can be very expensive. However, the starting salary and bonus paid to graduates from many of these schools can be very high. The...
-
In exercise 9, an estimated regression equation was developed relating the top speed for a boat to the boat's beam and horsepower rating. a. Compute and interpret R 2 and R 2 a . b. Does the...
-
Consider the following frequency distribution. Class..........................Frequency 10-19...................................10 20-29...................................14...
-
Explain why the business objectives of owners and managers are likely to diverge. How might owners attempt to ensure that managers act in their interests and not in the managers own interests?
-
1. In what ways did the defence industries respond to the ending of the Cold War? 2. Using an Internet search, find out how the defence and security industries have responded to the threat of...
-
What is the Standard Industrial Classification (SIC)? In what ways might such a classification system be useful? Can you think of any limitations or problems such a system might have over time?
Study smarter with the SolutionInn App