Reply to thread

Message

<blockquote data-quote="Graf" data-source="post: 1175140" data-attributes="member: 3087"> The year is 1990 - I tell Mr. Johnson, my HS math teacher, that math is stupid and I won't study it. I follow through on my vow and 13 years later I'm still kicking myself.So I'm stumped on a simple(?) math problem and confident someone has the answer.I'm working on a spreadsheet for work where I need to reverse out inflation on a number. Unfortunately I don't have a deflator number (ok, it's been a while since economics I forget what they're called) I only have the percentage rise.So I have a period where an index rose from 5 to 10. During that period there was also 6% inflation. I want to back out inflation. So to figure out what the number at the end of the period (10) is worth I need to get rid of the inflation by multiplying by a number. I've done this one by hand and I think its around 94.5 (about a 5.5% drop). But I'm not really going to do this for every number in question.So what is the formula that explains the relationship between 6 and 5.5% generally?For bonus points, and to complete my humiliation, what grade* do most people learn the answer to this kind of problem?*feel free to insert your educational ranking system of choice. Ideally with age for those of us who only know the American system....</blockquote>

[QUOTE="Graf, post: 1175140, member: 3087"] [size=1] The year is 1990 - I tell Mr. Johnson, my HS math teacher, that math is stupid and I won't study it. I follow through on my vow and 13 years later I'm still kicking myself.[/size] So I'm stumped on a simple(?) math problem and confident someone has the answer. I'm working on a spreadsheet for work where I need to reverse out inflation on a number. Unfortunately I don't have a deflator number (ok, it's been a while since economics I forget what they're called) I only have the percentage rise. So I have a period where an index rose from 5 to 10. During that period there was also 6% inflation. I want to back out inflation. So to figure out what the number at the end of the period (10) is worth I need to get rid of the inflation by multiplying by a number. I've done this one by hand and I think its around 94.5 (about a 5.5% drop). But I'm not really going to do this for every number in question. So what is the formula that explains the relationship between 6 and 5.5% generally? For bonus points, and to complete my humiliation, what grade* do most people learn the answer to this kind of problem? [size=1]*feel free to insert your educational ranking system of choice. Ideally with age for those of us who only know the American system....[/size] [/QUOTE]

Verification