hack//QuaranTne Part 4: ±he Final ChapterPS2 2003 Role-Playing Atari. hack//Link PSP 2010 Role-Playing Namco Bandai Games. Vol.3//RedempTon PS2 2007 Role-Playing Namco Bandai Games. ![]() Vol.2//Reminisce (jp sales) PS2 2006 Role-Playing Namco Bandai Games. Vol.2//Reminisce PS2 2006 Role-Playing Namco Bandai Games. Vol.1//Rebirth PS2 2006 Role-Playing Namco Bandai Games. Video Game Platorm Year Genre Publisher 19 Shooter Capcom. How many games have worldwide sales over $2million, $5million, and $8million? Your data is located in the dataset VIDEO_GAME_SALES_DATA.xlsx on D2L What are the top 5 games and what is the revenue for each of the top 5 games? 4. What is the total market in each of the geographic locations available? (i.e. What is the total market available? (Total sales from all geographic locations) 2. The VP of sales would like you to take an initial look at the data to determine: 1. Sleek wants to analyze this data to get a general sense of the market which may help them set marketing plans for various locations. The data identifies the various games, their genre, and the platforms on which they run. VIDEO GAME SALES ANALYSIS Sleek Software Inc., a video game producer has purchased a dataset containing sales data for the gaming market that breaks down sales by geographic location, North America, Europe, Japan, and other (which is all other locations around the world). I am going to suggest you look at two other functions to make this work, INDEX and MATCH. ![]() The product name is in the first column, the greatest sales are in your column J (assuming you used that column to sum sales). 4 FIND THE PRODUCT WITH THE LARGEST SALES This is the trickiest part of the analysis since you need to get the product name after you’ve identified the largest sales value. However, when we change the k value to be 2 we get the second largest, 3 the third largest, and so on. So if we enter =LARGE(J3:J16600, 1) it will return the same value as MAX. It is in the format =LARGE(array,k) where array is the range of cells you are looking at (column or row) and k is the position you are looking for. We need to use a different approach to do that. However, it won’t give you the 2 nd greatest, or 3 rd greatest value. ![]() 4 FIND THE LARGEST SALES When you are looking for the largest number in a column or a row you can use the MAX function. OR find a cell where you want the total to appear and enter the formula =SUM(J3:J16600) which will sum the J column. You can do the same for the country columns. It should automatically select the entire column and generate a sum. 2 SUM TOTAL SALES 3 SUM BY COUNTRY To find the totals, you can go to cell J16600 and click the AutoSum in the editing box on the Home tab. To get back to the top, double click a top border. ![]() For example, if you want to get to the bottom of the data, highlight a cell in the table and double click on the bottom border. NOTE: To make it easier to move around in large data sets, highlight a cell and double click on a border to go to the farthest cell with data in that direction. (If you create that formula in row 3 you can click on cell J3 to highlight the formula, and then double click on the square on the lower right side to copy the formula for all the rows in the dataset). Consider adding a column J and summing the sales from the previous four columns. HINTS for ANALYZING VIDEO GAME SALES Some suggestions for you in performing this analysis: 1 SUM BY PRODUCT One of the first things you’ll need is total sales by game.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |