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 Spider-Man 3 151,116,516 336,530,303 4,324 15 2 Shrek the Third 121,629,270 322,719,944 4,172 12 3 Transformers 70,502,384 319,246,193 4,050 18 4 Pirates of the Caribbean: At World's End 114,732,820 309,420,425 4,362 19 5 Harry Potter and the Order of the Phoenix 77,108,414 292,004,738 4,285 22 6 I Am Legend 77,211,321 256,393,010 3,648 17 7 The Bourne Ultimatum 69,283,690 227,471,070 3,701 17 8 National Treasure: Book of Secrets 44,783,772 219,964,115 3,832 26 9 Alvin and the Chipmunks 44,307,417 217,326,974 3,499 25 10 300 70,885,301 210,614,939 3,280 18 11 Ratatouille 47,027,395 206,445,654 3,940 24 12 The Simpsons Movie 74,036,787 183,135,014 3,926 21 13 Wild Hogs 39,699,023 168,273,550 3,401 22 14 Knocked Up 30,690,990 148,768,917 2,975 17 15 Juno 413,869 143,495,265 2,534 28 16 Rush Hour 3 49,100,158 140,125,968 3,778 14 17 Live Free or Die Hard 33,369,559 134,529,403 3,411 19 18 Fantastic Four: Rise of the Silver Surfer 58,051,684 131,921,738 3,963 18 19 American Gangster 43,565,115 130,164,645 3,110 13 20 Enchanted 34,440,317 127,807,262 3,730 16 21 Bee Movie 38,021,044 126,631,277 3,984 15 22 Superbad 33,052,411 121,463,226 3,069 9 23 I Now Pronounce You Chuck and Larry 34,233,750 120,059,556 3,501 13 24 Hairspray (2007) 27,476,745 118,871,849 3,121 14 25 Blades of Glory 33,014,202 118,594,548 3,467 15 26 Ocean's Thirteen 36,133,403 117,154,724 3,565 15 27 Ghost Rider 45,388,836 115,802,596 3,620 10 28 Evan Almighty 31,192,615 100,462,298 3,636 15 29 Meet the Robinsons 25,123,781 97,822,171 3,435 23 30 Norbit 34,195,434 95,673,607 3,145 12 31 The Bucket List 335,837 93,466,502 2,915 23 32 The Game Plan 22,950,971 90,648,202 3,342 20 33 Beowulf 27,515,871 82,280,579 3,249 11 34 Bridge to Terabithia 22,564,612 82,272,442 3,210 19 35 Disturbia 22,224,982 80,209,692 3,132 16 36 No Country for Old Men 1,226,333 74,283,625 2,037 22 37 Fred Claus 18,515,473 72,006,777 3,603 14 38 1408 20,617,667 71,985,628 2,733 16 39 The Golden Compass 25,783,232 70,107,728 3,528 13 40 Charlie Wilson's War 9,656,250 66,661,095 2,594 11 41 Saw IV 31,756,764 63,300,095 3,183 7 42 Stomp the Yard 21,833,312 61,356,221 2,169 9 43 Surf's Up 17,640,249 58,867,694 3,531 11 44 Halloween (2007) 26,362,367 58,272,029 3,475 15 45 Tyler Perry's Why Did I Get Married? 21,353,789 55,204,525 2,034 9 46 TMNT 24,255,205 54,149,098 3,120 13 47 P.S. I Love You 6,481,221 53,695,808 2,471 12 48 3:10 to Yuma (2007) 14,035,033 53,606,916 3,006 10 49 Sweeney Todd: The Demon Barber of Fleet Street 9,300,805 52,898,073 1,507 13 50 Atonement 784,145 50,927,067 1,400 18 51 Resident Evil: Extinction 23,678,580 50,648,679 2,848 5 52 Music and Lyrics 13,623,630 50,572,589 2,955 13 53 Are We Done Yet? 14,262,724 49,662,533 2,944 13 54 This Christmas 17,958,183 49,121,934 1,921 7 55 Michael Clayton 719,910 49,033,882 2,585 24 56 Premonition 17,558,689 47,852,604 2,831 6 57 Dan in Real Life 11,809,445 47,642,963 1,941 15 58 The Kingdom 17,135,055 47,536,778 2,836 13 59 Shooter 14,523,571 47,003,582 2,806 12 60 License to Wed 10,422,258 43,799,818 2,715 13 61 Underdog 11,585,121 43,760,605 3,013 19 62 No Reservations 11,704,357 43,107,979 2,425 16 63 Because I Said So 13,122,865 42,674,040 2,529 9 64 Aliens Vs. Predator - Requiem 10,059,425 41,797,066 2,617 13 65 The Water Horse: Legend of the Deep 9,186,054 40,946,255 2,777 7 66 There Will Be Blood 190,739 40,222,514 1,620 18 67 Epic Movie 18,612,544 39,739,367 2,840 14 68 Hitman 13,180,769 39,687,694 2,468 16 69 30 Days of Night 15,951,902 39,568,996 2,859 5 70 Fracture 11,014,657 39,015,018 2,443 14 71 Stardust 9,169,779 38,634,938 2,565 11 72 The Brave One 13,471,488 36,793,804 2,837 11 73 The Heartbreak Kid 14,022,105 36,787,257 3,233 9 74 Freedom Writers 9,405,582 36,605,602 2,286 10 75 Smokin' Aces 14,638,755 35,787,686 2,219 7 76 The Messengers 14,713,321 35,374,833 2,529 6 77 The Number 23 14,602,867 35,193,167 2,759 5 78 Good Luck Chuck 13,652,001 35,017,297 2,612 8 79 Mr. Bean's Holiday 9,889,780 33,302,167 1,778 8 80 Breach 10,504,990 33,231,264 1,505 8 81 Zodiac 13,395,610 33,080,084 2,379 9 82 Balls of Fury 11,352,123 32,886,940 3,081 11 83 Mr. Magorium's Wonder Emporium 9,630,085 32,061,555 3,168 17 84 August Rush 9,421,369 31,664,162 2,310 14 85 Tyler Perry's Daddy's Little Girls 11,210,754 31,366,978 2,111 6 86 The Great Debaters 6,005,180 30,236,407 1,290 16 87 28 Weeks Later 9,807,292 28,638,916 2,305 14 88 We Own the Night 10,826,287 28,563,179 2,402 4 89 Mr. Brooks 10,017,067 28,549,298 2,453 11 90 Hannibal Rising 13,051,650 27,670,986 3,003 13 91 The Nanny Diaries 7,480,927 25,930,652 2,636 14 92 Mr. Woodcock 8,761,369 25,799,486 2,237 9 93 Nancy Drew 6,832,318 25,612,520 2,612 11 94 The Mist 8,931,973 25,594,957 2,423 17 95 The Reaping 10,025,203 25,126,214 2,603 9 96 Grindhouse 11,596,613 25,037,897 2,629 11 97 Sicko 68,969 24,540,079 1,117 17 98 Across the Universe 667,784 24,343,673 964 12 99 Perfect Stranger 11,206,163 23,984,949 2,661 6 100 Sea Monsters: A Prehistoric Adventure (IMAX) 605,722 23,746,066 252 49

Explanation / Answer

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

We can find descriptive statistics in EXCEL.

steps :

ENTER data into excel sheet --> Data --> Data Analysis --> Descriptive statistics --> ok --> Input range : Select all the variables together --> Labels in first row --> Output Range : select one empty cell --> ok

Mean opening gross = 24862477.45

Mean total gross = 85096527

Mean theaters = 2856.35

Mean weeks = 14.09

Median opening gross = 14620811

Median total gross = 50787873

Median theatres = 2844

Median weeks = 13

Range for opening gross = 151047547

Range for total gross = 3.13E+08

Range for theaters = 4110

Range for weeks = 45

Standard deviation for opening gross = 25900910.33

Standard deviation for total gross = 75282257

Standard deviation for theaters = 766.3948

Standard deviation for weeks = 6.237869

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

Correlation between total gross and opening gross = 0.9089

Correlation between total gross and theater = 0.6991

Correlation between total gross and weeks = 0.3642

We can see that all the correlations are positive so there is positive relationship between the variables.

Opening Gross Mean 24862477 Standard Error 2590091 Median 14620811 Mode #N/A Standard Deviation 25900910 Sample Variance 6.71E+14 Kurtosis 7.591172 Skewness 2.479535 Range 1.51E+08 Minimum 68969 Maximum 1.51E+08 Sum 2.49E+09 Count 100

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.