Polynomial Prediction Formula does not calculate coefficients correctly

[Greg Kenyon]

I have an XY plot of Gate position to MW for a specific training period, When I create a trendline using the prediction tool, it outputs a very nice looking trendline with coefficients. However, when I take those coefficients and put them in Excel to create a table of gate positions to MW the formula does not work and calculates numbers that are way off. 

[John Brezovec]

I'd take a look at your units! I notice that your gate position is given in %, so the inputs to that equation should be given between 0 and 1.

[Greg Kenyon]

solved my own problem, have to strip units from percent and then multiply by 100 to get numbers from 0-100. then the coefficients calculate correctly.

[Greg Kenyon]

Thanks John! You were spot on.