looking for help to finish last half of assignment

profileLorraineS
mth410_mod02_ct_movies_opt1v6_1.xlsx
Home>Mathematics homework help>Algebra homework help>looking for help to finish last half of assignment

DATA

Rank Movie Title Opening Gross Total Gross Theaters Weeks
95 2016 Obama's America 31,610 28,835,528 924 5
32 Zero Dark Thirty 417,150 28,972,764 1,298 7
23 Silver Linings Playbook 443,003 30,932,113 1,567 8
74 Moonrise Kingdom 522,996 31,051,126 2,017 8
73 The Best Exotic Marigold Hotel 737,051 31,611,916 2,052 8
94 Monsters, Inc. (3D) 4,774,686 34,043,006 2,132 9
86 Lawless 10,001,982 35,291,068 2,161 9
13 Lincoln 944,308 33,449,086 2,293 9
87 The Guilt Trip 5,290,629 35,074,677 2,431 9
48 Pitch Perfect 5,149,433 35,025,791 2,441 9
100 The Five-Year Engagement 10,610,060 35,763,137 2,542 10
81 What to Expect When You're Expecting 10,547,068 35,353,000 2,551 10
64 The Odd Life of Timothy Green 10,822,903 37,134,215 2,573 10
99 Chimpanzee 10,673,748 36,931,089 2,606 10
96 House at the End of The Street 12,287,234 42,345,531 2,618 11
97 The Pirates! Band of Misfits 11,137,734 37,400,127 2,625 11
75 Here Comes the Boom 11,816,596 41,152,203 2,635 11
91 Frankenweenie 11,412,213 38,518,613 2,638 11
98 Joyful Noise 11,225,190 37,519,139 2,655 11
92 Step Up Revolution 11,731,708 41,128,283 2,717 11
43 This Is 40 11,579,175 41,003,371 2,735 11
89 Trouble with the Curve 12,162,040 42,073,277 2,780 11
90 The Watch 12,750,297 43,456,382 2,781 12
69 Diary of a Wimpy Kid: Dog Days 14,623,599 47,617,067 2,787 12
58 ParaNorman 14,087,050 45,290,318 2,809 12
76 Red Dawn (2012) 14,276,668 45,512,466 2,811 12
83 End of Watch 13,152,683 44,338,224 2,856 12
40 Parental Guidance 14,554,053 47,382,068 2,860 12
84 Rock of Ages 14,437,269 46,412,041 2,870 12
88 That's My Boy 13,453,714 44,806,783 2,904 12
80 The Cabin in the Woods 14,743,614 49,008,662 2,908 13
85 Abraham Lincoln: Vampire Hunter 16,306,974 51,774,002 2,927 13
72 Savages (2012) 16,016,910 51,580,236 2,931 13
82 Finding Nemo (3D) 16,687,773 51,854,875 2,941 13
51 Hope Springs 14,650,121 48,086,903 2,946 13
93 Tyler Perry's Good Deeds 15,583,924 49,876,377 2,946 13
68 The Possession 17,732,480 54,760,791 2,993 13
38 Jack Reacher 15,210,156 49,130,154 3,005 13
77 The Three Stooges 17,010,125 53,261,944 3,012 13
56 Titanic 3D 17,285,453 53,921,300 3,014 13
59 This Means War 17,405,930 54,333,290 3,014 13
54 The Dictator 17,435,092 54,731,865 3,016 13
45 Looper 20,801,522 62,321,039 3,021 14
70 Sinister 18,007,634 57,011,521 3,030 14
22 Argo 19,458,109 59,650,222 3,038 14
66 The Grey 19,665,101 60,457,138 3,053 14
67 Red Tails 18,782,154 58,877,969 3,055 14
71 Beauty and the Beast (3D) 17,751,905 56,003,051 3,078 14
49 Mirror Mirror 18,132,085 57,884,114 3,083 14
61 The Woman in Black 20,874,072 63,536,011 3,109 14
50 Chronicle (2012) 22,004,098 65,422,625 3,120 15
60 Project X 21,051,363 64,575,175 3,121 15
65 Ghost Rider: Spirit of Vengeance 22,115,334 65,653,242 3,138 15
79 Resident Evil: Retribution 21,052,227 64,935,167 3,148 15
78 Star Wars: Episode I - The Phantom Menace (in 3D) 22,469,932 66,528,000 3,168 15
57 American Reunion 21,514,080 65,001,093 3,174 15
27 Life of Pi 22,451,514 66,486,205 3,175 15
53 The Lucky One 22,518,358 67,544,505 3,189 15
31 Rise of the Guardians 23,773,465 70,012,847 3,203 15
44 Contraband 24,349,815 73,078,100 3,208 16
42 Act of Valor 24,476,632 77,267,296 3,212 16
33 Flight 24,900,566 79,727,149 3,247 16
52 Underworld Awakening 25,306,725 80,070,736 3,302 16
46 Tyler Perry's Madea's Witness Protection 25,390,575 83,670,083 3,303 17
47 Battleship 25,534,825 85,028,192 3,352 17
55 Total Recall (2012) 25,577,758 86,907,746 3,355 17
35 The Campaign 26,588,460 91,547,205 3,358 17
18 Les Miserables (2012) 27,281,735 93,772,375 3,368 18
62 Paranormal Activity 4 29,003,866 103,860,290 3,375 18
36 The Expendables 2 28,591,370 103,412,758 3,401 18
30 Journey 2: The Mysterious Island 27,335,363 95,720,716 3,412 18
39 Dark Shadows 29,685,274 113,203,870 3,442 19
41 John Carter 30,180,188 124,987,023 3,455 19
15 Django Unchained 30,122,888 113,721,571 3,470 19
34 Think Like a Man 33,636,303 126,373,434 3,482 20
29 The Bourne Legacy 38,142,825 136,024,128 3,500 20
19 Hotel Transylvania 42,522,194 148,809,770 3,526 20
37 Wrath of the Titans 33,457,188 125,014,030 3,545 20
63 The Devil Inside 33,732,515 126,477,084 3,601 20
25 Safe House 40,172,720 139,854,287 3,618 20
21 21 Jump Street 36,302,612 132,092,958 3,672 20
28 Magic Mike 39,127,170 138,447,667 3,674 20
26 The Vow 41,202,458 148,313,048 3,702 20
16 Ice Age: Continental Drift 46,629,259 155,332,381 3,706 21
12 Wreck-It Ralph 49,038,712 161,321,843 3,749 21
20 Taken 2 49,514,769 162,805,434 3,752 21
24 Prometheus 51,050,101 179,020,854 3,753 21
9 Ted 54,415,205 182,207,973 3,755 22
14 MIB 3 54,592,779 189,422,889 3,769 22
17 Snow White and the Huntsman 56,217,700 214,030,500 3,777 22
10 Madagascar 3: Europe's Most Wanted 60,316,738 216,391,482 3,886 23
7 The Amazing Spider-Man 62,004,688 218,815,487 4,070 24
8 Brave 66,323,594 237,283,207 4,100 24
11 Dr. Seuss' The Lorax 70,217,070 262,030,663 4,137 25
5 The Hobbit: An Unexpected Journey 84,617,303 292,324,737 4,164 26
4 Skyfall 88,364,714 303,003,568 4,248 28
6 The Twilight Saga: Breaking Dawn Part 2 141,067,634 304,360,277 4,263 29
3 The Hunger Games 152,535,747 408,010,692 4,318 30
2 The Dark Knight Rises 160,887,295 448,139,099 4,349 30
1 Marvel's The Avengers 207,438,708 623,357,910 4,404 35
Total $ 3,021,999,396.00 $ 10,034,885,244.00 313005 1,573
Mean $ 30,219,993.96 $ 100,348,852.44 3130 15.73
Medium $ 18,132,085.00 $ 57,884,114.00 3083 14
Range $ 207,407,098.00 $ 594,522,382.00 3480 30
Std Dev 33166537 95827983 617 6