Question

1 Approved Answer

Posted on Sep 28, 2024

all information is given, business analytics, one question in total A B D E $ $- 1 Name Iplatform Year Genre Publisher 2 Jeopardy! 2nd

all information is given, business analytics, one question in total image text in transcribed

A B D E $ $- 1 Name Iplatform Year Genre Publisher 2 Jeopardy! 2nd Edition PS 2000 Misc Hasbro Interactive 3 TrackMania Turbo PS4 2016 Action Ubisoft Touch Detective: Nameko Shigeru 3DS 2013 Adventure Success 5 NHL 16 PS3 2015 Sports Electronic Arts 5 Ride PS4 2015 Racing Milestone S.r.l. 7 Dragon Zakura DS DS 2007 Misc Electronic Arts Sherlock Holmes: Crimes & Punishments PS3 2014 Adventure Focus Home Interactive Ace Attorney Investigations 2 DS 2011 Adventure Capcom o Metal Fight Beyblade DS 2009 Action Hudson Soft 1 Farmtopia DS 2010 Simulation 505 Games 2 Pokemon Ranger DS 2006 Role-Playing Nintendo 3 BeatMania IIDX 16: Empress + Premium Best PS2 2009 Simulation Konami Digital Entertainment 4 Mobile Suit Gundam Seed: Rengou vs. Z.A.F.T. Portable PSP 2007 Shooter Namco Bandai Games 5 MiniCopter: Adventure Flight Wii 2007 Simulation 505 Games 6 Super Speed Machines DS 2009 Racing Midas Interactive Entertainment 7 Knockout Kings 2001 PS 2000 Fighting Electronic Arts 8 Clock Zero: Shuuen no Ichibyou - ExTime PSV 2015 Action Idea Factory 9 Walt Disney Pictures Presents: The Wild GBA 2006 Platform Disney Interactive Studios o Marker Man Adventures DS 2009 Platform Majesco Entertainment 1 Tactics Layer: Ritina Guard Senki DS 2009 Strategy D3Publisher 2 From TV Animation One Piece: Yume No Lufy Kaizokudan Tanjou! GB 2001 Role-Playing Banpresto 3 Pac-Man Player's Choice Bundle GC 2003 Misc Namco Bandai Games 4 Burnout Paradise X360 2008 Racing Electronic Arts 5 Prison Break: The Conspiracy PS3 2010 Action Deep Silver 6 Mario Golf: Toadstool Tour GC 2003 Sports Nintendo 7 Poker for Dummies PC 2008 Misc Electronic Arts 8 Resident Evil 5 PC 2009 Action Capcom 9 Far Cry Instincts XB 2005 Shooter Ubisoft o Grand Theft Auto: Mission Pack #1, London 1969 PS 1998 Adventure Take-Two Interactive 1 SimCity SNES 1991 Simulation Nintendo 2 3 Data from Video Game Sales" compiled by GregorySmith, https://www.kaggle.com/gregorut/videogamesales F G . 1 J North America Europe Japan Other GlobalSales $ 0.16 $ 0.11 $ . $ 0.02 $ 0.29 $ 0.03 $ 0.24 $. $ 0.05 $ 0.32 $ $. $ 0.07 $ - $ 0.07 $ $ 0.03 $. $ 0.01 $ 0.04 $ 0.03 $ 0.13 $ 0.03 $ 0.03 $ 0.22 $ $ - $ 0.01 $ - $ 0.01 $ 0.03 $ 0.04 $. $ 0.01 $ 0.08 $ $. $ 0.26 $ - $ 0.26 $ $ - $ 0.09 $ - $ 0.09 $ 0.18 $ - $ 0.01 $ 0.19 $ 1.29 $ 0.04 $0.73 $0.12 $ 2.18 $ $ - $ 0.04 $. $ 0.04 $ $. $0.12 $. $ 0.12 $ 0.04 $ $. $. $ 0.05 $ 0.02 $ - $ . $. $ 0.02 $ 0.23 $ 0.15 $ . $ 0.03 $ 0.41 $ $- $ 0.02 $ - $ 0.02 $ 0.09 $ 0.03 $. $ - $ 0.13 $ 0.02 $ - $ - $ - $ 0.03 $ $- $ 0.01 $. $ 0.01 $ $ $0.39 $ - $ 0.39 $ 0.48 $ 0.12 $ - $ 0.02 $ 0.62 $ 0.63 $ 0.58 $ 0.01 $0.15 $ 1.36 $ 0.05 $ 0.16 $ . $ 0.05 $ 0.26 $ 1.09 $ 0.15 $ 0.25 $ 0.04 $ 1.53 $ $ 0.01 $. $ 0.01 $ 0.01 $ 0.04 $ - $ 0.01 $ 0.07 $ 0.32 $ 0.24 $. $ 0.02 $ 0.57 $ 0.06 $ 0.04 $ - $ 0.01 $ 0.11 $ 0.93 $ 0.27 $ 0.75 $ 0.04 $ 1.98 $ - 5 6 7 8 9 0 1 2 3 4 VideoGameSales SelectData Database Totals Documentation + B D E F G H K L 1 2 3 5 5 7 3 1 2 3 5 5 7 3 1 2 3 5 5 7 3 1 2 3 Video Game Sales SelectData Database Totals Documentation + Field Sum Average Count Max Min . 1 VideoGameSales SelectData Database Totals Documentation + B Description Create Date By Whom 5/12/22 Samantha Vee Mod. Date By Whom Workbook Name Excel Cho6 PS2 VideoGameSales.xlsx Last Version Backup Name Mod. Description D 1 2 3 4 5 6 7 B D 1 2 3 4 5 6 Create Date Sheet Name 5/12/22 Video GameSales 5/12/22 Select Data 5/12/22 Database Totals 5/12/22 PivotAnalysis 5/12/22 North AmericanSales ByPlatform 5/12/22 North American SalesDS 5/12/22 Sales ByPlatformPivot Chart Creator Samantha Vee Samantha Vee Samantha Vee Samantha Vee Samantha Vee Samantha Vee Samantha Vee Purpose Sample data of global video game sales Filtered data for focused analysis Exploring data with database functions PivotTable analysis to explore Global Sales PivotTable analysis to explore North American Sales Data about North American sales for the Nintendo DS To explore sales by platform visually 7 B D 1 2 3 4 5 6 7 8 9 D 1 2 3 4 5 6 7 Video Game Sales SelectData Database Totals Documentation + 2 0.8 3 1 4 1 5 1 The data on the Video Game Sales worksheet includes sales in millions) for several video games on various platforms and from various genres. On the Video Game Sales worksheet, insert a table with headers using the data. Apply the Light Blue, Table Style Medium 27 to the table and with the table selected, including the headers, create a Sales Database named range to be used in database functions later. Add a Total Row to the table to have the sales values in the North America, Europe, Japan, Other, and GlobalSales columns summed. Slicers are an easy way to explore data in a table. Insert slicers for Platform, Year, and Genre. Move the Platform slicer so that its top-left corner is just inside the border of cell K1. Modify its Layout property so that it has 3 columns and resize the slicer so that all options are visible and extra white space is minimal. Apply the White, Slicer Style Other 2 style to the slicer. Move the Genre slicer so that its top-left corner is just inside cell N1. Modify its Layout property so that it has 2 columns and resize the slicer so that all options are visible and extra white space is minimal. Apply the White, Slicer Style Other 2 style to the slicer. Move the Year slicer so that its top-left corner is inside cell K13. Modify its Layout property so that it has 3 columns and resize the slicer so that all options are visible and extra white space is minimal. Modify the setting so that the caption reads Release Year. Apply the White, Slicer Style Other 2 style to the slicer. 6 0.4 7 0.4 8 0.4 9 1.2 Using the slicers, filter the Table to only show records where the Platform is PS3 and DS and the Genre is either Adventure or Action. Select the filtered data, including column headings and the Total row, and paste the data on the SelectData worksheet, starting in cell A1. Adjust the column widths as necessary so that all data are visible. 10 1 11 Clear the filters applied to the Video Game Sales data. Copy the headings and paste them onto the Database Totals worksheet, starting in cell A1 to begin to setup and create database functions to further analyze the data. If necessary, adjust the column widths so that all data are visible. Complete the Database Totals worksheet using the appropriate database functions using the SalesDatabase named range, use GlobalSales as the field in your calculations, and only calculate games that meet the following criteria: In row 2, specify the criteria for games on the Wii platform with a release year of newer than 2006 In row 3, specify the criteria for games on the DS platform in the Adventure genre. A B D E $ $- 1 Name Iplatform Year Genre Publisher 2 Jeopardy! 2nd Edition PS 2000 Misc Hasbro Interactive 3 TrackMania Turbo PS4 2016 Action Ubisoft Touch Detective: Nameko Shigeru 3DS 2013 Adventure Success 5 NHL 16 PS3 2015 Sports Electronic Arts 5 Ride PS4 2015 Racing Milestone S.r.l. 7 Dragon Zakura DS DS 2007 Misc Electronic Arts Sherlock Holmes: Crimes & Punishments PS3 2014 Adventure Focus Home Interactive Ace Attorney Investigations 2 DS 2011 Adventure Capcom o Metal Fight Beyblade DS 2009 Action Hudson Soft 1 Farmtopia DS 2010 Simulation 505 Games 2 Pokemon Ranger DS 2006 Role-Playing Nintendo 3 BeatMania IIDX 16: Empress + Premium Best PS2 2009 Simulation Konami Digital Entertainment 4 Mobile Suit Gundam Seed: Rengou vs. Z.A.F.T. Portable PSP 2007 Shooter Namco Bandai Games 5 MiniCopter: Adventure Flight Wii 2007 Simulation 505 Games 6 Super Speed Machines DS 2009 Racing Midas Interactive Entertainment 7 Knockout Kings 2001 PS 2000 Fighting Electronic Arts 8 Clock Zero: Shuuen no Ichibyou - ExTime PSV 2015 Action Idea Factory 9 Walt Disney Pictures Presents: The Wild GBA 2006 Platform Disney Interactive Studios o Marker Man Adventures DS 2009 Platform Majesco Entertainment 1 Tactics Layer: Ritina Guard Senki DS 2009 Strategy D3Publisher 2 From TV Animation One Piece: Yume No Lufy Kaizokudan Tanjou! GB 2001 Role-Playing Banpresto 3 Pac-Man Player's Choice Bundle GC 2003 Misc Namco Bandai Games 4 Burnout Paradise X360 2008 Racing Electronic Arts 5 Prison Break: The Conspiracy PS3 2010 Action Deep Silver 6 Mario Golf: Toadstool Tour GC 2003 Sports Nintendo 7 Poker for Dummies PC 2008 Misc Electronic Arts 8 Resident Evil 5 PC 2009 Action Capcom 9 Far Cry Instincts XB 2005 Shooter Ubisoft o Grand Theft Auto: Mission Pack #1, London 1969 PS 1998 Adventure Take-Two Interactive 1 SimCity SNES 1991 Simulation Nintendo 2 3 Data from Video Game Sales" compiled by GregorySmith, https://www.kaggle.com/gregorut/videogamesales F G . 1 J North America Europe Japan Other GlobalSales $ 0.16 $ 0.11 $ . $ 0.02 $ 0.29 $ 0.03 $ 0.24 $. $ 0.05 $ 0.32 $ $. $ 0.07 $ - $ 0.07 $ $ 0.03 $. $ 0.01 $ 0.04 $ 0.03 $ 0.13 $ 0.03 $ 0.03 $ 0.22 $ $ - $ 0.01 $ - $ 0.01 $ 0.03 $ 0.04 $. $ 0.01 $ 0.08 $ $. $ 0.26 $ - $ 0.26 $ $ - $ 0.09 $ - $ 0.09 $ 0.18 $ - $ 0.01 $ 0.19 $ 1.29 $ 0.04 $0.73 $0.12 $ 2.18 $ $ - $ 0.04 $. $ 0.04 $ $. $0.12 $. $ 0.12 $ 0.04 $ $. $. $ 0.05 $ 0.02 $ - $ . $. $ 0.02 $ 0.23 $ 0.15 $ . $ 0.03 $ 0.41 $ $- $ 0.02 $ - $ 0.02 $ 0.09 $ 0.03 $. $ - $ 0.13 $ 0.02 $ - $ - $ - $ 0.03 $ $- $ 0.01 $. $ 0.01 $ $ $0.39 $ - $ 0.39 $ 0.48 $ 0.12 $ - $ 0.02 $ 0.62 $ 0.63 $ 0.58 $ 0.01 $0.15 $ 1.36 $ 0.05 $ 0.16 $ . $ 0.05 $ 0.26 $ 1.09 $ 0.15 $ 0.25 $ 0.04 $ 1.53 $ $ 0.01 $. $ 0.01 $ 0.01 $ 0.04 $ - $ 0.01 $ 0.07 $ 0.32 $ 0.24 $. $ 0.02 $ 0.57 $ 0.06 $ 0.04 $ - $ 0.01 $ 0.11 $ 0.93 $ 0.27 $ 0.75 $ 0.04 $ 1.98 $ - 5 6 7 8 9 0 1 2 3 4 VideoGameSales SelectData Database Totals Documentation + B D E F G H K L 1 2 3 5 5 7 3 1 2 3 5 5 7 3 1 2 3 5 5 7 3 1 2 3 Video Game Sales SelectData Database Totals Documentation + Field Sum Average Count Max Min . 1 VideoGameSales SelectData Database Totals Documentation + B Description Create Date By Whom 5/12/22 Samantha Vee Mod. Date By Whom Workbook Name Excel Cho6 PS2 VideoGameSales.xlsx Last Version Backup Name Mod. Description D 1 2 3 4 5 6 7 B D 1 2 3 4 5 6 Create Date Sheet Name 5/12/22 Video GameSales 5/12/22 Select Data 5/12/22 Database Totals 5/12/22 PivotAnalysis 5/12/22 North AmericanSales ByPlatform 5/12/22 North American SalesDS 5/12/22 Sales ByPlatformPivot Chart Creator Samantha Vee Samantha Vee Samantha Vee Samantha Vee Samantha Vee Samantha Vee Samantha Vee Purpose Sample data of global video game sales Filtered data for focused analysis Exploring data with database functions PivotTable analysis to explore Global Sales PivotTable analysis to explore North American Sales Data about North American sales for the Nintendo DS To explore sales by platform visually 7 B D 1 2 3 4 5 6 7 8 9 D 1 2 3 4 5 6 7 Video Game Sales SelectData Database Totals Documentation + 2 0.8 3 1 4 1 5 1 The data on the Video Game Sales worksheet includes sales in millions) for several video games on various platforms and from various genres. On the Video Game Sales worksheet, insert a table with headers using the data. Apply the Light Blue, Table Style Medium 27 to the table and with the table selected, including the headers, create a Sales Database named range to be used in database functions later. Add a Total Row to the table to have the sales values in the North America, Europe, Japan, Other, and GlobalSales columns summed. Slicers are an easy way to explore data in a table. Insert slicers for Platform, Year, and Genre. Move the Platform slicer so that its top-left corner is just inside the border of cell K1. Modify its Layout property so that it has 3 columns and resize the slicer so that all options are visible and extra white space is minimal. Apply the White, Slicer Style Other 2 style to the slicer. Move the Genre slicer so that its top-left corner is just inside cell N1. Modify its Layout property so that it has 2 columns and resize the slicer so that all options are visible and extra white space is minimal. Apply the White, Slicer Style Other 2 style to the slicer. Move the Year slicer so that its top-left corner is inside cell K13. Modify its Layout property so that it has 3 columns and resize the slicer so that all options are visible and extra white space is minimal. Modify the setting so that the caption reads Release Year. Apply the White, Slicer Style Other 2 style to the slicer. 6 0.4 7 0.4 8 0.4 9 1.2 Using the slicers, filter the Table to only show records where the Platform is PS3 and DS and the Genre is either Adventure or Action. Select the filtered data, including column headings and the Total row, and paste the data on the SelectData worksheet, starting in cell A1. Adjust the column widths as necessary so that all data are visible. 10 1 11 Clear the filters applied to the Video Game Sales data. Copy the headings and paste them onto the Database Totals worksheet, starting in cell A1 to begin to setup and create database functions to further analyze the data. If necessary, adjust the column widths so that all data are visible. Complete the Database Totals worksheet using the appropriate database functions using the SalesDatabase named range, use GlobalSales as the field in your calculations, and only calculate games that meet the following criteria: In row 2, specify the criteria for games on the Wii platform with a release year of newer than 2006 In row 3, specify the criteria for games on the DS platform in the Adventure genre