I'm writing this report on the ratio between Plugin Electric Vehicles (PEV) and Hybrid Electric Vehicles (HEV) over the next few years, based on given and forecasted values.
These are the values I have (real forecasts by Pike Research):
|Year ||Total ||PEV's ||% ||HEV's ||% |
|2011 ||3,222,800 ||80,745 ||2.5 ||3,149,055 ||97.5 |
|2017 ||9,730,000 ||3,639,020 ||37.4 ||6,090,980 ||62.6 |
For my report I need the percentages of 2012-2016 to create a nice sloped graph and do further calculations. Although I am working with excel, this is a calculus (pre??) problem and the answer is staring in my face, I just don't see it.
function used is: y = c * LN(x) + b
y = 0,1794 * ln(x) + 0,025
y = -0,179 * ln(x) + 0,975
So, how do I calculate the percentages for the missing years??? See the attached graph...
Thanks in advance!!! Rene