excel

profileolaz
games.xlsx

VideoGameSales

Name Platform Year Genre Publisher NorthAmerica Europe Japan Other GlobalSales
Jeopardy! 2nd Edition PS 2000 Misc Hasbro Interactive $ 0.16 $ 0.11 $ - 0 $ 0.02 $ 0.29
TrackMania Turbo PS4 2016 Action Ubisoft $ 0.03 $ 0.24 $ - 0 $ 0.05 $ 0.32
Touch Detective: Nameko Shigeru 3DS 2013 Adventure Success $ - 0 $ - 0 $ 0.07 $ - 0 $ 0.07
NHL 16 PS3 2015 Sports Electronic Arts $ - 0 $ 0.03 $ - 0 $ 0.01 $ 0.04
Ride PS4 2015 Racing Milestone S.r.l. $ 0.03 $ 0.13 $ 0.03 $ 0.03 $ 0.22
Dragon Zakura DS DS 2007 Misc Electronic Arts $ - 0 $ - 0 $ 0.01 $ - 0 $ 0.01
Sherlock Holmes: Crimes & Punishments PS3 2014 Adventure Focus Home Interactive $ 0.03 $ 0.04 $ - 0 $ 0.01 $ 0.08
Ace Attorney Investigations 2 DS 2011 Adventure Capcom $ - 0 $ - 0 $ 0.26 $ - 0 $ 0.26
Metal Fight Beyblade DS 2009 Action Hudson Soft $ - 0 $ - 0 $ 0.09 $ - 0 $ 0.09
Farmtopia DS 2010 Simulation 505 Games $ 0.18 $ - 0 $ - 0 $ 0.01 $ 0.19
Pokemon Ranger DS 2006 Role-Playing Nintendo $ 1.29 $ 0.04 $ 0.73 $ 0.12 $ 2.18
BeatMania IIDX 16: Empress + Premium Best PS2 2009 Simulation Konami Digital Entertainment $ - 0 $ - 0 $ 0.04 $ - 0 $ 0.04
Mobile Suit Gundam Seed: Rengou vs. Z.A.F.T. Portable PSP 2007 Shooter Namco Bandai Games $ - 0 $ - 0 $ 0.12 $ - 0 $ 0.12
MiniCopter: Adventure Flight Wii 2007 Simulation 505 Games $ 0.04 $ - 0 $ - 0 $ - 0 $ 0.05
Super Speed Machines DS 2009 Racing Midas Interactive Entertainment $ 0.02 $ - 0 $ - 0 $ - 0 $ 0.02
Knockout Kings 2001 PS 2000 Fighting Electronic Arts $ 0.23 $ 0.15 $ - 0 $ 0.03 $ 0.41
Clock Zero: Shuuen no Ichibyou - ExTime PSV 2015 Action Idea Factory $ - 0 $ - 0 $ 0.02 $ - 0 $ 0.02
Walt Disney Pictures Presents: The Wild GBA 2006 Platform Disney Interactive Studios $ 0.09 $ 0.03 $ - 0 $ - 0 $ 0.13
Marker Man Adventures DS 2009 Platform Majesco Entertainment $ 0.02 $ - 0 $ - 0 $ - 0 $ 0.03
Tactics Layer: Ritina Guard Senki DS 2009 Strategy D3Publisher $ - 0 $ - 0 $ 0.01 $ - 0 $ 0.01
From TV Animation One Piece: Yume no Lufy Kaizokudan Tanjou! GB 2001 Role-Playing Banpresto $ - 0 $ - 0 $ 0.39 $ - 0 $ 0.39
Pac-Man Player's Choice Bundle GC 2003 Misc Namco Bandai Games $ 0.48 $ 0.12 $ - 0 $ 0.02 $ 0.62
Burnout Paradise X360 2008 Racing Electronic Arts $ 0.63 $ 0.58 $ 0.01 $ 0.15 $ 1.36
Prison Break: The Conspiracy PS3 2010 Action Deep Silver $ 0.05 $ 0.16 $ - 0 $ 0.05 $ 0.26
Mario Golf: Toadstool Tour GC 2003 Sports Nintendo $ 1.09 $ 0.15 $ 0.25 $ 0.04 $ 1.53
Poker for Dummies PC 2008 Misc Electronic Arts $ - 0 $ 0.01 $ - 0 $ - 0 $ 0.01
Resident Evil 5 PC 2009 Action Capcom $ 0.01 $ 0.04 $ - 0 $ 0.01 $ 0.07
Far Cry Instincts XB 2005 Shooter Ubisoft $ 0.32 $ 0.24 $ - 0 $ 0.02 $ 0.57
Grand Theft Auto: Mission Pack #1, London 1969 PS 1998 Adventure Take-Two Interactive $ 0.06 $ 0.04 $ - 0 $ 0.01 $ 0.11
SimCity SNES 1991 Simulation Nintendo $ 0.93 $ 0.27 $ 0.75 $ 0.04 $ 1.98
Data from “Video Game Sales” compiled by GregorySmith, https://www.kaggle.com/gregorut/videogamesales

SelectData

DatabaseTotals

Field
Sum
Average
Count
Max
Min

Documentation

Video Game Sales
Create Date By Whom Description Workbook Name
5/12/22 Samantha Vee alzoabi_Excel_Ch06_Assessment_VideoGameSales.xlsx
Mod. Date By Whom Mod. Description Last Version Backup Name
Create Date Sheet Name Creator Purpose
5/12/22 VideoGameSales Samantha Vee Sample data of global video game sales
5/12/22 SelectData Samantha Vee Filtered data for focused analysis
5/12/22 DatabaseTotals Samantha Vee Exploring data with database functions
5/12/22 PivotAnalysis Samantha Vee PivotTable analysis to explore Global Sales
5/12/22 NorthAmericanSalesByPlatform Samantha Vee PivotTable analysis to explore North American Sales
5/12/22 NorthAmericanSalesDS Samantha Vee Data about North American sales for the Nintendo DS
5/12/22 SalesByPlatformPivotChart Samantha Vee To explore sales by platform visually