Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Name Platform Year_of_ReGenre Publisher NA_Sales EU_Sales JP_Sales Other_SaleGlobal_Sal Grand ThefPS4 2014 Action Take-Two In 3.96 6.31 0.38 1.97 12.61 FIFA 16 PS4 2015 Sports Electronic
Name Platform Year_of_ReGenre Publisher NA_Sales EU_Sales JP_Sales Other_SaleGlobal_Sal Grand ThefPS4 2014 Action Take-Two In 3.96 6.31 0.38 1.97 12.61 FIFA 16 PS4 2015 Sports Electronic 1.12 6.12 0.06 1.28 8.57 Call of Du PS4 2014 Shooter Activision 2.81 3.48 0.14 1.23 7.66 FIFA 17 PS4 2016 Sports Electronic 0.66 5.75 0.08 1.11 7.59 Fallout 4 PS4 2015 Role-PlayinBethesda S 2.53 3.27 0.24 1.13 7.16 Mario Kart WiiU 2014 Racing Nintendo 3.15 2.15 1.28 0.51 7.09 FIFA 15 PS4 2014 Sports Electronic 0.8 4.33 0.05 0.9 6.08 Destiny PS4 2014 Shooter Activision 2.49 2.07 0.16 0.92 5.64 Grand ThefXOne 2014 Action Take-Two In 2.81 2.19 0 0.47 5.48 Uncharted PS4 4 2016 Shooter Sony Compu 1.85 2.5 0.19 0.85 5.38 Call of Du XOne 2014 Shooter Activision 3.22 1.55 0.01 0.48 5.27 Uncharted:PS4 2015 Action Sony Compu 2.07 1.71 0.08 0.76 4.62 Halo 5: Gu XOne 2015 Shooter Microsoft 2.78 1.27 0.03 0.41 4.48 Call of Dut PS4 2016 Shooter Activision 1.61 2 0.15 0.71 4.46 Splatoon WiiU 2015 Shooter Nintendo 1.54 1.18 1.46 0.26 4.43 Super MariWiiU 2013 Platform Nintendo 2.11 1.16 0.73 0.32 4.32 Fallout 4 XOne 2015 Role-PlayinBethesda S 2.51 1.32 0.01 0.38 4.22 Battlefield PS4 2016 Shooter Electronic 1.1 2.15 0.21 0.61 4.08 Watch DogPS4 2014 Action Ubisoft 1.4 1.9 0.11 0.64 4.05 Far Cry 4 PS4 2014 Shooter Ubisoft 1.13 2.18 0.1 0.63 4.04 The WitchePS4 2015 Role-PlayinNamco Ban 1.02 2.13 0.23 0.59 3.97 Assassin's PS4 2014 Action Ubisoft 1.19 2.07 0.08 0.62 3.96 Batman: ArPS4 2015 Action Warner Bros 1.53 1.69 0.1 0.64 3.95 NBA 2K16 PS4 2015 Sports Take-Two In 2.49 0.66 0.03 0.69 3.88 Call of Dut PS4 2013 Shooter Activision 1.78 1.43 0.05 0.57 3.83 Tom Clancy'PS4 2016 Shooter Ubisoft 1.35 1.7 0.15 0.6 3.8 Battlefield PS4 2013 Shooter Electronic 1.35 1.55 0.17 0.51 3.59 Assassin's XOne 2014 Action Ubisoft 2.27 0.9 0 0.33 3.5 Metal GearPS4 2015 Action Konami Dig 1.09 1.36 0.49 0.48 3.41 Assassin's PS4 2015 Action Ubisoft 0.81 1.99 0.07 0.52 3.39 Destiny XOne 2014 Shooter Activision 2.14 0.92 0 0.31 3.37 Gears of Wa XOne 2015 Shooter Microsoft 2.61 0.33 0 0.34 3.28 FIFA 16 XOne 2015 Sports Electronic 0.89 2.12 0 0.24 3.25 Madden NFPS4 2015 Sports Electronic 2.34 0.3 0 0.6 3.24 Halo: The M XOne 2014 Shooter Microsoft 1.91 1 0.03 0.29 3.23 Super MariWiiU 2015 Platform Nintendo 1.18 0.89 0.94 0.2 3.21 FIFA 14 PS4 2013 Sports Electronic 0.61 1.85 0.11 0.44 3.01 Middle-EarPS4 2014 Action Warner Bros 1.01 1.43 0.05 0.47 2.96 Titanfall XOne 2014 Shooter Electronic 1.84 0.8 0.04 0.27 2.95 Call of Dut XOne 2013 Shooter Activision 1.88 0.77 0 0.27 2.92 Assassin's PS4 2013 Action Ubisoft 1.07 1.31 0.06 0.42 2.85 inFAMOUS:PS4 2014 Action Sony Compu 1.28 0.98 0.07 0.46 2.79 Mortal KomPS4 2015 Fighting Warner Bros 1.5 0.8 0 0.48 2.78 Killzone: S PS4 2013 Shooter Sony Compu 0.89 1.33 0.08 0.39 2.69 FIFA 17 XOne 2016 Sports Electronic 0.43 2.05 0 0.17 2.65 Bloodborn PS4 2015 Action Sony Compu 1.03 0.81 0.26 0.38 2.48 NBA 2K15 PS4 2014 Sports Take-Two In 1.47 0.54 0.01 0.43 2.45 Call of Dut XOne 2016 Shooter Activision 1.46 0.74 0 0.22 2.42 Madden NFXOne NBA 2K16 XOne Far Cry: Pr PS4 Battlefield XOne New SuperWiiU Assassin's XOne Tom Clancy'PS4 Forza MotoXOne Madden NFPS4 FIFA 15 XOne Tom Clancy'XOne OverwatchPS4 Battlefield PS4 Dying LightPS4 DriveClub PS4 Battlefield XOne Dragon Age: PS4 Need for SpPS4 Destiny: ThPS4 LittleBigPl PS4 NBA 2K17 PS4 Just Cause PS4 Mafia III PS4 Forza MotoXOne The Evil WiPS4 Madden NFPS4 Wii Party UWiiU The Order:PS4 Knack PS4 The Crew PS4 NBA 2K15 XOne No Man's SPS4 Until DawnPS4 Dark Souls PI S4 Far Cry 4 XOne LEGO Marve PS4 Mario PartWiiU Dead RisingXOne Watch DogXOne Madden NFXOne WolfensteiPS4 Donkey KonWiiU Batman: ArXOne NBA 2K14 PS4 Forza HorizXOne Ryse: Son XOne Mortal KomXOne Rise of the XOne 2015 Sports Electronic 2015 Sports Take-Two In 2016 Action Ubisoft 2016 Shooter Electronic 2013 Platform Nintendo 2013 Action Ubisoft 2015 Shooter Ubisoft 2013 Racing Microsoft 2014 Sports Electronic 2014 Sports Electronic 2016 Shooter Ubisoft 2016 Shooter Activision 2015 Shooter Electronic 2015 Action Warner Bros 2014 Racing Sony Compu 2013 Shooter Electronic 2014 Role-PlayinElectronic 2013 Racing Electronic 2015 Shooter Activision 2014 Platform Sony Compu 2016 Sports Take-Two In 2015 Action Square Eni 2016 Action Take-Two In 2015 Racing Microsoft 2014 Action Bethesda S 2016 Sports Electronic 2013 Misc Nintendo 2015 Shooter Sony Compu 2013 Platform Sony Compu 2014 Racing Ubisoft 2014 Sports Take-Two In 2016 Action Hello Game 2015 Adventure Sony Compu 2016 Role-PlayinNamco Ban 2014 Shooter Ubisoft 2013 Action Warner Bros 2015 Misc Nintendo 2013 Action Microsoft 2014 Action Ubisoft 2014 Sports Electronic 2014 Shooter Bethesda S 2014 Platform Nintendo 2015 Action Warner Bros 2013 Sports Take-Two In 2014 Racing Microsoft 2013 Action Microsoft 2015 Fighting Warner Bros 2015 Adventure Square Eni 2.08 1.95 0.6 1.28 1.25 1.48 0.55 1.21 1.54 0.6 1.29 0.81 0.71 0.96 0.36 1.25 0.73 0.73 0.78 0.66 1.25 0.47 0.42 0.73 0.55 1.25 0.3 0.61 0.43 0.35 1.37 0.63 0.45 0.65 0.8 0.59 0.69 1.06 0.9 1.31 0.47 0.7 0.88 0.89 0.5 0.83 1.03 0.55 0.08 0.15 1.25 0.77 0.62 0.55 1.19 0.79 0.25 1.42 0.68 0.85 0.94 0.67 1.38 0.58 0.88 0.92 0.79 0.93 0.27 1.03 1.08 0.9 0.86 0.17 0.56 0.78 0.68 1.08 0.18 0.76 0.9 0.45 0.69 0.76 0.53 0.35 0.53 0.09 0.8 0.55 0.47 0.31 0.78 0.43 0.21 0.7 0 0 0.06 0 0.18 0 0.14 0.01 0 0 0 0.15 0.14 0.12 0.02 0 0.08 0.03 0.04 0.01 0.02 0.07 0.03 0.03 0.11 0 0.84 0.06 0.42 0.03 0 0.03 0.05 0.34 0.01 0.01 0.24 0.01 0 0 0.03 0.16 0 0.01 0.01 0 0 0.02 0.26 0.24 0.35 0.2 0.18 0.21 0.33 0.19 0.4 0.16 0.2 0.33 0.32 0.34 0.31 0.19 0.32 0.3 0.31 0.31 0.34 0.28 0.28 0.14 0.27 0.32 0.05 0.27 0.2 0.26 0.18 0.27 0.26 0.22 0.14 0.26 0.12 0.15 0.14 0.16 0.24 0.12 0.14 0.23 0.11 0.13 0.14 0.11 2.42 2.34 2.26 2.25 2.24 2.23 2.21 2.2 2.19 2.18 2.16 2.14 2.1 2.09 2.07 2.02 2.01 1.98 1.93 1.91 1.88 1.86 1.81 1.8 1.79 1.75 1.75 1.74 1.73 1.72 1.72 1.7 1.66 1.65 1.63 1.62 1.58 1.57 1.57 1.57 1.55 1.52 1.49 1.45 1.4 1.38 1.38 1.38 Middle-EarXOne Gears of WXOne Tom Clancy'XOne The WitcheXOne Yoshi's WooWiiU Assassin's XOne Dying LightXOne The Elder SXOne Metal GearPS4 Madden NFXOne Hyrule WarWiiU WWE 2K16PS4 Battlefield XOne Captain ToaWiiU Destiny: ThXOne FIFA 14 XOne WWE 2K15PS4 Sunset OveXOne Naruto Shi PS4 Watch DogsPS4 Alien: IsolaPS4 Pikmin 3 WiiU Dragon BalPS4 LEGO City WiiU Project CA PS4 Forza HorizXOne OverwatchXOne LEGO Marve XOne EA Sports PS4 The LegendWiiU NBA 2K17 XOne Rayman LePS4 Pokken To WiiU 2014 Action Warner Bros 2016 Shooter Microsoft 2015 Shooter Ubisoft 2015 Role-PlayinNamco Ban 2015 Platform Nintendo 2015 Action Ubisoft 2015 Action Warner Bros 2015 Role-PlayinBethesda S 2014 Action Konami Dig 2016 Sports Electronic 2014 Action Nintendo 2015 Sports Take-Two In 2015 Shooter Electronic 2014 Puzzle Nintendo 2015 Shooter Activision 2013 Sports Electronic 2014 Sports Take-Two In 2014 Shooter Microsoft 2016 Fighting Namco Ban 2016 Action Ubisoft 2014 Shooter Sega 2013 Strategy Nintendo 2015 Fighting Namco Ban 2013 Platform Nintendo 2015 Racing Slightly Ma 2016 Racing Microsoft 2016 Shooter Activision 2013 Action Warner Bros 2014 Sports Electronic 2016 Action Nintendo 2016 Sports Take-Two In 2014 Platform Ubisoft 2016 Fighting Namco Ban 0.73 0.78 0.77 0.69 0.62 0.62 0.86 0.78 0.45 1.08 0.58 0.41 0.72 0.53 0.85 0.41 0.39 0.63 0.41 0.37 0.34 0.44 0.3 0.47 0.2 0.42 0.63 0.61 0.46 0.56 0.86 0.22 0.5 0.5 0.44 0.45 0.5 0.47 0.56 0.3 0.38 0.47 0.02 0.42 0.6 0.37 0.38 0.23 0.66 0.57 0.4 0.45 0.58 0.57 0.32 0.52 0.42 0.7 0.58 0.33 0.35 0.41 0.3 0.06 0.64 0.26 0.01 0 0 0 0.11 0 0.01 0 0.17 0 0.13 0 0.01 0.19 0 0 0 0 0.11 0 0.04 0.29 0.12 0.13 0.02 0 0 0 0.01 0.08 0 0 0.17 0.12 0.12 0.12 0.11 0.1 0.11 0.12 0.12 0.18 0.13 0.1 0.2 0.11 0.09 0.12 0.09 0.19 0.1 0.17 0.18 0.17 0.07 0.16 0.08 0.16 0.08 0.1 0.09 0.17 0.09 0.11 0.16 0.08 1.35 1.35 1.34 1.31 1.3 1.3 1.29 1.28 1.27 1.23 1.23 1.21 1.21 1.19 1.19 1.16 1.15 1.14 1.14 1.13 1.13 1.11 1.11 1.1 1.09 1.08 1.06 1.06 1.05 1.03 1.02 1.01 1.01 Critic_ScorCritic_CounUser_ScoreUser_CounDeveloper Rating 97 66 8.3 2899 Rockstar N M 82 42 4.3 896 EA Sports E 83 39 5.7 1443 SledgehamM 85 41 5 398 EA Sports, E 87 58 6.5 4228 Bethesda GM 88 82 9.1 1599 Nintendo E 82 47 5.7 988 EA Sports E 76 95 6.1 5380 Bungie SofT 97 14 7.9 764 Rockstar N M 93 113 7.9 7064 Naughty D T 81 53 5.4 898 SledgehamM 86 78 8.1 1264 Bluepoint T 84 101 6.4 2438 343 IndustrT 77 82 3.4 1129 Infinity WaM 81 88 8.5 1184 Nintendo E10+ 93 83 9 1607 Nintendo E 88 39 6.2 1749 Bethesda GM 88 31 8.4 809 EA DICE M 80 80 6.3 2996 Ubisoft MoM 85 83 7.7 1653 Ubisoft MoM 92 79 9.2 10179 CD Projekt M 70 40 4.9 2050 Ubisoft, UbM 87 89 7.6 2679 RocksteadyM 87 51 6.7 364 Visual Con E10+ 78 49 3.7 1564 Infinity WaM 80 64 7 2219 Massive EnM 85 18 6.9 1580 EA DICE M 72 59 4.1 1005 Ubisoft, UbM 93 86 8.2 3943 Kojima ProM 76 86 6.8 1319 Ubisoft QuM 75 11 5.5 1735 Bungie SofT 82 74 7.5 563 Splash DamM 84 45 4.4 459 EA Sports E 83 37 5.9 180 EA Sports E 85 69 7.2 1267 343 IndustrM 88 85 8.7 691 Nintendo E 87 26 6.3 616 EA Canada E 84 85 8.1 1886 Monolith PM 86 68 6.4 2658 Respawn EnM 78 7 4.3 700 Infinity WaM 83 29 7.8 1530 Ubisoft M 80 90 7.9 2944 Sucker PunT 83 81 7.7 836 Warner BroM 73 88 6.8 2102 Guerrilla M 84 50 5.5 201 EA Sports, E 92 100 8.6 6383 From SoftwM 83 50 7 291 Visual Con E 78 17 3.1 290 Infinity WaM 84 86 76 87 77 89 73 79 81 82 80 90 73 74 71 81 89 80 86 79 88 73 68 87 75 82 65 63 54 61 82 71 79 89 82 83 66 78 78 80 79 83 85 85 86 60 86 86 23 14 91 37 59 3 40 76 37 33 33 31 46 58 85 5 43 53 81 78 47 42 66 85 65 35 38 94 83 60 9 94 103 69 15 22 66 69 15 19 73 77 16 20 85 77 21 102 6.1 6.2 6.3 8.2 7.9 7.4 7.3 5.9 6.1 5.4 6.9 6.1 5 7.9 6.1 6.6 7.4 6.2 6 7.1 6.7 6.5 5.1 7.9 7.3 4.9 6.8 6.6 6.5 5.4 6.3 4.5 8.2 8.8 7.5 7.7 6.5 6.8 5.8 6.4 8.1 8.9 6.6 6.5 8.2 6.1 7.3 8 124 EA Sports E 115 Visual Con E10+ 635 Ubisoft MoM 440 EA DICE M 288 Nintendo E 355 Ubisoft M 480 Ubisoft MoM 1095 Turn 10 E 208 EA Sports E 347 EA Sports E 614 Massive EnM 1358 Blizzard EnT 845 Visceral G M 1287 Techland M 1571 Evolution SE 480 EA DICE M 1984 BioWare M 667 Ghost GamE10+ 1079 Bungie T 506 Sumo DigitE 162 Visual Con E 403 Avalanche M 1147 Hangar 13 M 863 Turn 10 E 1223 Tango GamM 83 EA Sports E 135 Nd Cube E 3172 Ready at DM 1074 SCE Japan E10+ 575 Ubisoft RefT 101 Visual Con E 5096 Hello GameT 2161 SuperMassM 1940 From SoftwM 383 Ubisoft MoM 262 TT Games E10+ 279 Nintendo, E 908 Capcom VaM 712 Ubisoft MoM 138 EA Sports E 1116 MachineG M 712 Retro StudiE 694 RocksteadyM 368 Visual Con E 977 Playgroun E10+ 1409 Crytek M 279 Warner BroM 1288 Crystal Dy M 87 84 74 91 78 78 74 77 75 83 76 73 71 81 89 88 62 81 79 83 79 87 69 80 83 91 91 80 70 86 90 90 76 12 96 24 13 83 22 26 11 70 30 81 47 27 78 11 22 44 89 60 88 50 79 50 66 37 90 18 10 57 74 17 16 74 8 6.2 6.9 9.2 8.5 6.1 7.8 8.4 6.2 5.9 8.3 7.4 5.1 8.6 5.2 5.8 5.1 7.7 8.2 7.8 8.1 8.7 7.7 8.2 6.6 7.4 5.6 6.8 6.1 8.4 6.2 8.5 8 585 Monolith PM 815 The Coaliti M 252 Ubisoft MoM 3963 CD Projekt M 376 Good-Feel E 402 Ubisoft QuM 387 Techland M 613 ZeniMax MM 1311 Kojima ProM 39 EA Sports E 662 Omega ForT 237 Yuke's T 299 Visceral G M 377 Nintendo EE 393 Bungie SofT 328 EA Canada E 164 Yuke's T 1137 Insomniac M 201 CyberConnT 621 Ubisoft MoM 795 Creative A M 664 Nintendo E10+ 598 Dimps CorpT 283 TT Games E10+ 363 Slightly MaE 594 Playgroun E 668 Blizzard EnT 73 TT Games E10+ 279 EA Sports T 329 Tantalus InT 91 Visual Con E 525 Ubisoft Mon E10+ 273 Bandai Na E10+ Variable Name Platform Year_of_Release Genre Publisher NA_Sales EU_Sales JP_Sales Other_Sales Global_Sales Critic_Score Critic_Count User_Score User_Count Developer Rating Mature PS4 WiiU Xone Description Name of the game Console on which the game is running Help us describe this column Help us describe this column Help us describe this column Game sales in North America (in millions of units) Game sales in the European Union (in millions of units) Game sales in Japan (in millions of units) Game sales in the rest of the world, i.e. Africa, Asia excluding Japan, Australia, Europe excluding the E.U. and South Americ Total sales in the world (in millions of units) Aggregate score compiled by Metacritic staf The number of critics used in coming up with the Critic_score Score by Metacritic's subscribers Number of users who gave the user_score Party responsible for creating the game The ESRB ratings (E.g. Everyone, Teen, Adults Only..etc) Dummy Variable where the ESRB rating is Adults Only Dummy variable indicating the game was released on the PS4 Dummy variable indicating the game was released on the WiiU Dummy variable indicating the game was released on the Xbox One Data Type String String Numeric String String Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric String String Name Grand Theft Auto V FIFA 16 Call of Duty: Advanced Warfare FIFA 17 Fallout 4 Mario Kart 8 FIFA 15 Destiny Grand Theft Auto V Uncharted 4: A Thief's End Call of Duty: Advanced Warfare Uncharted: The Nathan Drake Collection Halo 5: Guardians Call of Duty: Infinite Warfare Splatoon Super Mario 3D World Fallout 4 Battlefield 1 Watch Dogs Far Cry 4 The Witcher 3: Wild Hunt Assassin's Creed: Unity Batman: Arkham Knight NBA 2K16 Call of Duty: Ghosts Tom Clancy's The Division Battlefield 4 Assassin's Creed: Unity Metal Gear Solid V: The Phantom Pain Assassin's Creed Syndicate Destiny Gears of War: Ultimate Edition FIFA 16 Madden NFL 16 Halo: The Master Chief Collection Super Mario Maker FIFA 14 Middle-Earth: Shadow of Mordor Titanfall Call of Duty: Ghosts Assassin's Creed IV: Black Flag inFAMOUS: Second Son Mortal Kombat X Killzone: Shadow Fall FIFA 17 Bloodborne NBA 2K15 Call of Duty: Infinite Warfare Global_Sales Critic_Score User_Score Mature 12.61 97 83 8.57 82 43 7.66 83 57 7.59 85 50 7.16 87 65 7.09 88 91 6.08 82 57 5.64 76 61 5.48 97 79 5.38 93 79 5.27 81 54 4.62 86 81 4.48 84 64 4.46 77 34 4.43 81 85 4.32 93 90 4.22 88 62 4.08 88 84 4.05 80 63 4.04 85 77 3.97 92 92 3.96 70 49 3.95 87 76 3.88 87 67 3.83 78 37 3.8 80 70 3.59 85 69 3.5 72 41 3.41 93 82 3.39 76 68 3.37 75 55 3.28 82 75 3.25 84 44 3.24 83 59 3.23 85 72 3.21 88 87 3.01 87 63 2.96 84 81 2.95 86 64 2.92 78 43 2.85 83 78 2.79 80 79 2.78 83 77 2.69 73 68 2.65 84 55 2.48 92 86 2.45 83 70 2.42 78 31 1 0 1 0 1 0 0 0 1 0 1 0 0 1 0 0 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 1 0 0 1 0 0 1 1 1 1 0 1 1 0 1 0 1 Madden NFL 16 NBA 2K16 Far Cry: Primal Battlefield 1 New Super Luigi U Assassin's Creed IV: Black Flag Tom Clancy's Rainbow Six: Siege Forza Motorsport 5 Madden NFL 15 FIFA 15 Tom Clancy's The Division Overwatch Battlefield: Hardline Dying Light DriveClub Battlefield 4 Dragon Age: Inquisition Need for Speed Rivals Destiny: The Taken King LittleBigPlanet 3 NBA 2K17 Just Cause 3 Mafia III Forza Motorsport 6 The Evil Within Madden NFL 17 Wii Party U The Order: 1886 Knack The Crew NBA 2K15 No Man's Sky Until Dawn Dark Souls III Far Cry 4 LEGO Marvel Super Heroes Mario Party 10 Dead Rising 3 Watch Dogs Madden NFL 15 Wolfenstein: The New Order Donkey Kong Country: Tropical Freeze Batman: Arkham Knight NBA 2K14 Forza Horizon 2 Ryse: Son of Rome Mortal Kombat X Rise of the Tomb Raider 2.42 2.34 2.26 2.25 2.24 2.23 2.21 2.2 2.19 2.18 2.16 2.14 2.1 2.09 2.07 2.02 2.01 1.98 1.93 1.91 1.88 1.86 1.81 1.8 1.79 1.75 1.75 1.74 1.73 1.72 1.72 1.7 1.66 1.65 1.63 1.62 1.58 1.57 1.57 1.57 1.55 1.52 1.49 1.45 1.4 1.38 1.38 1.38 84 86 76 87 77 89 73 79 81 82 80 90 73 74 71 81 89 80 86 79 88 73 68 87 75 82 65 63 54 61 82 71 79 89 82 83 66 78 78 80 79 83 85 85 86 60 86 86 61 62 63 82 79 74 73 59 61 54 69 61 50 79 61 66 74 62 60 71 67 65 51 79 73 49 68 66 65 54 63 45 82 88 75 77 65 68 58 64 81 89 66 65 82 61 73 80 0 0 1 1 0 1 1 0 0 0 1 0 1 1 0 1 1 0 0 0 0 1 1 0 1 0 0 1 0 0 0 0 1 1 1 0 0 1 1 0 1 0 1 0 0 1 1 1 Middle-Earth: Shadow of Mordor Gears of War 4 Tom Clancy's Rainbow Six: Siege The Witcher 3: Wild Hunt Yoshi's Woolly World Assassin's Creed Syndicate Dying Light The Elder Scrolls Online Metal Gear Solid V: Ground Zeroes Madden NFL 17 Hyrule Warriors WWE 2K16 Battlefield: Hardline Captain Toad: Treasure Tracker Destiny: The Taken King FIFA 14 WWE 2K15 Sunset Overdrive Naruto Shippuden: Ultimate Ninja Storm 4 Watch Dogs 2 Alien: Isolation Pikmin 3 Dragon Ball: XenoVerse LEGO City Undercover Project CARS Forza Horizon 3 Overwatch LEGO Marvel Super Heroes EA Sports UFC The Legend of Zelda: Twilight Princess HD NBA 2K17 Rayman Legends Pokken Tournament 1.35 1.35 1.34 1.31 1.3 1.3 1.29 1.28 1.27 1.23 1.23 1.21 1.21 1.19 1.19 1.16 1.15 1.14 1.14 1.13 1.13 1.11 1.11 1.1 1.09 1.08 1.06 1.06 1.05 1.03 1.02 1.01 1.01 87 84 74 91 78 78 74 77 75 83 76 73 71 81 89 88 62 81 79 83 79 87 69 80 83 91 91 80 70 86 90 90 76 80 62 69 92 85 61 78 84 62 59 83 74 51 86 52 58 51 77 82 78 81 87 77 82 66 74 56 68 61 84 62 85 80 1 1 1 1 0 1 1 1 1 0 0 0 1 0 0 0 0 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 PS4 WiiU 1 1 1 1 1 0 1 1 0 1 0 1 0 1 0 0 0 1 1 1 1 1 1 1 1 1 1 0 1 1 0 0 0 1 0 0 1 1 0 0 1 1 1 1 0 1 1 0 Xone 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 1 1 0 1 0 0 0 1 1 0 0 0 0 1 0 0 1 Year_of_Release 2014 2015 2014 2016 2015 2014 2014 2014 2014 2016 2014 2015 2015 2016 2015 2013 2015 2016 2014 2014 2015 2014 2015 2015 2013 2016 2013 2014 2015 2015 2014 2015 2015 2015 2014 2015 2013 2014 2014 2013 2013 2014 2015 2013 2016 2015 2014 2016 0 0 1 0 0 0 1 0 1 0 0 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 0 1 1 1 0 1 1 1 0 1 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 1 0 1 0 1 0 1 0 1 1 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 1 0 0 1 1 1 0 0 1 0 1 1 1 1 2015 2015 2016 2016 2013 2013 2015 2013 2014 2014 2016 2016 2015 2015 2014 2013 2014 2013 2015 2014 2016 2015 2016 2015 2014 2016 2013 2015 2013 2014 2014 2016 2015 2016 2014 2013 2015 2013 2014 2014 2014 2014 2015 2013 2014 2013 2015 2015 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 1 0 1 1 1 0 1 0 1 0 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 1 0 0 1 1 1 1 1 0 1 1 1 0 1 0 0 1 0 1 1 0 1 0 0 0 0 0 0 0 1 1 1 0 0 1 0 0 2014 2016 2015 2015 2015 2015 2015 2015 2014 2016 2014 2015 2015 2014 2015 2013 2014 2014 2016 2016 2014 2013 2015 2013 2015 2016 2016 2013 2014 2016 2016 2014 2016 Cover sheet for submission of work for assessment School: Economics, Finance and Marketing Program Name Course/unit name Business Statistics 1 Due Date 28 May 2017 Program Code Course/unit code ECON1030 Name of Lecturer Tutor's Name Tutorial Day/Time STUDENT/S Family name Given name Student number (1) (2) (3) DECLARATION AND STATEMENT OF AUTHORSHIP 1. 2. 3. 4. 5. 6. I/we hold a copy of this work which can be produced if the original is lost/damaged. This work is my/our original work and no part of it has been copied from any other student's work or from any other source except where due acknowledgement is made. No part of this work has been written for me/us by any other person except where such collaboration has been authorized by the lecturer/teacher concerned. I/we have not previously submitted this work for this or any other course/unit. I/we give permission for this work to be reproduced, communicated, compared and archived for the purpose of detecting plagiarism. I/we give permission for a copy of my/our marked work to be retained by the school for review and comparison, including review by external examiners. I/we understand that: 7. 8. Plagiarism is the presentation of the work, idea or creation of another person as though it is my/our own. It is a form of cheating and is a very serious academic offence that may lead to exclusion from the University. Plagiarised material can be drawn from, and presented in, written, graphic and visual form, including electronic data and oral presentations. Plagiarism occurs when the origin of the material used is not appropriately cited. Plagiarism includes the act of assisting or allowing another person to plagiarise or to copy my/our work. Student signature/s I/we declare that I/we have read and understood the declaration and statement of authorship. (1) (2) (3) Further information relating to the penalities for plagiarism, which range from a notation on your student file to expulsion from the University, is contained in Regulation 6.1.1 Student Discipline and the Plagiarism Policy which are available on the Policies and Procedures website at www.rmit.edu.au/policies. ECON 1030 - BUSINESS STATISTICS 1 PROJECT (MONDAY Tutorial) Due: 28 May at 23:59 Instructions: This is a project where you can work alone or with two other students (a maximum group size of three). All group members will receive the same marks for the assignment. All group members must be enrolled in the same tutorial. The assignment must be provided in the form of a (brief) business report approximately 8-14 pages. Please see the Project page in Blackboard for details on what to include in the business report. You must submit an electronic copy of your assignment in Blackboard. Hard copies will not be accepted. SHOW YOUR WORK for calculation based questions. This assignment requires the use of Microsoft Excel. If you have Windows, you will also need to use the Data Analysis ToolPak. If you have a Mac with Excel 2011, you will need to use StatPlus:MAC LE. Problem Description: A local game retailer has asked us to evaluate global video game sales for the current generation of consoles. We have collected data on 129 video game sales in which globally sold in excess of 1 million units. We have included critic and user ratings and the type of console. You will use descriptive statistics, inferential statistics and your knowledge of multiple linear regression to complete this task. Global Sales (Dependent Variable) and several characteristics (Independent Variables) are given in the Excel file: MondayTuesday.xlsx. You can find the data that we will use in the project in the \"Processed\" tab with the definitions of the variables in the \"Dictionary\" tab. Required: A. Calculate the descriptive statistics from the data and display in a table. Be sure to comment on the central tendency, variability and shape for Global Sales, Critic Score and User Score. How would you interpret the mean of dummy variables such as Mature or Xone? (1 Mark) B. Draw a graph that displays the distribution of Global Sales. Be sure to comment on the distribution. Does it appear normally distributed? (1 Mark) C. Create a box-and-whisker plot for the distribution of User Ratings and describe the shape. Is there evidence of outliers in the data? (1 Mark) D. What is the probability that we could randomly select a game where the global sales is greater than 2 million units? What is the likelihood that the sales exceed 2 million units for games that are rated as mature? Is the sales statistically independent of whether they are rated as mature? Use a Contingency Table. (2 Marks) E. Estimate the 95% confidence interval for the population mean critic score. How does this compare to the 95% confidence interval for the population mean user score? (1 Mark) F. A fellow student recently stated that any of the major games released, those selling in excess of 5 million units, almost always have a mean user score higher than 60. Test her claim at the 10% level of significance. (1 Mark) G. Run a multiple linear regression using the data and show the output from Excel. Exclude the dummy variable Xone from the regression results as well as Year. (1/2 Mark) H. Is the coefficient estimate for the Critic Score statistically different than zero at the 5% level of significance? Set-up the correct hypothesis test using the results found in the table in Part (G) using both the critical value and p-value approach. Interpret the coefficient estimate of the slope. (2 Marks) I. Interpret the remaining slope coefficient estimates. Discuss whether the signs are what you are expecting and explain your reasoning. (2 Marks) J. Interpret the value of the Adjusted R 2. Is there a large difference between the R 2 and the Adjusted R2? If so, what may explain the reasoning for this? (1/2 Mark) K. Is the overall model statistically significant at the 5% level of significance? Use the p-value approach. (1/2 Mark) L. Based on the results of the regressions, what other factors would have influenced global sales? Provide a couple possible examples and indicate their predicted relationship with sales if they were included. (1 Mark) M. Predict the average sales of a game that is not rated mature with a critic score of 95, a user score of 60 that is released on the WiiU. Discuss if it is appropriate to do predict under these conditions. Show the predicted regression equation. (1 Mark) N. Do the results suggest that the data satisfy the assumptions of a linear regression: Linearity, Normality of the Errors, and Homoscedasticity of Errors? Show using scatter diagrams, normal probability plots and/or histograms and Explain. (1 1/2 Marks) O. Does this data indicate the true population distribution of console sales? Explain and if not, describe a sampling procedure that could lead to more accurate results. (1 Mark) P. Construct Sales Indexes for each console using 2013 as a base year. Which console had the strongest growth between 2013 and 2016? (1 Mark) Allocation of Marks: Professional Business Report Part A Part B Part C Part D Part E Part F Part G Part H Part I Part J Part K Part L Part M Part N Part O Part P Total: 2 Marks 1 Mark 1 Mark 1 Mark 2 Marks 1 Mark 1 Mark 1/2 Mark 2 Marks 2 Marks 1/2 Mark 1/2 Mark 1 Mark 1 Mark 1 1/2 Marks 1 Mark 1 Mark 20 Marks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started