trendline equation solving
Posted by Corey Dale on January 05, 2002 2:17 PM
I'm hoping someone can help me with this.
I have an XY chart with 6 data points on it, and have a 4th order polynominal trendline setup to fit the data. When plotted, the trendline resembles a bell curve. I know that you can display the equation of the trendline on the chart, but is there a way to have excel calculate the maximum Y value, and subsequently spit out the corresponding X value?
Also, on some occassions I only have 4 data points instead of the 6 mentioned above. When I have only 4, the trendline does not plot the way I'd like it to (I want it to look like a bell curve, best fitting the data points). Is there a way to make a trendline that will draw this curve for me with only the 4 data points? I've tried the other types of trendlines, and also the best fit lines, etc.
Any help would be greatly appreciated!