M

#### Medusa

items. I've been trying for hours to write the equation properly in my

cells, but I do not seem to be doing it right. I'm a newbie at excel.

y = -3E-08x6 + 1E-06x5 - 4E-05x4 + 0.0005x3 + 3E-05x2 + 0.0101x - 0.0048

R2 = 1

Where x = percentage of job duration (B171/$D$165) (ex: .05)

and y = percentage of allotted hours used (ex: .006)

MY EQUATION:

=(-0.00000003*((B171/$D$165)^6))+(0.000001*((B171/$D$165)^5))-(0.00004*((B171/$D$165)^4))+(0.0005*((B171/$D$165)^3))+(0.00003*((B171/$D$165)^2))+(0.0101*(B171/$D$165))-0.0048

What am i doing wrong?... I'm getting negative numbers after plugging the

equation into my spreadsheet, so obviously I am re-writing the equation

wrong... Thoughts?