I am having difficulty Using 2007 excel trendline functions for polynomials on data sets (xy scatter plots).
after plotty x and y and adding a trendline with the displayed function I tried to back calculate the values from the function to validate the trendline.
the equation does not match the shape of the trendline at all which is very Odd> I replotted the results in Matlab and it seems that the coefficient infront of the x^3 term does not show sufficient significant digets.
Does anyone know how to increase the significant figures in the trendline equation or know how to fix this error?
here is a sample of the x y data that I am trying to validate the trendline for.
y x
0.01 2.2369
0.04 4.4738
0.06 6.7107
0.09 8.9476
0.13 11.1845
0.18 13.4214
0.23 15.6583
0.29 17.8952
0.36 20.1321
0.45 22.369
0.54 24.6059
0.65 26.8428
0.78 29.0797
0.92 31.3166
1.09 33.5535
1.27 35.7904
1.48 38.0273
1.71 40.2642
1.97 42.5011
2.25 44.738
2.54 46.9749
2.86 49.2118
3.19 51.4487
3.54 53.6856
3.91 55.9225
4.26 58.1594
4.66 60.3963
5.05 62.6332
5.45 64.8701
5.84 67.107
6.26 69.3439
6.64 71.5808
7.03 73.8177
7.42 76.0546
7.82 78.2915
8.2 80.5284
8.53 82.7653
8.91 85.0022
9.25 87.2391
9.59 89.476
9.94 91.7129
10.27 93.9498
10.59 96.1867
10.92 98.4236
11.18 100.6605
11.5 102.8974
11.75 105.1343
12.04 107.3712
12.28 109.6081
12.55 111.845
12.85 114.0819
13.06 116.3188
13.3 118.5557
13.49 120.7926
13.75 123.0295
13.85 125.2664
14.07 127.5033
14.26 129.7402
14.38 131.9771
14.48 134.214
14.53 136.4509
14.65 138.6878
14.75 140.9247
14.9 143.1616
Bookmarks