Title Genre Director Year Length CriticScore UserRating NumVotes Revenue

22 Jump Street Action Phil Lord 2014 112 71 7.1 280110 191.62

3 Days to Kill Action McG 2014 117 40 6.2 73567 30.69

300: Rise of an Empire Action Noam Murro 2014 102 48 6.2 237887 106.37

A Bigger Splash Drama Luca Guadagnino 2015 125 74 6.4 15232 1.98

A Million Ways to Die in the West Comedy Seth MacFarlane 2014 116 44 6.1 144779 42.62

Adoration Drama Anne Fontaine 2013 112 37 6.2 25208 0.32

After Earth Action M. Night Shyamalan 2013 100 33 4.9 166512 60.52

Alexander and the Terrible, Horrible, No Good, Very Bad Day Comedy Miguel Arteta 2014 81 54 6.2 32310 66.95

American Reunion Comedy Jon Hurwitz 2012 113 49 6.7 178471 56.72

Anna Karenina Drama Joe Wright 2012 129 63 6.6 75291 12.8

Ant-Man Action Peyton Reed 2015 117 64 7.3 368912 180.19

Argo Biography Ben Affleck 2012 120 86 7.7 481274 136.02

Battleship Action Peter Berg 2012 131 41 5.8 210349 65.17

Birdman or (The Unexpected Virtue of Ignorance) Comedy Alejandro Gonzlez Irritu 2014 119 88 7.8 440299 42.34

Blackhat Crime Michael Mann 2015 133 51 5.4 43085 7.1

Blended Comedy Frank Coraci 2014 117 31 6.5 93764 46.28

Blue Jasmine Drama Woody Allen 2013 98 78 7.3 160592 33.4

Boyhood Drama Richard Linklater 2014 165 100 7.9 286722 25.36

Brave Animation Mark Andrews 2012 93 69 7.2 293941 237.28

Bridesmaids Comedy Paul Feig 2011 125 75 6.8 227912 169.08

Bridge of Spies Drama Steven Spielberg 2015 142 81 7.6 217938 72.31

Brooklyn Drama John Crowley 2015 117 87 7.5 94977 38.32

Burnt Comedy John Wells 2015 101 42 6.6 76469 13.65

Captain America: The First Avenger Action Joe Johnston 2011 124 66 6.9 547368 176.64

Captain America: The Winter Soldier Action Anthony Russo 2014 136 70 7.8 542362 259.75

Captain Phillips Biography Paul Greengrass 2013 134 83 7.8 346154 107.1

Carol Drama Todd Haynes 2015 118 95 7.2 77995 0.25

Carrie Drama Kimberly Peirce 2013 100 53 5.9 113272 35.27

Cars 2 Animation John Lasseter 2011 106 57 6.2 110490 191.45

Chappie Action Neill Blomkamp 2015 120 41 6.9 188769 31.57

Chef Comedy Jon Favreau 2014 114 68 7.3 151970 31.24

Child 44 Crime Daniel Espinosa 2015 137 41 6.5 47703 1.21

Cinderella Drama Kenneth Branagh 2015 105 67 7 117018 201.15

Contagion Drama Steven Soderbergh 2011 106 70 6.6 187004 75.64

Creed Drama Ryan Coogler 2015 133 82 7.6 175673 109.71

Crimson Peak Drama Guillermo del Toro 2015 119 66 6.6 97454 31.06

Dallas Buyers Club Biography Jean-Marc Valle 2013 117 84 8 352801 27.3

Dark Shadows Comedy Tim Burton 2012 113 55 6.2 209326 79.71

Dear White People Comedy Justin Simien 2014 108 79 6.2 21715 4.4

Demolition Comedy Jean-Marc Valle 2015 101 49 7 58720 1.82

Diary of a Wimpy Kid: Rodrick Rules Comedy David Bowers 2011 99 51 6.6 20194 52.69

Divergent Adventure Neil Burger 2014 139 48 6.7 362093 150.83

Django Unchained Drama Quentin Tarantino 2012 165 81 8.4 1039115 162.8

Don Jon Comedy Joseph Gordon-Levitt 2013 90 66 6.6 199973 24.48

Dope Comedy Rick Famuyiwa 2015 103 72 7.3 66400 17.47

Dracula Untold Action Gary Shore 2014 92 40 6.3 148504 55.94

Dredd Action Pete Travis 2012 95 59 7.1 213764 13.4

Drive Crime Nicolas Winding Refn 2011 100 78 7.8 461509 35.05

Edge of Tomorrow Action Doug Liman 2014 113 71 7.9 471815 100.19

End of Watch Crime David Ayer 2012 109 68 7.7 192190 40.98

Endless Love Drama Shana Feste 2014 104 30 6.3 33688 23.39

Entourage Comedy Doug Ellin 2015 104 38 6.6 64557 32.36

Escape Plan Action Mikael Hfstrm 2013 115 49 6.7 188004 25.12

Everest Action Baltasar Kormkur 2015 121 64 7.1 154647 43.25

Ex Machina Drama Alex Garland 2014 108 78 7.7 339797 25.44

Exodus: Gods and Kings Action Ridley Scott 2014 150 52 6 137299 65.01

Eye in the Sky Drama Gavin Hood 2015 102 73 7.3 57826 18.7

Fantastic Four Action Josh Trank 2015 100 27 4.3 121847 56.11

Fast Five Action Justin Lin 2011 131 66 7.3 300803 209.81

Fifty Shades of Grey Drama Sam Taylor-Johnson 2015 125 46 4.1 244474 166.15

Flight Drama Robert Zemeckis 2012 138 76 7.3 276347 93.75

Focus Comedy Glenn Ficarra 2015 105 56 6.6 166489 53.85

Friends with Benefits Comedy Will Gluck 2011 109 63 6.6 286543 55.8

can you show step by step how you get it on excel

(a) Find the correlation between Revenue and the 2 variables: UserRating and CriticScore.

(b) Create a scatter chart with

x = CriticScore on the horizontal axis and

y = Revenue on the vertical axis.

Add a trend line with the regression equation on the chart.Include proper chart title and titles for both axes. You might want to copy and paste just the two columns needed to a different part of this sheet for convenience.