The first data set in column B is equal to 100%. Then I have a second data set in column D that represents 32% of the full data set. I want to use a math function so that I can convert the second data against the fist data set so that I am able to achieve 100% by using the second data set.
My assumption was that if I were to convert the second data set to represent 100% and multiply out this with the first data set I would get 100% however, this is not the case. Can someone help. I have included the data as an attachment so that you can see my question more clearly if I am not explaining properly.
My assumption was that if I were to convert the second data set to represent 100% and multiply out this with the first data set I would get 100% however, this is not the case. Can someone help. I have included the data as an attachment so that you can see my question more clearly if I am not explaining properly.
| Original Data = 100% | Comp Data = 32% | Comp converted to = 100% | New data set that should equal 100%, what I am trying to achieve. | |||
| Current Curve | Comp Curve | Comp conv. 100% | ||||
| 3% | 11% | 35% | 4.0% | |||
| 3% | 4% | 13% | 0.4% | |||
| 2% | 3% | 10% | 0.2% | |||
| 3% | 2% | 7% | 0.2% | |||
| 3% | 1% | 4% | 0.1% | |||
| 3% | 2% | 5% | 0.1% | |||
| 2% | 2% | 5% | 0.1% | |||
| 2% | 3% | 11% | 0.3% | |||
| 3% | 1% | 4% | 0.1% | |||
| 3% | 1% | 3% | 0.1% | |||
| 3% | 0% | 1% | 0.0% | |||
| 3% | 1% | 2% | 0.1% | |||
| 3% | 3.0% | |||||
| 3% | 2.8% | |||||
| 3% | 2.7% | |||||
| 3% | 2.6% | |||||
| 2% | 2.4% | |||||
| 2% | 2.3% | |||||
| 2% | 2.3% | |||||
| 3% | 3.4% | |||||
| 1% | 1.4% | |||||
| 2% | 2.3% | |||||
| 2% | 2.3% | |||||
| 3% | 3.0% | |||||
| 4% | 3.7% | |||||
| 2% | 2.3% | |||||
| 6% | 6.4% | |||||
| 4% | 4.3% | |||||
| 5% | 4.6% | |||||
| 5% | 5.1% | |||||
| 6% | 5.7% | |||||
| 4% | 4.3% | |||||
| 100% | 32% | 100% | 73% |
