I don’t have a exact problem as it’s for work and not a class. I’ll try to elaborate:
I want to quantify the drivers of change in a ratio that we look at.
so if it was 75% last month and 70% this month. I want to show how it decreased by 5% (I.e did -2% come from changes to x and -3% from changes to y) by having the impacts of the two variables in the equation below:
75%=(x-y)/x
70%=(x-y)/x
75%=(4,000-1,000)/4,000
70%=(5,000-1,500)/5,000
so how many pp of the 5pp decrease came from changes in x and how many from changes in y?
hope this helps