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.
\nManagerial Report<\/p>\n
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.
\nDescriptive 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.
\nUse 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.
\nDescriptive statistics (correlation coefficient) showing the relationship between total gross sales and each of the other three variables. Evaluate the relationships betweentotal gross sales and each of the other three variables. Use tables, charts, graphs, or visual dashboards to support your conclusions.
\nWrite a report that adheres to the Written Assignment Requirements under the heading \u201cExpectations for CSU-Global Written Assignments\u201d found in the CSU-Global Guide to Writing and APA Requirements. As with all written assignments at CSU-Global, you should have in-text citations and a reference page. An example paper is provided in the MTH410 Guide to Writing with Statistics, linked at the bottom of the page.
\nYour report must contain the following:
\nA title page in APA style.
\nAn introduction that summarizes the problem.
\nThe body of the paper should answer the questions posed in the problem by communicating the results of your analysis. Include results of calculations, as well as charts and graphs, where appropriate.
\nA conclusion paragraph that addresses your findings and what you have determined from the data and your analysis.
\nSubmit your Excel file in addition to your report.
\nRank Movie Title Opening Gross Total Gross Theaters Weeks
\n1 Toy Story 3 110,307,189 415,004,880 4,028 24
\n2 Alice in Wonderland (2010) 116,101,023 334,191,110 3,739 18
\n3 Iron Man 2 128,122,480 312,433,331 4,390 15
\n4 The Twilight Saga: Eclipse 64,832,191 300,531,751 4,468 16
\n5 Harry Potter and the Deathly Hallows Part 1 125,017,372 295,983,305 4,125 20
\n6 Inception 62,785,337 292,576,195 3,792 25
\n7 Despicable Me 56,397,125 251,513,985 3,602 28
\n8 Shrek Forever After 70,838,207 238,736,787 4,386 16
\n9 How to Train Your Dragon 43,732,319 217,581,231 4,060 17
\n10 Tangled 48,767,052 200,821,936 3,603 27
\n11 The Karate Kid 55,665,805 176,591,618 3,740 15
\n12 Tron Legacy 44,026,211 172,062,763 3,451 17
\n13 True Grit 24,830,443 171,243,005 3,464 18
\n14 Clash of the Titans (2010) 61,235,105 163,214,888 3,802 16
\n15 Grown Ups 40,506,562 162,001,186 3,534 18
\n16 Little Fockers 30,833,665 148,438,600 3,675 12
\n17 Megamind 46,016,833 148,415,853 3,949 16
\n18 The King’s Speech 355,450 135,453,143 2,584 18
\n19 The Last Airbender 40,325,019 131,772,187 3,203 12
\n20 Shutter Island 41,062,440 128,012,934 3,356 16
\n21 The Other Guys 35,543,162 119,219,978 3,651 15
\n22 Salt 36,011,243 118,311,368 3,612 14
\n23 Jackass 3-D 50,353,641 117,229,692 3,139 14
\n24 Valentine’s Day 56,260,707 110,485,654 3,665 12
\n25 Black Swan 1,443,809 106,954,678 2,407 22
\n26 Robin Hood 36,063,385 105,269,730 3,505 12
\n27 The Chronicles of Narnia: The Voyage of the Dawn Treader 24,005,069 104,386,950 3,555 18
\n28 The Expendables 34,825,135 103,068,524 3,398 10
\n29 Due Date 32,689,406 100,539,043 3,365 12
\n30 Yogi Bear 16,411,322 100,246,011 3,515 16
\n31 Date Night 25,207,599 98,711,404 3,380 22
\n32 The Social Network 22,445,653 96,962,694 2,921 22
\n33 Sex and the City 2 31,001,870 95,347,692 3,445 12
\n34 The Book of Eli 32,789,494 94,835,059 3,111 17
\n35 The Fighter 300,010 93,617,009 2,534 16
\n36 The Town 23,808,032 92,186,262 2,935 16
\n37 Prince of Persia: The Sands of Time 30,095,259 90,759,676 3,646 17
\n38 Red 21,761,408 90,380,162 3,349 16
\n39 Percy Jackson & The Olympians: The Lightning Thief 31,236,067 88,768,303 3,396 20
\n40 Paranormal Activity 2 40,678,424 84,752,907 3,239 13
\n41 Unstoppable 22,688,457 81,562,942 3,261 17
\n42 Eat Pray Love 23,104,523 80,574,010 3,108 12
\n43 Dear John 30,468,614 80,014,842 3,062 12
\n44 The A-Team 25,669,455 77,222,099 3,544 14
\n45 Knight & Day 20,139,985 76,423,035 3,104 15
\n46 Dinner for Schmucks 23,527,839 73,026,337 3,046 11
\n47 The Tourist 16,472,458 67,631,157 2,756 13
\n48 The Bounty Hunter 20,686,423 67,061,228 3,118 16
\n49 Diary of a Wimpy Kid 22,126,166 64,003,625 3,083 22
\n50 The Sorcerer’s Apprentice 17,619,622 63,150,991 3,504 15
\n51 A Nightmare on Elm Street (2010) 32,902,299 63,075,011 3,332 11
\n52 The Last Song 16,007,426 62,950,384 2,794 15
\n53 The Wolfman 31,479,235 61,979,680 3,223 7
\n54 Get Him to the Greek 17,570,955 60,974,475 2,702 10
\n55 Resident Evil: Afterlife 26,650,264 60,128,566 3,209 8
\n56 Tyler Perry’s Why Did I Get Married Too? 29,289,537 60,095,852 2,155 10
\n57 Tooth Fairy 14,010,409 60,022,256 3,345 22
\n58 Secretariat 12,694,770 59,713,955 3,108 18
\n59 Easy A 17,734,040 58,401,464 2,974 14
\n60 Takers 20,512,304 57,744,720 2,206 12
\n61 Legend of the Guardians: The Owls of Ga’Hoole 16,112,211 55,675,313 3,575 17
\n62 Life as We Know It 14,506,464 53,374,681 3,150 16
\n63 Letters to Juliet 13,540,486 53,032,453 2,975 15
\n64 Wall Street: Money Never Sleeps 19,011,188 52,474,616 3,597 12
\n65 Predators 24,760,882 52,000,688 2,669 14
\n66 Hot Tub Time Machine 14,020,502 50,287,556 2,771 11
\n67 Kick-Ass 19,828,687 48,071,303 3,065 11
\n68 Killers 15,837,266 47,059,963 2,859 11
\n69 Saw 3D 22,530,123 45,710,178 2,808 5
\n70 Cop Out 18,211,126 44,875,481 3,150 12
\n71 Cats & Dogs: The Revenge of Kitty Galore 12,279,363 43,585,753 3,705 12
\n72 Edge of Darkness 17,214,384 43,313,890 3,066 10
\n73 Gulliver’s Travels 6,307,691 42,779,261 3,089 16
\n74 Death at a Funeral (2010) 16,217,540 42,739,347 2,459 12
\n75 Step Up 3-D 15,812,311 42,400,223 2,439 13
\n76 The Last Exorcism 20,366,613 41,034,350 2,874 6
\n77 Hubble 3D 413,477 40,408,090 151 189
\n78 Legion (2010) 17,501,625 40,168,080 2,476 8
\n79 Burlesque 11,947,744 39,440,655 3,037 11
\n80 The Crazies 16,067,552 39,123,589 2,479 12
\n81 For Colored Girls 19,497,324 37,729,698 2,127 11
\n82 The Back-Up Plan 12,201,710 37,490,007 3,280 13
\n83 Vampires Suck 12,202,831 36,661,504 3,233 12
\n84 The American 13,177,790 35,606,376 2,833 9
\n85 Green Zone 14,309,295 35,053,660 3,004 8
\n86 Marmaduke 11,599,661 33,644,788 3,213 15
\n87 Devil 12,289,375 33,601,190 2,811 9
\n88 Hereafter 220,322 32,746,941 2,424 13
\n89 When in Rome 12,350,041 32,680,633 2,456 11
\n90 Love and Other Drugs 9,739,161 32,367,005 2,458 12
\n91 She’s Out of My League 9,775,278 32,010,860 2,958 10
\n92 Scott Pilgrim vs. the World 10,609,795 31,524,275 2,820 8
\n93 Charlie St. Cloud 12,381,585 31,162,545 2,725 7
\n94 Morning Glory 9,203,266 31,011,732 2,544 10
\n95 How Do You Know 7,484,696 30,212,620 2,483 6
\n96 Daybreakers 15,146,692 30,101,577 2,523 5
\n97 Nanny McPhee Returns 8,407,685 29,011,215 2,798 10
\n98 The Switch 8,436,713 27,779,426 2,017 13
\n99 Brooklyn’s Finest 13,350,299 27,163,593 1,939 11
\n100 Machete 11,416,164 26,593,646 2,678 11<\/p>\n","protected":false},"excerpt":{"rendered":"
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, Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-15877","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/15877","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=15877"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/15877\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=15877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=15877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=15877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}