How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.

How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?
A . 1
B . 2
C . 3
D . 4

View Answer

Answer: C

Explanation:

If you chose 2, then you were very close but probably didn’t plot the actual Percent Difference on your view. (One of the marks is just over the line).

✑ Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question.

2) Next, Drop assortment to filters shelf so that we can focus on Electronics!

3) This should be your view now. Click on the Show Mark Labels icon as shown: The final view is as follows, with 3 points below 0 ( i.e negative )