# A mathematics superhero? Comic book and mathematics problem needs a solution!!!

• Mar 29th 2012, 01:53 PM
Joekerr99
A mathematics superhero? Comic book and mathematics problem needs a solution!!!
Hi everyone!

I have a little problem here that I am trying to work out but I can't solve... Really the problem here is that I'm a terrible Mathematicain! But I'm here to learn!!!!

The problem is simple (or at lease simply explained) and I have included a piece of a larger table (attached xls) that has all the informatio.

I run a comic book shop and I am developing a website for selling the comics. Unfortunately I have to input the prices of the comics manually. My web developer has made things easier for me by creating a program that allows me to input the prices. Now, there is a price guide that I am using but there are some problems. First of all, there are 17 different grades for the comics (ie, NM+, mn, mn- vf+, vf,vf-) and so on. Now, the guide lists the prices in NM-, VF, f, VG and G. When I looked closely at the prices I realised that there was not a constant relationship between the values. For example, when a comic is valued at \$3 NM-, the price of the same comic in the condition VF is 66% of the NM- price. But when the comic is priced at \$100 NM- the VF price is only 45% of this value.

The table below states the different values of NM-, beneath that is the percentage (expressed in decimal form) of that value. So what I was looking for was a formula to determine the percentages of the lower grades when the NM- value is input. The goal is to be able to integrate this formula into my website so I can accurately price all the comics.

If anyone could show me how to solve this problem or even point me in the right direction I would be truly grateful as it would be a tremendous help!!!