Vol% | R.I |
0 | 1.3323 |
10 | 1.3388 |
20 | 1.3446 |
30 | 1.3497 |
40 | 1.3541 |
50 | 1.3580 |
60 | 1.3610 |
70 | 1.3630 |
80 | 1.3638 |
90 | 1.3630 |
100 | 1.3600 |
I tried to graph the following data in excel to obtain theequation of the line which happens to be polynomial 4th order
I am given a R.I of 1.3616 and expected to obtain Vol% bysolving the polynomial. i did that with excel and got 9.2 and thecorrect answer is around (you can guess by liner interpolation) is63.
here's the polynomial : R.I=1.3323+6.9476e(-4)X-4.711e(-6)X^2+3.7995e(-5)X^3-3.2634e(-10)X^4
can anyone do hand calculation and excel to confirm this