(Solved): WPC 300 : Lab 3: Data Visualization UPDATED JAN 29 ...
WPC 300
Lab 3: Data Visualization
Scored 20 out of 20
Quiz Instructions
• Start with datafile: Sample-Superstore.xlsx
• Review what we did in the lab.
• Must use Tableau to answer the following multiple-choice questions.
• Note: When you are asked to submit a screen capture, you need to make sure that your name is part of the capture.
Note: The lab data file is different from that used in the lab video. The numbers shown in the video will vary when you perform the same step.
Question 1 2 pts
Which of the following variables is an example of ‘measure’?
Group of answer choices
- Segment
- Profit
- Product ID
- Category
Question 2 2 pts
Which product subcategory experienced the most profit in central region?
Group of answer choices
- Tables
- Furnishing
- Copiers
- Binders
Question 3 2 pts
In which region, the store sold the largest number of technology products?
Group of answer choices
- West
- East
- Central
- South
Question 4 2 pts
How many units of furniture were sold in the Central region?
Group of answer choices
- 1291
- 1544
- 5409
- 1827
Question 5 2 pts
Provide a screen shot from Tableau output to support your answer in Q4.
Upload
Question 6 2 pts
Show a color-coded US map depicting total sales per State. Submit a screen shot. You must write your name in place of the Sheet information.
(attached in the answer file)
Question 7 2 pts
Which State sold the greatest number of products?
Group of answer choices
- Florida
- Illinois
- Texas
- California
Question 8 2 pts
In which year did the store experience the highest Q4 Sales?
Group of answer choices
- 2014
- 2016
- 2015
- 2013
Question 9 2 pts
Submit a screenshot of a graph that shows the trend in quarterly sales over a span of four years (2013 to 2016).
Upload (attached in the answer file)
Question 10 2 pts
Submit a screenshot of a single graph that shows the trend in both quarterly sales and quarterly profit over a span of four years (2013 to 2016).
(attached in the answer file)
Expert Answer
Buy This Answer $15
-- OR --
Subscribe $20 / Month