How many months saw a Negative percent difference in Profit?

Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013.

How many months saw a Negative percent difference in Profit?
A . 9
B . 7
C . 10
D . 8

View Answer

Answer: C

Explanation:

Follow along to reach the correct answer:

1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:

Click on Date in the Column shelf and convert it to continuous month:

2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:

3) Finally, click on the Show mark Labels icon:

4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference: