Question: Using the spreadsheet - Movie Data.xls: Creater a Scatter Plot of 14 Day Gross Sales and US Gross Sales. Remove the Outlier Data....you decide what



Using the spreadsheet - Movie Data.xls: Creater a Scatter Plot of 14 Day Gross Sales and US Gross Sales. Remove the Outlier Data....you decide what is an outlier and add trendlines to each data set. Run 3 Regressions Comparing the Rotten Tomatoes Ranking to Total Revenue, the Run Time to Total Revenue and then a combined regression of Run Time and Rotten Tomatoes Ranking to Total Revenue. Comedy Action 7-day Gross $21,143,563 $15,058,504 $6,583,847 $38,841,865 $11,176,099 14-day Gross $31,024,169 $21,713,622 $9,940,816 $76,154,492 $16,228,598 $96,288,328 $141,843,655 $11,883,609 $17,579,582 Action $8,822,674 $22,707,121 $66,323,168 $13,555,127 $32,109,139 $96,763,003 $20,987,916 $37,465,379 $56,293,371 Comedy 1 1 Movie Distributor Genre 2 Epic Movie 20th Century Fox 3 Crank Lionsgate 4 The Protector Weinstein Co. Action 5 Borat 20th Century Fox Comedy 6 6 Pulse Weinstein/Dimension Horror 7 Once Fox Searchlight Drama 8 300 Warner Bros. Action 9 The Hills Have Eyes II Fox Searchlight Horror 10 Black Christmas Miramax/Dimension Horror 11 The Marine 20th Century Fox 12 The Texas Chainsaw Massacre: The Beginning New Line Horror 13 Rush Hour 3 New Line Action 14 Clerks II MGM Comedy 15 Thank You For Smoking Fox Searchlight Black Comedy 16 Jackass: Number Two Paramount Pictures Comedy 17 Rocky Balboa MGM Drama 18 Blades of Glory Paramount Pictures 19 Shrek the Third Paramount Pictures Adventure 20 Hostel: Part II Lionsgate Horror 21 Turistas 20th Century Fox Thriller/Suspense 22 I Think I Love My Wife Fox Searchlight Comedy 23 The Grudge 2 Sony Pictures Horror 24 1408 Miramax/Dimension Horror 25 Flicka 20th Century Fox Drama 26 Evan Almighty Universal Comedy 27 Gracie Picture House Drama 28 The Covenant Sony/Screen Gems Thriller/Suspense 29 Step Up Buena Vista Drama 30 Little Man Sony Pictures Comedy 31 Year of the Dog Paramount Vantage Drama 32 The Descent Lionsgate Thriller/Suspense 33 In the Land of Women Warner Independent Pictures Comedy 34 School for Scoundrels Weinstein Co. Comedy 35 The Nativity Story New Line Drama 36 The Queen Miramax Drama 37 Bug Lionsgate Drama 38 Little Miss Sunshine Fox Searchlight Comedy 39 Trust the Man Fox Searchlight Comedy 40 Employee of the Month Lionsgate Comedy 1 A Mighty Heart Paramount Vantage Drama 42 The Astronaut Farmer Warner Bros. Drama 43 Disturbia Paramount Pictures Thriller/Suspense 14 Waitress Fox Searchlight Drama 45 Saw III Lionsgate Horror 46 The History Boys Fox Searchlight Comedy 47 Smokin' Aces Universal Comedy 48 The Devil Wears Prada 20th Century Fox Comedy 49 You, Me and Dupree Universal Comedy 50 The Illusionist Freestyle Releasing Drama 51 Ghost Rider Sony Pictures Action $45,382,907 $76,130,018 $150,338,458 $227,906,792 $11,191,000 $16,040,871 $4,540,030 $6,437,413 $7,279,181 $10,899,186 $23,680,202 $32,715,981 $29,779.254 $46,649,346 $9,163,221 $14.900,036 $45,535,600 $69,987,650 $ $1,939,458 $11,013,531 $17,004,815 $29,580,830 $44,232,438 Total US Gross! International Gross US DVD Sales Budget Total Gross Rev Run Time Tomatometer $39,739,367 $47,119,211 $16,820,895 $20,000,000 $103,679,473 81 2 2 $27,838, 408 $5,986,288 $28,754,050 $12,000,000 $62,578,746 $ 83 61 $12,044,087 $31,000,000 $13,059,709 $5,700,000 $56,103,796 $ 84 53 $128,505,958 $133,066,786 $62,652,669 $18,000,000 $324,225,413 84 91 $20,264,436 $9,507,049 $7,500,000 $29,771,485 85 11 $9,445.857 $9,551,317 $150,000 $18,997,174 $ 86 97 $210,614,939 $245,453,242 $261,158,713 $60,000,000 $717,226,894 87 61 $20,804,166 $16,662,372 $30,466,195 $15,000,000 $67,932,733 $ 89 12 $16,235,738 $9,000,000 $16,235,738 90 15 $18,844,784 $3,320,824 $26,752,947 $15,000,000 $48,918,555 91 20 $39,517,763 $11,000,000 $$ $15,909,367 $16,000,000 $66,427,130 91 14 $140,125,968 $112,900,000 $40,775,094 - $293,801,062 91 18 $24,148,068 $1,746,405 $26,390,836 $5,000,000 $5,000,000 $52,285,309 92 63 $24,793,509 $14,438,702 $16,644,189 $7,500,000 $7,500,000 $55,876,400 92 86 $72,778,712 $10,800,000 $49,039,094 $11,000,000 $132,617,806 92 64 $70,269,899 $85,450,189 $34,655,821 $24,000,000 $190,375,909 92 77 $118,594,548 $27,000,000 $49,169,389 $61,000,000 $194,763,937 93 70 $322,719,944 $476,238,218 $174,342,569 = $973,300,731 $ 93 42 $17,544,812 $16,061,597 $16,167,194 $7,500,000 $49,773,603 $ 94 44 $7,027,762 $7,293,308 $3,507,046 $10,000,000 $17,828,116 94 19 $12,559,771 $645,640 $13,549,608 $14,000,000 $26,755,019 $ $ 94 19 $39,143,839 $29,500,000 $8,293,678 $20,000,000 $76,937,517 94 12 $71,985,628 $56,543,671 $49,635,451 $22,500,000 $178,164,750 94 79 $21,000,147 $893,444 $49,920,014 $15,000,000 $71,813,605 95 53 $100,289,690 $72,929,590 $37,997,932 F $211,217,212 96 23 $2,956,339 $80,397 $9,000,000 $3,036,736 97 61 $23,364,784 $14,800,000 $26,301,459 $20,000,000 $64,466,243 97 4 4 $65,328,121 $50,000,000 $51,183,795 $12,000,000 $166,511,916 98 21 $58,636,047 $43,000,000 $32,683,684 $64,000,000 $134,319,731 98 12 $1,540,141 $1,540,141 98 69 $26,024,456 $31,005,153 $22,436,857 $7,000,000 $79,466,466 $ 99 86 $11,052,958 $3,087,444 $9,691,414 $10,500,000 $23,831,816 100 44 $17,807,569 $20,000,000 $17,807,569 $ 100 26 $37,629,831 $8,802,433 $26,111,634 $35,000,000 $72,543,898 $ 100 37 $56,441,711 $66,398,892 $29,155,509 $15,000,000 $151,996,112 101 96 $7,006,708 $4,000,000 $7,006,708 102 62 $59,891,098 $40,632,083 $55,497,574 $8,000,000 $156,020,755 102 91 $1,530,535 $1,017,843 $9,000,000 $2,548,378 103 28 $28,444,855 $9,672,863 $21,061,839 $10,000,000 $59,179,557 103 20 $9,176,787 $9,755,330 $5,434,934 $15,000,000 $24,367,051 103 79 $11,003,643 $13,000,000 $11,003,643 105 58 $80,209,692 $37,363,351 $34,408,161 $20,000,000 $151,981,204 105 69 $19,097,550 $3,104,630 $23,084,465 $1,500,000 $45,286,645 $ $ 107 89 S80.238,724 $83,638,091 $47,124,617 $10,000,000 $211,001,432 107 29 $2,730,296 $10,695,293 $3,700,000 $13,425,589 109 66 $35,662,731 $20,384,530 $35,769,990 $17,000,000 $91,817,251 109 31 $124,740,460 $201,810,634 $95,831,660 $35,000,000 $422,382,754 109 75 $75,802,010 $54,600,000 $41,628,625 $54,000,000 $172,030,635 109 20 $39,868,642 $44,407,533 $38,189,217 $16,500,000 $122,465,392 110 73 $115,802,596 $121,900,000 $ 103,699,106 #### $341,401,702 110 26 $141,803 $12,927,112 $5,908,658 $10,554,778 $10,239,000 $318,598 $19,882,850 $9,308,837 $15,065,677 $18,373,000 $4,871,655 $6,740,839 $255,827 $14,310,416 $5,418,140 $5,580,399 $27,194,364 $655,122 $21,038,727 $7,757,609 $8,338,517 $43,085,763 mm $44,576,835 $63,279,443 $18,630,955 $27,061,120 $58,960,097 $83,257,376 $80,517,305 $124,984,886 $50,572,274 $76,834,795 $9,121,575 $14,424,970 $98,673,300 $144,820,320 $28,263,594 $42,853,277 $ $5,410,053 $8,079,470 $3,660,628 Buena Vista Weinstein Co. Sony Pictures Universal Universal Sony Pictures Paramount Vantage Sony Pictures Picture House Miramax Fox Searchlight Focus Features Warner Bros. Rocky Mountain Pictures Paramount Pictures Sony Pictures Buena Vista Comedy Documentary Comedy Drama Action Drama Drama Comedy Horror Drama Drama Comedy Adventure Drama Drama Drama Thriller/Suspense $206,445,654 $24,538,513 $121,463,226 $18,882,880 $227,471,070 $61,356,221 $9,396,870 $6,775,659 $37,634,615 $18,663,911 $17,606,684 $23,618,786 $117,144,465 $13,395,961 $36,605,602 $19,661,987 $418,000,000 $189,036,784 ## $813,482,438 $ $9,000,000 $17,375,592 $9,000,000 $50,914,105 $ $48,400,000 $134,374,749 $17,500,000 $304,237,975 $1,936,721 $19,347,243 $20,000,000 $40,166,844 $214,690,492 $123,288,965 $*** $565,450,527 $15,000,000 $33,166,898 $14,000,000 $109,523,119 $15,000,000 $9,396,870 $437,970 $1,877,732 $12,000,000 $9,091,361 $45,600,000 $40,752,599 $16,000,000 $123,987,214 $18,640,726 $8,050,112 $16,500,000 $45,354,749 $$ $ $30,756,832 $16,831,973 $6,000,000 $65,195,489 $ $ $55,578,707 $33,365,115 $16,000,000 $112,562,608 $ 194,600,000 $47,716,836 $85,000,000 $359,461,301 $20,000,000 $13,395,961 $ $6,485,139 $20,489,423 $21,000,000 $63,580,164 $ $420,000 $15,941,535 $20,000,000 $36,023,522 111 113 113 113 115 116 118 120 120 120 121 121 122 123 123 124 96 91 88 18 92 25 66 31 95 58 87 91 69 19 70 64 52 Ratatouille 53 Sicke 54 Superbad 55 Georgia Rule 56 The Bourne Ultimatum 57 Stomp the Yard 58 Black Snake Moan 59 Running With Scissors 60 Pan's Labyrinth 61 Becoming Jane 62 The Last King of Scotland 63 Hot Fuzz 64 Ocean's Thirteen 65 One Night with the King 66 Freedom Writers 67 Reign Over Me Dj Vu 68 69 World Trade Center The Prestige 70 71 Flags of Our Fathers The Holiday 72 73 Apocalypto 74 Harry Potter and the Order of the Phoenix 75 La Vie en Rose 76 Letters from Iwo Jima 77 Babel 78 War 79 Pirates of the Caribbean: Dead Man's Chest 80 Pirates of the Caribbean: At World's End $6,148,661 $7,724,188 $14,090,753 $50,705,336 $79,668,309 $ $5,307,651 $11,323,827 $21,317,621 $9,630,847 $14,896,332 $64,038,616 $70,278,893 $117,000,000 $93,000,000 $40,473,916 $80,000,000 $221,512,532 $36,856,697 $65,000,000 $200,135,590 128 129 Paramount Pictures Buena Vista 56 67 Drama Thriller/Suspense $19,207,527 $13,576,213 $31,630,273 $22,131,112 $53,089,891 $33,602,376 $54,806,115 $28,300,000 $45,348,399 $40,000,000 $153,244,405 $45,095,837 $53,000,000 $106,998,213 130 132 76 73 Dreamworks SKG Sony Pictures Drama Romantic Comedy 49 $17,110,339 $20,201,406 $30,092,962 $31,724,156 $217,083,411 $3,144,035 Buena Vista Warner Bros. Picture House Dreamworks SKG Paramount Vantage Lionsgate Buena Vista Buena Vista Adventure Adventure Drama Drama Drama Action Adventure Adventure $63,280,000 $50,866,635 $292,004,738 $10,299,782 $13,756,082 $34,302,837 $22,466,994 $423,315,812 $309,420,425 $141,910,324 $71,202,459 $85,000,000 $276,392,783 $66,918,416 $43,279,287 $40,000,000 $161,064,338 $646,464,126 $220,651,146 ##******* $220,651,146 = $73,200,000 $15,500,000 $83,499,782 $55,000,000 $13,618,088 $13,000,000 $82,374,170 $101,000,000 $31,456,221 $20,000,000 $166,759,058 $18,200,000 $27,040,983 $25,000,000 $67,707,977 $$ $642,344,000 $320,671,450 - $ W $651,576,067 $295,701,718 ##########******** $ 132 137 138 140 141 142 150 151 168 66 77 74 91 69 69 53 44 $12,839,402 $173,339,068 $232,297,818 Using the spreadsheet - Movie Data.xls: Creater a Scatter Plot of 14 Day Gross Sales and US Gross Sales. Remove the Outlier Data....you decide what is an outlier and add trendlines to each data set. Run 3 Regressions Comparing the Rotten Tomatoes Ranking to Total Revenue, the Run Time to Total Revenue and then a combined regression of Run Time and Rotten Tomatoes Ranking to Total Revenue. Comedy Action 7-day Gross $21,143,563 $15,058,504 $6,583,847 $38,841,865 $11,176,099 14-day Gross $31,024,169 $21,713,622 $9,940,816 $76,154,492 $16,228,598 $96,288,328 $141,843,655 $11,883,609 $17,579,582 Action $8,822,674 $22,707,121 $66,323,168 $13,555,127 $32,109,139 $96,763,003 $20,987,916 $37,465,379 $56,293,371 Comedy 1 1 Movie Distributor Genre 2 Epic Movie 20th Century Fox 3 Crank Lionsgate 4 The Protector Weinstein Co. Action 5 Borat 20th Century Fox Comedy 6 6 Pulse Weinstein/Dimension Horror 7 Once Fox Searchlight Drama 8 300 Warner Bros. Action 9 The Hills Have Eyes II Fox Searchlight Horror 10 Black Christmas Miramax/Dimension Horror 11 The Marine 20th Century Fox 12 The Texas Chainsaw Massacre: The Beginning New Line Horror 13 Rush Hour 3 New Line Action 14 Clerks II MGM Comedy 15 Thank You For Smoking Fox Searchlight Black Comedy 16 Jackass: Number Two Paramount Pictures Comedy 17 Rocky Balboa MGM Drama 18 Blades of Glory Paramount Pictures 19 Shrek the Third Paramount Pictures Adventure 20 Hostel: Part II Lionsgate Horror 21 Turistas 20th Century Fox Thriller/Suspense 22 I Think I Love My Wife Fox Searchlight Comedy 23 The Grudge 2 Sony Pictures Horror 24 1408 Miramax/Dimension Horror 25 Flicka 20th Century Fox Drama 26 Evan Almighty Universal Comedy 27 Gracie Picture House Drama 28 The Covenant Sony/Screen Gems Thriller/Suspense 29 Step Up Buena Vista Drama 30 Little Man Sony Pictures Comedy 31 Year of the Dog Paramount Vantage Drama 32 The Descent Lionsgate Thriller/Suspense 33 In the Land of Women Warner Independent Pictures Comedy 34 School for Scoundrels Weinstein Co. Comedy 35 The Nativity Story New Line Drama 36 The Queen Miramax Drama 37 Bug Lionsgate Drama 38 Little Miss Sunshine Fox Searchlight Comedy 39 Trust the Man Fox Searchlight Comedy 40 Employee of the Month Lionsgate Comedy 1 A Mighty Heart Paramount Vantage Drama 42 The Astronaut Farmer Warner Bros. Drama 43 Disturbia Paramount Pictures Thriller/Suspense 14 Waitress Fox Searchlight Drama 45 Saw III Lionsgate Horror 46 The History Boys Fox Searchlight Comedy 47 Smokin' Aces Universal Comedy 48 The Devil Wears Prada 20th Century Fox Comedy 49 You, Me and Dupree Universal Comedy 50 The Illusionist Freestyle Releasing Drama 51 Ghost Rider Sony Pictures Action $45,382,907 $76,130,018 $150,338,458 $227,906,792 $11,191,000 $16,040,871 $4,540,030 $6,437,413 $7,279,181 $10,899,186 $23,680,202 $32,715,981 $29,779.254 $46,649,346 $9,163,221 $14.900,036 $45,535,600 $69,987,650 $ $1,939,458 $11,013,531 $17,004,815 $29,580,830 $44,232,438 Total US Gross! International Gross US DVD Sales Budget Total Gross Rev Run Time Tomatometer $39,739,367 $47,119,211 $16,820,895 $20,000,000 $103,679,473 81 2 2 $27,838, 408 $5,986,288 $28,754,050 $12,000,000 $62,578,746 $ 83 61 $12,044,087 $31,000,000 $13,059,709 $5,700,000 $56,103,796 $ 84 53 $128,505,958 $133,066,786 $62,652,669 $18,000,000 $324,225,413 84 91 $20,264,436 $9,507,049 $7,500,000 $29,771,485 85 11 $9,445.857 $9,551,317 $150,000 $18,997,174 $ 86 97 $210,614,939 $245,453,242 $261,158,713 $60,000,000 $717,226,894 87 61 $20,804,166 $16,662,372 $30,466,195 $15,000,000 $67,932,733 $ 89 12 $16,235,738 $9,000,000 $16,235,738 90 15 $18,844,784 $3,320,824 $26,752,947 $15,000,000 $48,918,555 91 20 $39,517,763 $11,000,000 $$ $15,909,367 $16,000,000 $66,427,130 91 14 $140,125,968 $112,900,000 $40,775,094 - $293,801,062 91 18 $24,148,068 $1,746,405 $26,390,836 $5,000,000 $5,000,000 $52,285,309 92 63 $24,793,509 $14,438,702 $16,644,189 $7,500,000 $7,500,000 $55,876,400 92 86 $72,778,712 $10,800,000 $49,039,094 $11,000,000 $132,617,806 92 64 $70,269,899 $85,450,189 $34,655,821 $24,000,000 $190,375,909 92 77 $118,594,548 $27,000,000 $49,169,389 $61,000,000 $194,763,937 93 70 $322,719,944 $476,238,218 $174,342,569 = $973,300,731 $ 93 42 $17,544,812 $16,061,597 $16,167,194 $7,500,000 $49,773,603 $ 94 44 $7,027,762 $7,293,308 $3,507,046 $10,000,000 $17,828,116 94 19 $12,559,771 $645,640 $13,549,608 $14,000,000 $26,755,019 $ $ 94 19 $39,143,839 $29,500,000 $8,293,678 $20,000,000 $76,937,517 94 12 $71,985,628 $56,543,671 $49,635,451 $22,500,000 $178,164,750 94 79 $21,000,147 $893,444 $49,920,014 $15,000,000 $71,813,605 95 53 $100,289,690 $72,929,590 $37,997,932 F $211,217,212 96 23 $2,956,339 $80,397 $9,000,000 $3,036,736 97 61 $23,364,784 $14,800,000 $26,301,459 $20,000,000 $64,466,243 97 4 4 $65,328,121 $50,000,000 $51,183,795 $12,000,000 $166,511,916 98 21 $58,636,047 $43,000,000 $32,683,684 $64,000,000 $134,319,731 98 12 $1,540,141 $1,540,141 98 69 $26,024,456 $31,005,153 $22,436,857 $7,000,000 $79,466,466 $ 99 86 $11,052,958 $3,087,444 $9,691,414 $10,500,000 $23,831,816 100 44 $17,807,569 $20,000,000 $17,807,569 $ 100 26 $37,629,831 $8,802,433 $26,111,634 $35,000,000 $72,543,898 $ 100 37 $56,441,711 $66,398,892 $29,155,509 $15,000,000 $151,996,112 101 96 $7,006,708 $4,000,000 $7,006,708 102 62 $59,891,098 $40,632,083 $55,497,574 $8,000,000 $156,020,755 102 91 $1,530,535 $1,017,843 $9,000,000 $2,548,378 103 28 $28,444,855 $9,672,863 $21,061,839 $10,000,000 $59,179,557 103 20 $9,176,787 $9,755,330 $5,434,934 $15,000,000 $24,367,051 103 79 $11,003,643 $13,000,000 $11,003,643 105 58 $80,209,692 $37,363,351 $34,408,161 $20,000,000 $151,981,204 105 69 $19,097,550 $3,104,630 $23,084,465 $1,500,000 $45,286,645 $ $ 107 89 S80.238,724 $83,638,091 $47,124,617 $10,000,000 $211,001,432 107 29 $2,730,296 $10,695,293 $3,700,000 $13,425,589 109 66 $35,662,731 $20,384,530 $35,769,990 $17,000,000 $91,817,251 109 31 $124,740,460 $201,810,634 $95,831,660 $35,000,000 $422,382,754 109 75 $75,802,010 $54,600,000 $41,628,625 $54,000,000 $172,030,635 109 20 $39,868,642 $44,407,533 $38,189,217 $16,500,000 $122,465,392 110 73 $115,802,596 $121,900,000 $ 103,699,106 #### $341,401,702 110 26 $141,803 $12,927,112 $5,908,658 $10,554,778 $10,239,000 $318,598 $19,882,850 $9,308,837 $15,065,677 $18,373,000 $4,871,655 $6,740,839 $255,827 $14,310,416 $5,418,140 $5,580,399 $27,194,364 $655,122 $21,038,727 $7,757,609 $8,338,517 $43,085,763 mm $44,576,835 $63,279,443 $18,630,955 $27,061,120 $58,960,097 $83,257,376 $80,517,305 $124,984,886 $50,572,274 $76,834,795 $9,121,575 $14,424,970 $98,673,300 $144,820,320 $28,263,594 $42,853,277 $ $5,410,053 $8,079,470 $3,660,628 Buena Vista Weinstein Co. Sony Pictures Universal Universal Sony Pictures Paramount Vantage Sony Pictures Picture House Miramax Fox Searchlight Focus Features Warner Bros. Rocky Mountain Pictures Paramount Pictures Sony Pictures Buena Vista Comedy Documentary Comedy Drama Action Drama Drama Comedy Horror Drama Drama Comedy Adventure Drama Drama Drama Thriller/Suspense $206,445,654 $24,538,513 $121,463,226 $18,882,880 $227,471,070 $61,356,221 $9,396,870 $6,775,659 $37,634,615 $18,663,911 $17,606,684 $23,618,786 $117,144,465 $13,395,961 $36,605,602 $19,661,987 $418,000,000 $189,036,784 ## $813,482,438 $ $9,000,000 $17,375,592 $9,000,000 $50,914,105 $ $48,400,000 $134,374,749 $17,500,000 $304,237,975 $1,936,721 $19,347,243 $20,000,000 $40,166,844 $214,690,492 $123,288,965 $*** $565,450,527 $15,000,000 $33,166,898 $14,000,000 $109,523,119 $15,000,000 $9,396,870 $437,970 $1,877,732 $12,000,000 $9,091,361 $45,600,000 $40,752,599 $16,000,000 $123,987,214 $18,640,726 $8,050,112 $16,500,000 $45,354,749 $$ $ $30,756,832 $16,831,973 $6,000,000 $65,195,489 $ $ $55,578,707 $33,365,115 $16,000,000 $112,562,608 $ 194,600,000 $47,716,836 $85,000,000 $359,461,301 $20,000,000 $13,395,961 $ $6,485,139 $20,489,423 $21,000,000 $63,580,164 $ $420,000 $15,941,535 $20,000,000 $36,023,522 111 113 113 113 115 116 118 120 120 120 121 121 122 123 123 124 96 91 88 18 92 25 66 31 95 58 87 91 69 19 70 64 52 Ratatouille 53 Sicke 54 Superbad 55 Georgia Rule 56 The Bourne Ultimatum 57 Stomp the Yard 58 Black Snake Moan 59 Running With Scissors 60 Pan's Labyrinth 61 Becoming Jane 62 The Last King of Scotland 63 Hot Fuzz 64 Ocean's Thirteen 65 One Night with the King 66 Freedom Writers 67 Reign Over Me Dj Vu 68 69 World Trade Center The Prestige 70 71 Flags of Our Fathers The Holiday 72 73 Apocalypto 74 Harry Potter and the Order of the Phoenix 75 La Vie en Rose 76 Letters from Iwo Jima 77 Babel 78 War 79 Pirates of the Caribbean: Dead Man's Chest 80 Pirates of the Caribbean: At World's End $6,148,661 $7,724,188 $14,090,753 $50,705,336 $79,668,309 $ $5,307,651 $11,323,827 $21,317,621 $9,630,847 $14,896,332 $64,038,616 $70,278,893 $117,000,000 $93,000,000 $40,473,916 $80,000,000 $221,512,532 $36,856,697 $65,000,000 $200,135,590 128 129 Paramount Pictures Buena Vista 56 67 Drama Thriller/Suspense $19,207,527 $13,576,213 $31,630,273 $22,131,112 $53,089,891 $33,602,376 $54,806,115 $28,300,000 $45,348,399 $40,000,000 $153,244,405 $45,095,837 $53,000,000 $106,998,213 130 132 76 73 Dreamworks SKG Sony Pictures Drama Romantic Comedy 49 $17,110,339 $20,201,406 $30,092,962 $31,724,156 $217,083,411 $3,144,035 Buena Vista Warner Bros. Picture House Dreamworks SKG Paramount Vantage Lionsgate Buena Vista Buena Vista Adventure Adventure Drama Drama Drama Action Adventure Adventure $63,280,000 $50,866,635 $292,004,738 $10,299,782 $13,756,082 $34,302,837 $22,466,994 $423,315,812 $309,420,425 $141,910,324 $71,202,459 $85,000,000 $276,392,783 $66,918,416 $43,279,287 $40,000,000 $161,064,338 $646,464,126 $220,651,146 ##******* $220,651,146 = $73,200,000 $15,500,000 $83,499,782 $55,000,000 $13,618,088 $13,000,000 $82,374,170 $101,000,000 $31,456,221 $20,000,000 $166,759,058 $18,200,000 $27,040,983 $25,000,000 $67,707,977 $$ $642,344,000 $320,671,450 - $ W $651,576,067 $295,701,718 ##########******** $ 132 137 138 140 141 142 150 151 168 66 77 74 91 69 69 53 44 $12,839,402 $173,339,068 $232,297,818