Business statistics Assignment

Yongj
Assignmentdata.xls
Home>Mathematics homework help>Statistics homework help>Business statistics Assignment

Dictionary

Variable Description Data Type
Name Name of the game String
Platform Console on which the game is running String
Year_of_Release Help us describe this column Numeric
Genre Help us describe this column String
Publisher Help us describe this column String
NA_Sales Game sales in North America (in millions of units) Numeric
EU_Sales Game sales in the European Union (in millions of units) Numeric
JP_Sales Game sales in Japan (in millions of units) Numeric
Other_Sales Game sales in the rest of the world, i.e. Africa, Asia excluding Japan, Australia, Europe excluding the E.U. and South America (in millions of units) Numeric
Global_Sales Total sales in the world (in millions of units) Numeric
Critic_Score Aggregate score compiled by Metacritic staff Numeric
Critic_Count The number of critics used in coming up with the Critic_score Numeric
User_Score Score by Metacritic's subscribers Numeric
User_Count Number of users who gave the user_score Numeric
Developer Party responsible for creating the game String
Rating The ESRB ratings (E.g. Everyone, Teen, Adults Only..etc) String
Mature Dummy Variable where the ESRB rating is Adults Only
PS4 Dummy variable indicating the game was released on the PS4
WiiU Dummy variable indicating the game was released on the WiiU
Xone Dummy variable indicating the game was released on the Xbox One

Data

Name Global_Sales Critic_Score User_Score Mature PS4 WiiU Xone Year_of_Release
Grand Theft Auto V 12.61 97 83 1 1 0 0 2014
FIFA 16 8.57 82 43 0 1 0 0 2015
Call of Duty: Advanced Warfare 7.66 83 57 1 1 0 0 2014
FIFA 17 7.59 85 50 0 1 0 0 2016
Fallout 4 7.16 87 65 1 1 0 0 2015
Mario Kart 8 7.09 88 91 0 0 1 0 2014
FIFA 15 6.08 82 57 0 1 0 0 2014
Destiny 5.64 76 61 0 1 0 0 2014
Grand Theft Auto V 5.48 97 79 1 0 0 1 2014
Uncharted 4: A Thief's End 5.38 93 79 0 1 0 0 2016
Call of Duty: Advanced Warfare 5.27 81 54 1 0 0 1 2014
Uncharted: The Nathan Drake Collection 4.62 86 81 0 1 0 0 2015
Halo 5: Guardians 4.48 84 64 0 0 0 1 2015
Call of Duty: Infinite Warfare 4.46 77 34 1 1 0 0 2016
Splatoon 4.43 81 85 0 0 1 0 2015
Super Mario 3D World 4.32 93 90 0 0 1 0 2013
Fallout 4 4.22 88 62 1 0 0 1 2015
Battlefield 1 4.08 88 84 1 1 0 0 2016
Watch Dogs 4.05 80 63 1 1 0 0 2014
Far Cry 4 4.04 85 77 1 1 0 0 2014
The Witcher 3: Wild Hunt 3.97 92 92 1 1 0 0 2015
Assassin's Creed: Unity 3.96 70 49 1 1 0 0 2014
Batman: Arkham Knight 3.95 87 76 1 1 0 0 2015
NBA 2K16 3.88 87 67 0 1 0 0 2015
Call of Duty: Ghosts 3.83 78 37 1 1 0 0 2013
Tom Clancy's The Division 3.8 80 70 1 1 0 0 2016
Battlefield 4 3.59 85 69 1 1 0 0 2013
Assassin's Creed: Unity 3.5 72 41 1 0 0 1 2014
Metal Gear Solid V: The Phantom Pain 3.41 93 82 1 1 0 0 2015
Assassin's Creed Syndicate 3.39 76 68 1 1 0 0 2015
Destiny 3.37 75 55 0 0 0 1 2014
Gears of War: Ultimate Edition 3.28 82 75 1 0 0 1 2015
FIFA 16 3.25 84 44 0 0 0 1 2015
Madden NFL 16 3.24 83 59 0 1 0 0 2015
Halo: The Master Chief Collection 3.23 85 72 1 0 0 1 2014
Super Mario Maker 3.21 88 87 0 0 1 0 2015
FIFA 14 3.01 87 63 0 1 0 0 2013
Middle-Earth: Shadow of Mordor 2.96 84 81 1 1 0 0 2014
Titanfall 2.95 86 64 1 0 0 1 2014
Call of Duty: Ghosts 2.92 78 43 1 0 0 1 2013
Assassin's Creed IV: Black Flag 2.85 83 78 1 1 0 0 2013
inFAMOUS: Second Son 2.79 80 79 0 1 0 0 2014
Mortal Kombat X 2.78 83 77 1 1 0 0 2015
Killzone: Shadow Fall 2.69 73 68 1 1 0 0 2013
FIFA 17 2.65 84 55 0 0 0 1 2016
Bloodborne 2.48 92 86 1 1 0 0 2015
NBA 2K15 2.45 83 70 0 1 0 0 2014
Call of Duty: Infinite Warfare 2.42 78 31 1 0 0 1 2016
Madden NFL 16 2.42 84 61 0 0 0 1 2015
NBA 2K16 2.34 86 62 0 0 0 1 2015
Far Cry: Primal 2.26 76 63 1 1 0 0 2016
Battlefield 1 2.25 87 82 1 0 0 1 2016
New Super Luigi U 2.24 77 79 0 0 1 0 2013
Assassin's Creed IV: Black Flag 2.23 89 74 1 0 0 1 2013
Tom Clancy's Rainbow Six: Siege 2.21 73 73 1 1 0 0 2015
Forza Motorsport 5 2.2 79 59 0 0 0 1 2013
Madden NFL 15 2.19 81 61 0 1 0 0 2014
FIFA 15 2.18 82 54 0 0 0 1 2014
Tom Clancy's The Division 2.16 80 69 1 0 0 1 2016
Overwatch 2.14 90 61 0 1 0 0 2016
Battlefield: Hardline 2.1 73 50 1 1 0 0 2015
Dying Light 2.09 74 79 1 1 0 0 2015
DriveClub 2.07 71 61 0 1 0 0 2014
Battlefield 4 2.02 81 66 1 0 0 1 2013
Dragon Age: Inquisition 2.01 89 74 1 1 0 0 2014
Need for Speed Rivals 1.98 80 62 0 1 0 0 2013
Destiny: The Taken King 1.93 86 60 0 1 0 0 2015
LittleBigPlanet 3 1.91 79 71 0 1 0 0 2014
NBA 2K17 1.88 88 67 0 1 0 0 2016
Just Cause 3 1.86 73 65 1 1 0 0 2015
Mafia III 1.81 68 51 1 1 0 0 2016
Forza Motorsport 6 1.8 87 79 0 0 0 1 2015
The Evil Within 1.79 75 73 1 1 0 0 2014
Madden NFL 17 1.75 82 49 0 1 0 0 2016
Wii Party U 1.75 65 68 0 0 1 0 2013
The Order: 1886 1.74 63 66 1 1 0 0 2015
Knack 1.73 54 65 0 1 0 0 2013
The Crew 1.72 61 54 0 1 0 0 2014
NBA 2K15 1.72 82 63 0 0 0 1 2014
No Man's Sky 1.7 71 45 0 1 0 0 2016
Until Dawn 1.66 79 82 1 1 0 0 2015
Dark Souls III 1.65 89 88 1 1 0 0 2016
Far Cry 4 1.63 82 75 1 0 0 1 2014
LEGO Marvel Super Heroes 1.62 83 77 0 1 0 0 2013
Mario Party 10 1.58 66 65 0 0 1 0 2015
Dead Rising 3 1.57 78 68 1 0 0 1 2013
Watch Dogs 1.57 78 58 1 0 0 1 2014
Madden NFL 15 1.57 80 64 0 0 0 1 2014
Wolfenstein: The New Order 1.55 79 81 1 1 0 0 2014
Donkey Kong Country: Tropical Freeze 1.52 83 89 0 0 1 0 2014
Batman: Arkham Knight 1.49 85 66 1 0 0 1 2015
NBA 2K14 1.45 85 65 0 1 0 0 2013
Forza Horizon 2 1.4 86 82 0 0 0 1 2014
Ryse: Son of Rome 1.38 60 61 1 0 0 1 2013
Mortal Kombat X 1.38 86 73 1 0 0 1 2015
Rise of the Tomb Raider 1.38 86 80 1 0 0 1 2015
Middle-Earth: Shadow of Mordor 1.35 87 80 1 0 0 1 2014
Gears of War 4 1.35 84 62 1 0 0 1 2016
Tom Clancy's Rainbow Six: Siege 1.34 74 69 1 0 0 1 2015
The Witcher 3: Wild Hunt 1.31 91 92 1 0 0 1 2015
Yoshi's Woolly World 1.3 78 85 0 0 1 0 2015
Assassin's Creed Syndicate 1.3 78 61 1 0 0 1 2015
Dying Light 1.29 74 78 1 0 0 1 2015
The Elder Scrolls Online 1.28 77 84 1 0 0 1 2015
Metal Gear Solid V: Ground Zeroes 1.27 75 62 1 1 0 0 2014
Madden NFL 17 1.23 83 59 0 0 0 1 2016
Hyrule Warriors 1.23 76 83 0 0 1 0 2014
WWE 2K16 1.21 73 74 0 1 0 0 2015
Battlefield: Hardline 1.21 71 51 1 0 0 1 2015
Captain Toad: Treasure Tracker 1.19 81 86 0 0 1 0 2014
Destiny: The Taken King 1.19 89 52 0 0 0 1 2015
FIFA 14 1.16 88 58 0 0 0 1 2013
WWE 2K15 1.15 62 51 0 1 0 0 2014
Sunset Overdrive 1.14 81 77 1 0 0 1 2014
Naruto Shippuden: Ultimate Ninja Storm 4 1.14 79 82 0 1 0 0 2016
Watch Dogs 2 1.13 83 78 1 1 0 0 2016
Alien: Isolation 1.13 79 81 1 1 0 0 2014
Pikmin 3 1.11 87 87 0 0 1 0 2013
Dragon Ball: XenoVerse 1.11 69 77 0 1 0 0 2015
LEGO City Undercover 1.1 80 82 0 0 1 0 2013
Project CARS 1.09 83 66 0 1 0 0 2015
Forza Horizon 3 1.08 91 74 0 0 0 1 2016
Overwatch 1.06 91 56 0 0 0 1 2016
LEGO Marvel Super Heroes 1.06 80 68 0 0 0 1 2013
EA Sports UFC 1.05 70 61 0 1 0 0 2014
The Legend of Zelda: Twilight Princess HD 1.03 86 84 0 0 1 0 2016
NBA 2K17 1.02 90 62 0 0 0 1 2016
Rayman Legends 1.01 90 85 0 1 0 0 2014
Pokken Tournament 1.01 76 80 0 0 1 0 2016