Re-calculating Value of $100 in Each State by Specific State

29 Views Asked by At

I'm using this Tax Foundations graphic for data.

How would I re-calculate each state based on a specific state? For example, what if I wanted to base the control state on Missouri, which is $113.51. What's the best equation to use to re-calculate other states so they're still relative to Missouri?

Would multiplying state * new state do it? i.e. if Missouri s $113.51, I would multiply each state by 1.1351? Or am I way off here?

1

There are 1 best solutions below

1
On BEST ANSWER

If I understand you right, then you want to calculate how much sb can buy in a state relative more/less to Missouri (in percent).

The term equation would be $\left( \frac{X}{113.51}-1\right) \cdot 100 \% $. Thus you divide by 113.51.