The motion picture industry is a competitive business. More than 50 studios prod

Question

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 of 100 motion pictures produced in 20XX are contained in the file named Movies, linked at the bottom of the page. Use all 100 data points.

Managerial Report
Prepare a report (see below) using the numerical methods of descriptive statistics presented in this module to learn how each of the variables contributes to the success of a motion picture. Be sure to include the following three (3) items in your report.

Descriptive statistics (mean, median, range, and standard deviation) for each of the four variables along with an explanation of what the descriptive statistics tell us about the motion picture industry.

Use the z-score to determine which movies, if any, should be considered high-performance outliers in each of the four variables. If there are any outliers in any category, please list them and state for which category they are an outlier. Describe which method you used to make your determination.

Descriptive statistics (correlation coefficient) showing the relationship between total gross sales and each of the other three variables. Evaluate the relationships between total gross sales and each of the other three variables. Use tables, charts, graphs, or visual dashboards to support your conclusions.

Rank Movie Title Opening Gross Total Gross Theaters Weeks 1 The Dark Knight 158,411,483 533,345,358 4,366 33 2 Iron Man 98,618,668 318,412,101 4,154 22 3 Indiana Jones and the Kingdom of the Crystal Skull 100,137,835 317,101,119 4,264 21 4 Hancock 62,603,879 227,946,274 3,965 10 5 WALL-E 63,087,526 223,808,164 3,992 28 6 Kung Fu Panda 60,239,130 215,434,591 4,136 18 7 Twilight 69,637,740 192,769,854 3,649 19 8 Madagascar: Escape 2 Africa 63,106,589 180,010,950 4,065 16 9 Quantum of Solace 67,528,882 168,368,427 3,501 10 10 Dr. Seuss' Horton Hears a Who! 45,012,998 154,529,439 3,961 25 11 Sex and the City 57,038,404 152,647,258 3,325 16 12 Gran Torino 271,720 148,095,302 3,045 27 13 Mamma Mia! 27,751,240 144,130,063 3,194 16 14 Marley and Me 36,357,586 143,153,751 3,505 18 15 The Chronicles of Narnia: Prince Caspian 55,034,805 141,621,490 3,929 16 16 Slumdog Millionaire 360,018 141,319,928 2,943 28 17 The Incredible Hulk 55,414,050 134,806,913 3,508 12 18 Wanted 50,927,085 134,508,551 3,185 12 19 Get Smart 38,683,480 130,319,208 3,915 20 20 The Curious Case of Benjamin Button 26,853,816 127,509,326 2,988 17 21 Four Christmases 31,069,826 120,146,040 3,540 11 22 Bolt 26,223,128 114,053,579 3,654 13 23 Tropic Thunder 25,812,796 110,515,313 3,473 13 24 Bedtime Stories 27,450,296 110,101,975 3,684 11 25 The Mummy: Tomb of the Dragon Emperor 40,457,770 102,491,776 3,778 8 26 Journey to the Center of the Earth 21,018,141 101,704,370 2,830 22 27 Eagle Eye 29,150,721 101,440,743 3,614 15 28 Step Brothers 30,940,732 100,468,793 3,182 8 29 You Don't Mess with the Zohan 38,531,374 100,018,837 3,466 13 30 Yes Man 18,262,471 97,690,976 3,434 15 31 10,000 B.C. 35,867,488 94,784,201 3,454 15 32 Beverly Hills Chihuahua 29,300,465 94,514,402 3,239 18 33 High School Musical 3: Senior Year 42,030,184 90,559,416 3,626 15 34 Pineapple Express 23,245,025 87,341,380 3,072 8 35 Valkyrie 21,027,007 83,077,833 2,838 16 36 21 24,105,943 81,159,365 2,952 7 37 What Happens in Vegas 20,172,474 80,277,646 3,255 19 38 Jumper 27,354,808 80,172,128 3,430 21 39 Cloverfield 40,058,229 80,048,433 3,411 12 40 The Day the Earth Stood Still (2008) 30,480,153 79,366,978 3,560 16 41 27 Dresses 23,007,725 76,808,654 3,074 19 42 Hellboy II: The Golden Army 34,539,115 75,986,503 3,212 10 43 Vantage Point 22,874,936 72,266,306 3,163 9 44 The Spiderwick Chronicles 19,004,058 71,195,053 3,847 12 45 Fool's Gold 21,589,295 70,231,041 3,125 16 46 Seven Pounds 14,851,136 69,951,824 2,758 5 47 Role Models 19,167,085 67,294,270 2,798 12 48 Hannah Montana/Miley Cyrus: Best of Both Worlds Concert Tour 31,117,834 65,281,781 687 15 49 The Happening 30,517,109 64,506,874 2,986 14 50 Forgetting Sarah Marshall 17,725,330 63,172,463 2,872 12 51 Baby Mama 17,407,110 60,494,212 2,627 13 52 Burn After Reading 19,128,001 60,355,347 2,657 15 53 Step Up 2 the Streets 18,908,826 58,017,783 2,528 14 54 Saw V 30,053,954 56,746,769 3,084 7 55 The Strangers 20,997,985 52,597,610 2,477 8 56 The Forbidden Kingdom 21,401,121 52,075,270 3,151 9 57 The Tale of Despereaux 10,103,675 50,877,145 3,107 11 58 Australia 14,800,723 49,554,002 2,721 17 59 The House Bunny 14,533,702 48,237,389 2,763 7 60 Nim's Island 13,210,579 48,006,762 3,518 21 61 Made of Honor 14,756,850 46,012,734 2,816 8 62 College Road Trip 13,601,419 45,610,425 2,706 21 63 The Sisterhood of the Traveling Pants 2 10,678,430 44,089,964 2,714 14 64 Speed Racer 18,561,337 43,945,766 3,606 13 65 Prom Night (2008) 20,804,941 43,869,350 2,821 7 66 Rambo 18,203,876 42,754,105 2,764 9 67 Welcome Home Roscoe Jenkins 16,207,730 42,436,517 2,387 8 68 Tyler Perry's Meet the Browns 20,082,809 41,975,388 2,016 7 69 Nights in Rodanthe 13,418,454 41,850,659 2,704 16 70 Max Payne 17,639,849 40,689,393 3,381 13 71 Righteous Kill 16,288,361 40,081,410 3,152 15 72 Body of Lies 12,884,416 39,394,666 2,714 14 73 Lakeview Terrace 15,004,672 39,263,506 2,574 6 74 Meet the Spartans 18,505,530 38,233,676 2,643 14 75 Harold and Kumar Escape from Guantanamo Bay 14,908,404 38,108,728 2,545 12 76 First Sunday 17,714,821 37,931,869 2,213 6 77 The Secret Life of Bees 10,527,799 37,770,162 1,630 19 78 Tyler Perry's The Family That Preys 17,381,218 37,105,289 2,070 6 79 Death Race 12,621,090 36,316,032 2,586 8 80 Changeling 489,015 35,739,802 1,896 11 81 Star Wars: The Clone Wars 14,611,273 35,161,554 3,452 13 82 The Reader 168,051 34,194,407 1,203 22 83 Semi-Pro 15,075,114 33,479,698 3,121 9 84 Fireproof 6,836,036 33,456,317 905 18 85 Doubt 507,226 33,446,470 1,287 17 86 Drillbit Taylor 10,309,986 32,862,104 3,061 13 87 Definitely, Maybe 9,764,270 32,241,649 2,220 8 88 The Love Guru 13,907,130 32,235,793 3,012 10 89 Milk 1,453,844 31,841,299 882 20 90 Transporter 3 12,063,452 31,715,062 2,626 5 91 Quarantine 14,211,321 31,691,811 2,463 5 92 Nick and Norah's Infinite Playlist 11,311,751 31,487,293 2,421 6 93 Zack and Miri Make a Porno 10,065,630 31,457,946 2,735 13 94 The Eye 12,425,776 31,418,697 2,470 10 95 Leatherheads 12,682,595 31,373,938 2,798 9 96 Mirrors 11,161,074 30,691,439 2,664 14 97 Space Chimps 7,181,374 30,105,968 2,538 18 98 The Bank Job 5,935,256 30,060,660 1,613 13 99 Untraceable 11,354,069 28,687,835 2,368 6 100 Defiance 123,513 28,644,813 1,793 17

Explanation / Answer

Descriptive statistics (mean, median, range, and standard deviation) for each of the four variables along with an explanation of what the descriptive statistics tell us about the motion picture industry.

answer ( using minitab software)

Variable Mean StDev Median Range
Opening Gross 26160050 23349183 19066030 158287970
Total Gross 85228635 74058662 61833338 504700545
Theaters 2958.1 734.7 3028.5 3679.0
Weeks 13.790 5.622 13.000 28.000

here the average due to total gross is much higher than the openning gross as a result sd and range also high here.

it is apperar that more or less 3000 theaters and 13 weeks a cinemas goes on

z score

opening geoss     Total Gross   Theaters   Weeks

   
5.66   6.05   1.92   3.42
3.10   3.15   1.63   1.46
3.17   3.13   1.78   1.28
1.56   1.93   1.37   -0.67
1.58   1.87   1.41   2.53
1.46   1.76   1.60   0.75
1.86   1.45   0.94   0.93
1.58   1.28   1.51   0.39
1.77   1.12   0.74   -0.67
0.81   0.94   1.37   1.99
1.32   0.91   0.50   0.39
-1.11   0.85   0.12   2.35
0.07   0.80   0.32   0.39
0.44   0.78   0.74   0.75
1.24   0.76   1.32   0.39
-1.10   0.76   -0.02   2.53
1.25   0.67   0.75   -0.32
1.06   0.67   0.31   -0.32
0.54   0.61   1.30   1.10
0.03   0.57   0.04   0.57
0.21   0.47   0.79   -0.50
0.00   0.39   0.95   -0.14
-0.01   0.34   0.70   -0.14
0.06   0.34   0.99   -0.50
0.61   0.23   1.12   -1.03
-0.22   0.22   -0.17   1.46
0.13   0.22   0.89   0.22
0.20   0.21   0.30   -1.03
0.53   0.20   0.69   -0.14
-0.34   0.17   0.65   0.22
0.42   0.13   0.67   0.22
0.13   0.13   0.38   0.75
0.68   0.07   0.91   0.22
-0.12   0.03   0.16   -1.03
-0.22   -0.03   -0.16   0.39
-0.09   -0.05   -0.01   -1.21
-0.26   -0.07   0.40   0.93
0.05   -0.07   0.64   1.28
0.60   -0.07   0.62   -0.32
0.19   -0.08   0.82   0.39
-0.14   -0.11   0.16   0.93
0.36   -0.12   0.35   -0.67
-0.14   -0.18   0.28   -0.85
-0.31   -0.19   1.21   -0.32
-0.20   -0.20   0.23   0.39
-0.48   -0.21   -0.27   -1.56
-0.30   -0.24   -0.22   -0.32
0.21   -0.27   -3.09   0.22
0.19   -0.28   0.04   0.04
-0.36   -0.30   -0.12   -0.32
-0.37   -0.33   -0.45   -0.14
-0.30   -0.34   -0.41   0.22
-0.31   -0.37   -0.59   0.04
0.17   -0.38   0.17   -1.21
-0.22   -0.44   -0.65   -1.03
-0.20   -0.45   0.26   -0.85
-0.69   -0.46   0.20   -0.50
-0.49   -0.48   -0.32   0.57
-0.50   -0.50   -0.27   -1.21
-0.55   -0.50   0.76   1.28
-0.49   -0.53   -0.19   -1.03
-0.54   -0.53   -0.34   1.28
-0.66   -0.56   -0.33   0.04
-0.33   -0.56   0.88   -0.14
-0.23   -0.56   -0.19   -1.21
-0.34   -0.57   -0.26   -0.85
-0.43   -0.58   -0.78   -1.03
-0.26   -0.58   -1.28   -1.21
-0.55   -0.59   -0.35   0.39
-0.36   -0.60   0.58   -0.14
-0.42   -0.61   0.26   0.22
-0.57   -0.62   -0.33   0.04
-0.48   -0.62   -0.52   -1.39
-0.33   -0.63   -0.43   0.04
-0.48   -0.64   -0.56   -0.32
-0.36   -0.64   -1.01   -1.39
-0.67   -0.64   -1.81   0.93
-0.38   -0.65   -1.21   -1.39
-0.58   -0.66   -0.51   -1.03
-1.10   -0.67   -1.45   -0.50
-0.49   -0.68   0.67   -0.14
-1.11   -0.69   -2.39   1.46
-0.47   -0.70   0.22   -0.85
-0.83   -0.70   -2.79   0.75
-1.10   -0.70   -2.27   0.57
-0.68   -0.71   0.14   -0.14
-0.70   -0.72   -1.00   -1.03
-0.52   -0.72   0.07   -0.67
-1.06   -0.72   -2.83   1.10
-0.60   -0.72   -0.45   -1.56
-0.51   -0.72   -0.67   -1.56
-0.64   -0.73   -0.73   -1.39
-0.69   -0.73   -0.30   -0.14
-0.59   -0.73   -0.66   -0.67
-0.58   -0.73   -0.22   -0.85
-0.64   -0.74   -0.40   0.04
-0.81   -0.74   -0.57   0.75
-0.87   -0.74   -1.83   -0.14
-0.63   -0.76   -0.80   -1.39
-1.12   -0.76   -1.59   0.57

in each case the 1st movie gets highest z scores

Descriptive statistics (correlation coefficient) showing the relationship between total gross sales and each of the other three variables

correlation matrix is

Opening Gross Total Gross Theaters
Total Gross 0.921
Theaters 0.648 0.629
Weeks 0.348 0.539 0.212

so sorr(total, open)=0.921

corr(total, theater)=0.629

corr(total,week)=0.539

Evaluate the relationships between total gross sales and each of the other three variables. Use tables, charts, graphs, or visual dashboards to support your

The regression equation is
Total Gross = - 44088904 + 2.52 Opening Gross + 6072 Theaters + 3289080 Weeks

Predictor Coef SE Coef T P
Constant -44088904 11904323 -3.70 0.000
Opening Gross 2.5229 0.1363 18.51 0.000
Theaters 6072 4154 1.46 0.147
Weeks 3289080 441180 7.46 0.000

here we build a regression on open gross on other we get that except theaters all other are significantly effecting total gross

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---