Question 2

DC and Marvel are two competing comic book properties from which many movies and tv shows have been made. Import the file attached below into R/R Studio--note this is a csv file and requires the appropriate function.

Q2a) Create a PQ table reporting the summary statistics for Worldwide Box Office for DC movies, Marvel movies, and both combined. The table should include the following descriptive statistics for each group: n, min, man, mean, standard deviation, and first and third quartiles. Make sure your table title accurately captures the table contents and indicate the units of measurement somewhere, perhaps directly under the table or in the title. Do not carry decimals beyond two places. Note: Missing values should not be part of your valid n. (0.25 points)

2b) Perform a t-test in R to determine if there is a statistically significant difference between the means of worldwide box office sales for Marvel and DC. Report your findings using alpha = 0.10 and using APA citation. If success is measured in box office millions of dollars, can we conclude that one comic company is more successful making movies that the other? (0.50 points)

Q2c) What is the standardized effect size of the difference in means from Q2b? Perform a Cohens d analysis. Report the difference in means and the Cohens d score. Interpret the size of the effect. (0.25 points)

Movie (Yea Year Studio The Dark K 2008 DC Spider-Mar 2004 Marvel Iron Man (2 2008 Marvel Superman 1978 DC Guardians 2014 Marvel The Dark K 2012 DC Black Panti 2018 Marvel Logan (201 2017 Marvel The Aveng 2012 Marvel Thor: Ragn 2017 Marvel X-Men: Da 2014 Marvel Captain An 2016 Marvel Superman 1980 DC Deadpool 2016 Marvel Wonder Wc 2017 DC Spider-Mar 2017 Marvel Spider-Mar 2002 Marvel Batman Be 2005 DC Captain An 2014 Marvel X-Men Unit 2003 Marvel Doctor Stra 2016 Marvel Guardians 2017 Marvel Captain An 2011 Marvel Avengers: 2015 Marvel Batman (19 1989 DC Iron Man 3 2013 Marvel X-Men (200 2000 Marvel Batman Re 1992 DC Superman 2006 DC The Amazii 2012 Marvel Ant-Man (2 2015 Marvel Iron Man 2 2010 Marvel Thor (2011 2011 Marvel X-Men: Firs 2011 Marvel Thor: The 2013 Marvel Man of Ste 2013 DC Spider-Mar 2007 Marvel The Amazii 2014 Marvel X-Men: The 2006 Marvel Justice Lea 2017 DC Hulk (2003 2003 Marvel Batman vs 2016 DC The Incredi 2008 Marvel Batman Fo 1995 DC The Wolvei 2013 Marvel X-Men Orig 2009 Marvel Suicide Sq 2016 DC X-Men: Api 2016 Marvel Watchmen 2009 DC Fantastic 4 2007 Marvel Fantastic F 2005 Marvel Blade II (2C 2002 Marvel Blade (199 1998 Marvel Daredevil 2003 Marvel Superman 1983 DC Batman & F 1997 DC Ghost Ride 2007 Marvel Green Lant 2011 DC Batman the 1966 DC Blade: Trini 2004 Marvel Swamp Thi 1982 DC The Punish 2004 Marvel Ghost Ride 2011 Marvel Fantastic F 2015 Marvel Elektra (20 2005 Marvel Howard the 1986 Marvel Catwoman 2004 DC Punisher: V 2008 Marvel Supergirl (1 1984 DC Jonah Hex 2010 DC Superman 1987 DC Steel (1997 1997 DC Domestic Worldwide Review 666.3 1253.1 92 539.6 1132.1 88 397.8 731.1 89 514.8 1151.1 88 368 851.2 88 516.3 1233.3 88 400 704 88 226.3 226.3 86 702.5 1703.6 86 314.8 853.6 86 256.8 821.4 84 420.1 1192.9 85 383.6 803 84 378.6 814.2 80 413.6 822.8 84 334.2 880.2 83 624.4 1270.8 82 287.8 522.4 82 285.2 784.2 82 319.8 606.5 83 241.2 702.8 81 389.8 863.6 80 199.8 419.2 77 479.9 1486.9 77 564.6 926.5 75 438.1 1325.8 261.8 493.2 76 352 576.7 75 272.8 533.1 74 295.3 847.7 75 191.7 552.5 77 355.2 709.3 71 204.8 508.3 72 165.6 400 81 227.7 711.4 68 321.1 737.1 66 438.8 1161.5 64 222.7 778.4 64 319.5 626.2 64 228.8 657.6 62 196.6 365 60 342.6 905.6 55 168.4 329.1 68 379.5 693.9 146.3 457.7 69 215.1 446.2 337.1 773.2 47 161.2 564.1 60 128.6 221.6 68 172 376.9 48 216.8 463.3 39 127.4 239.7 61 134 250.9 152.5 266.5 170.7 315.9 39 209.7 465.5 26 151 298.2 39 131.9 248.7 44 34.7 34.7 72 75.7 186.2 42 19.6 19.6 56 48.8 79 58.6 149.9 36 59.7 178.7 26 34.2 79.4 32 91.8 30 58.1 118.6 24 10.1 12.6 40 38.2 70.6 25 12 12.4 32 36 68.4 23 3.3 6.2 19 B8mmNNnRu8&m5888m8858998842$$$%B8%9B89 52 49 43 39.4 Movie (Yea Year Studio The Dark K 2008 DC Spider-Mar 2004 Marvel Iron Man (2 2008 Marvel Superman 1978 DC Guardians 2014 Marvel The Dark K 2012 DC Black Panti 2018 Marvel Logan (201 2017 Marvel The Aveng 2012 Marvel Thor: Ragn 2017 Marvel X-Men: Da 2014 Marvel Captain An 2016 Marvel Superman 1980 DC Deadpool 2016 Marvel Wonder Wc 2017 DC Spider-Mar 2017 Marvel Spider-Mar 2002 Marvel Batman Be 2005 DC Captain An 2014 Marvel X-Men Unit 2003 Marvel Doctor Stra 2016 Marvel Guardians 2017 Marvel Captain An 2011 Marvel Avengers: 2015 Marvel Batman (19 1989 DC Iron Man 3 2013 Marvel X-Men (200 2000 Marvel Batman Re 1992 DC Superman 2006 DC The Amazii 2012 Marvel Ant-Man (2 2015 Marvel Iron Man 2 2010 Marvel Thor (2011 2011 Marvel X-Men: Firs 2011 Marvel Thor: The 2013 Marvel Man of Ste 2013 DC Spider-Mar 2007 Marvel The Amazii 2014 Marvel X-Men: The 2006 Marvel Justice Lea 2017 DC Hulk (2003 2003 Marvel Batman vs 2016 DC The Incredi 2008 Marvel Batman Fo 1995 DC The Wolvei 2013 Marvel X-Men Orig 2009 Marvel Suicide Sq 2016 DC X-Men: Api 2016 Marvel Watchmen 2009 DC Fantastic 4 2007 Marvel Fantastic F 2005 Marvel Blade II (2C 2002 Marvel Blade (199 1998 Marvel Daredevil 2003 Marvel Superman 1983 DC Batman & F 1997 DC Ghost Ride 2007 Marvel Green Lant 2011 DC Batman the 1966 DC Blade: Trini 2004 Marvel Swamp Thi 1982 DC The Punish 2004 Marvel Ghost Ride 2011 Marvel Fantastic F 2015 Marvel Elektra (20 2005 Marvel Howard the 1986 Marvel Catwoman 2004 DC Punisher: V 2008 Marvel Supergirl (1 1984 DC Jonah Hex 2010 DC Superman 1987 DC Steel (1997 1997 DC Domestic Worldwide Review 666.3 1253.1 92 539.6 1132.1 88 397.8 731.1 89 514.8 1151.1 88 368 851.2 88 516.3 1233.3 88 400 704 88 226.3 226.3 86 702.5 1703.6 86 314.8 853.6 86 256.8 821.4 84 420.1 1192.9 85 383.6 803 84 378.6 814.2 80 413.6 822.8 84 334.2 880.2 83 624.4 1270.8 82 287.8 522.4 82 285.2 784.2 82 319.8 606.5 83 241.2 702.8 81 389.8 863.6 80 199.8 419.2 77 479.9 1486.9 77 564.6 926.5 75 438.1 1325.8 261.8 493.2 76 352 576.7 75 272.8 533.1 74 295.3 847.7 75 191.7 552.5 77 355.2 709.3 71 204.8 508.3 72 165.6 400 81 227.7 711.4 68 321.1 737.1 66 438.8 1161.5 64 222.7 778.4 64 319.5 626.2 64 228.8 657.6 62 196.6 365 60 342.6 905.6 55 168.4 329.1 68 379.5 693.9 146.3 457.7 69 215.1 446.2 337.1 773.2 47 161.2 564.1 60 128.6 221.6 68 172 376.9 48 216.8 463.3 39 127.4 239.7 61 134 250.9 152.5 266.5 170.7 315.9 39 209.7 465.5 26 151 298.2 39 131.9 248.7 44 34.7 34.7 72 75.7 186.2 42 19.6 19.6 56 48.8 79 58.6 149.9 36 59.7 178.7 26 34.2 79.4 32 91.8 30 58.1 118.6 24 10.1 12.6 40 38.2 70.6 25 12 12.4 32 36 68.4 23 3.3 6.2 19 B8mmNNnRu8&m5888m8858998842$$$%B8%9B89 52 49 43 39.4