20 points each 1. Management wants to see all sales for each genre. Required Components: 1)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
20 points each 1. Management wants to see all sales for each genre. Required Components: 1) A bar chart depicting Global Sales in million USD versus Genre in the other axis. 2) Display the Sum total of the Global Sales as the label 3) Edit the label of "Global Sales" to "Global Sales (in Million USD)" 4) Change the color of each bar to depict a different color for each genre 5) Change the label of the sheet to - Overall Sales (All times) for each Genre. 2. Management is eager to know the number of games sold for each platform. Display the Number of Games as Bar Charts. Required Components: 1.) A bar chart for count of the platforms. 2) Label the bars with the count of the number of games. 3) Add a different color for each bar representing a different platform 4) Sort the bar chart in descending order 5) Change the label of the sheet to Number of Games for each Platform. 3. Historically PS4, Wii and X360 have dominated the video game market. The Management team wants to invest in 4 different genres - Action, Adventure, Sports and Strategy. Help them understand how the Global Sales has been across these genres. Add a filter each on Genre and Platform to filter only the values needed. Required Components: 1.) Use horizontal bars to depict this comparison. 2.) Use color to differentiate the Genre 3.) Add a filter to include only Wii, PS4 and X360. 4.) Add a filter to include Genres - Action, Adventure, Sports, Strategy. 5). Add a text label to each bar to depict the sum of Global Sales. 6) Label the sheet - Platform versus Genres. 4. Management wants to find out the Top 10 publishers in the market based on the number of games published. Use Packed Bubbles and give the ability for management to find the Top 10 Publishers. Required Components: 1.) Use Packed Bubbles to display your results. 2.) Add a filter for Top 10 Publishers based on the count of the games. 3.) Change the color of the bubble based on the Publisher 4.) Change the label of the sheet to - Top 10 Publishers. 5. To make the presentation more appealing, put together your visualizations as a storyboard. Required Components: 1.) Create a storyboard. 2.) Insert a cover page to highlight what the report is about. 3.) On each page add text to explain the visualization/findings. 20 points each 1. Management wants to see all sales for each genre. Required Components: 1) A bar chart depicting Global Sales in million USD versus Genre in the other axis. 2) Display the Sum total of the Global Sales as the label 3) Edit the label of "Global Sales" to "Global Sales (in Million USD)" 4) Change the color of each bar to depict a different color for each genre 5) Change the label of the sheet to - Overall Sales (All times) for each Genre. 2. Management is eager to know the number of games sold for each platform. Display the Number of Games as Bar Charts. Required Components: 1.) A bar chart for count of the platforms. 2) Label the bars with the count of the number of games. 3) Add a different color for each bar representing a different platform 4) Sort the bar chart in descending order 5) Change the label of the sheet to Number of Games for each Platform. 3. Historically PS4, Wii and X360 have dominated the video game market. The Management team wants to invest in 4 different genres - Action, Adventure, Sports and Strategy. Help them understand how the Global Sales has been across these genres. Add a filter each on Genre and Platform to filter only the values needed. Required Components: 1.) Use horizontal bars to depict this comparison. 2.) Use color to differentiate the Genre 3.) Add a filter to include only Wii, PS4 and X360. 4.) Add a filter to include Genres - Action, Adventure, Sports, Strategy. 5). Add a text label to each bar to depict the sum of Global Sales. 6) Label the sheet - Platform versus Genres. 4. Management wants to find out the Top 10 publishers in the market based on the number of games published. Use Packed Bubbles and give the ability for management to find the Top 10 Publishers. Required Components: 1.) Use Packed Bubbles to display your results. 2.) Add a filter for Top 10 Publishers based on the count of the games. 3.) Change the color of the bubble based on the Publisher 4.) Change the label of the sheet to - Top 10 Publishers. 5. To make the presentation more appealing, put together your visualizations as a storyboard. Required Components: 1.) Create a storyboard. 2.) Insert a cover page to highlight what the report is about. 3.) On each page add text to explain the visualization/findings.
Expert Answer:
Answer rating: 100% (QA)
Video Game Sales Analysis Report This report provides insights into video game sales across genres platforms publishers and historical trends 1 Overal... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
The owners want to do some analysis to see how their sales are doing. Management wants to see how the company did last year and make some decisions about what products to keep along with staffing for...
-
Implement Tables, Queries, Forms, Reports, & Navigation to meet the following requirements. An "Add Customer Contact" use case needs to be implemented (in Access) for a sales organization. This will...
-
Bollobs and Chung proposed a hybrid model that combines a 2-ring on \(V\) vertices ( \(V\) is even), plus a random matching. A matching is a graph in which every vertex has degree 1. To generate a...
-
The December 31, 2017, adjusted trial balance of Darius Company includes the following accounts: (a) Determine which accounts are current assets and prepare the current assets section of the balance...
-
You hold a 6 year bond with a coupon of 5% and a price of 92.56%. In two years' time the discount rate applied to the bond is 5.75%. What will the price be in 2 years?
-
Consider again the ORION system discussed in problem 2. Is ORION an example of descriptive, predictive, or prescriptive analytics? Explain. Problem 2 Every day, logistics companies such as United...
-
David Talbot randomly selected securities from all those listed on the New York Stock Exchange for his portfolio. He began with a single security and added securities one by one until a total of 20...
-
3. The following three-span beam is subjected to two concentrated dead loads as shown below, a uniformly-distributed dead load of 0.8 Kip/ft (including its selfweight), and live load of 1.5 kip/ft...
-
The proposed rates were not in the range the CEO expected given the pricing analysis. The CEO has asked the pricing actuary to verify the total projected loss cost excluding potential large storm...
-
The risk-free rate is 2.5% and the market return is 10.1%. The beta of the stock is 1. What is the required return of the stock?
-
Which are true about TIPS? I. The interest payment is constant, and the principal is adjusted for inflation or deflation. II. The interest payment is variable, and the principal is adjusted for...
-
Which of the following is not appropriate for a short-term investment horizon? A. Certificates of deposit with maturities of 60 months or less. B. Money market demand account. C. Money market mutual...
-
Suppose that a Big Mac sells for 40.90 Norwegian kroners in Oslo and that the exchange rate is 8.18 kroners per U.S. dollar. If a Big Mac sells for $4.35 in New York, can you say that the law of one...
-
The annual inflation rate in Venezuela was 200% during 2015. For the same year, the U.S. annual inflation rate was 1%. If the Venezuelan bolivar traded at 0.10 U.S. dollar in 2015, what was the...
-
Rank the following from the lowest to the highest credit risk. I. Certificate of deposit with six-month maturity date. II. Money market fund. III. Tax-exempt money market fund. IV. Treasury bills. A....
-
Suppose we want to find a point on the unit circle centered at the origin to minimize -x? -2x+y. That is, we wish to solve the following equality constrained problem: -x - 2x + y x? + y? = 1 P min...
-
Which of the companies has the lowest accounts receivable turnover in the year 20X2? a. Company A. b. Company B. c. Company C. d. CompanyD. 20X1 20X2 Credit Sales Average Receivables Balance $1.0...
-
Scott Butterfield is self-employed as a CPA. He uses the cash method of accounting, and his Social Security number is 644-47-7833. His principal business code is 541211. Scott's CPA practice is...
-
Cedar Corporation has an S corporation election in effect. During the 2012 calendar tax year, the corporation had ordinary taxable income of $200,000, and on January 15, 2012, the corporation paid...
-
Frederick (Freddy) Freeweights (age 42) owns and operates a health club called ''Treadmills West.'' The business is located at 4321 Arnold Street, Alpine, CA 91901. Freddy had the following income...
-
An orthotropic lamina forms one layer of a laminate which is initially at temperature \(T_{0}\). Assuming that the lamina is initially stress free, that the adjacent laminae are rigid, that the...
-
Samples of unidirectional Kevlar 49/epoxy and S-glass/epoxy composites are subjected to elevated temperatures in an oven and the resulting thermal strains are measured by using strain gages oriented...
-
An orthotropic lamina has thermal expansion coefficients \(\alpha_{1}=-4.0\) \(\left(10^{-6} ight) \mathrm{m} / \mathrm{m} / \mathrm{K}\) and \(\alpha_{2}=79\left(10^{-6} ight) \mathrm{m} /...
Study smarter with the SolutionInn App