I am in over my head and need some help.
We have about 3000 numbers which are all very small - the only way to evaluate the quality of our data is to chart it in a line chart and then add a polynomina trendline to the order of 3. We then take the equation which is displayed and apply it to each of the values in our dataset. The range from all the results is then produced.
What I would like to do come up with the same formula that excel made for the trend line without making the chart. This data is produced frequently and of the 5 sets I have each one had a different equation.
Below is a small amount of detail - I would appreciate any help - I have looked though many posts on this subject but still lost.
Equation created and displayed in chart
y = 4E-13x3 - 2E-09x2 + 2E-06x - 0.0004
Sampling of data and sampling of corresponding result of above equation where x = data
0.0002 9.999990E-05
0.0003 9.999987E-05
0.0004 9.999984E-05
0.0005 9.999981E-05
0.0005 9.999979E-05
0.0006 9.999976E-05
0.0006 9.999976E-05
0.0003 9.999986E-05
0.0002 9.999990E-05
0.0002 9.999994E-05
0.0001 9.999996E-05
0.0001 9.999997E-05
0.0001 9.999996E-05
0.0002 9.999993E-05
Final Range of values produced
1.0434684E-09
Thanks
We have about 3000 numbers which are all very small - the only way to evaluate the quality of our data is to chart it in a line chart and then add a polynomina trendline to the order of 3. We then take the equation which is displayed and apply it to each of the values in our dataset. The range from all the results is then produced.
What I would like to do come up with the same formula that excel made for the trend line without making the chart. This data is produced frequently and of the 5 sets I have each one had a different equation.
Below is a small amount of detail - I would appreciate any help - I have looked though many posts on this subject but still lost.
Equation created and displayed in chart
y = 4E-13x3 - 2E-09x2 + 2E-06x - 0.0004
Sampling of data and sampling of corresponding result of above equation where x = data
0.0002 9.999990E-05
0.0003 9.999987E-05
0.0004 9.999984E-05
0.0005 9.999981E-05
0.0005 9.999979E-05
0.0006 9.999976E-05
0.0006 9.999976E-05
0.0003 9.999986E-05
0.0002 9.999990E-05
0.0002 9.999994E-05
0.0001 9.999996E-05
0.0001 9.999997E-05
0.0001 9.999996E-05
0.0002 9.999993E-05
Final Range of values produced
1.0434684E-09
Thanks