jason1 -
Would like to create 5th- order polynomial trendline from data set and
have coefficients automatically displayed in excel cells (one in each
cell) <
(1) Do you actually think there is some real-world data where the underlying
process should be represented with a 5th-order polynomial? Be aware of
possible overfitting the data in which case predictions are of dubious
value.
(2) But if you really want to do it, you could use the LINEST array-entered
worksheet function.
Tushar Mehta has some examples and tutorials at
www.tushar-mehta.com.
- Mike
www.mikemiddleton.com