Trendline Significant Values
I am trying to work with trendlines, and I can match my data with a
polynominal trendline. The plotted trendline matches the data points very
closely, but when I apply the formula generated to actual data, my projected
values are way off. I believe the problem is that the displayed formula is
rounding constants off and not displaying to the number of significant
figures required to generate a workable formula.
Are there any ways to change any settings to allow Excel to display more
figures in the diplayed trendline formulas?
Thank you in advance.
|