VARIABILITY QUARTER PAGE

QUARTERLY DATA VARIABILITY FOR  EACH YEAR

data are about:

  • expense
  • n° of purchases
  • n° of days of purchase

 

only past data are considered:

  • therefore, for the most recent year of expense, the most recent quarter of expense isn’t considered for the calculations, because it’s regarded as the current quarter

 

the red line in the center of the bar graph

it represents the average (for example the average quarterly expense)

 

the length of the green bar

for example for expense, it represents, how much, on average, the actual quarterly expense differs from the average quarterly expense, as a percentage of the average quarterly expense

  • the shorter the bar, the less variable, on average, the actual data in each quarter from the average (the less, on average, the quarterly data changes from quarter to quarter)
  • if Var% is over 100%, the bar length doesn’t change

 

 

the data tell you, whether:

  • the overall quarterly data is stable in each year
  • and therefore, whether the average quarterly data is a good indicator of the actual quarterly data
  • how the quarterly data variability changed over the years

 

Screenshot_2018-04-06-10-51-24

 

for example, for 2017, on average, the expense in each quarter differs from the average quarterly expense, by $35.48 or 5.05% of the average quarterly expense (Avg: $702.9) (range: $667 – $738.38),

only if Var% is very low, the average quarterly expense (for example) is a good indicator of the actual quarterly expense. In that example it’s good.

 

Screenshot_2018-04-06-10-51-42

 

YOU CAN TAP THE GLOBE ICON:

  • to see how the removal of sub categories from consideration affect the data variability (check it out on Variability Month Page)