Nevertheless, it might be unrealistic to expect all of your batches will follow the same trend pattern, unless you know they will or should Of course, in hindsight, that was not the problem that you wanted to address. I wrote: ``stick with that for now - at least to confirm that the precision of the coefficients is
With regard to my second question.I will be getting 100 batches of data and will not be wanting to copy and paste the coefficients every time.Īnd I did not suggest that you do that. But it might be educational to answer your questions about LINEST. It seems that you want to pursue Herbert's suggestion. I apologize: I did not take the time to read your question carefully. I was referring to inaccuracy of the actual trendline curve. I wasn't referring to inaccuracy of the trendline equation. I inserted the data being graphed into the table below the picture. The red line is a line I drew that would depict where I think the line should be.ġ) Is there a change I can make to a setting/option/checkbox to get the trendline to make a better approximation of my data?Ģ) Is there a way to export the trendline equation's coefficients into a cell (I would want the two highlighted coefficients to be exported into two different cells)?
#EXCEL TRENDLINE BASED ON IRREGULAR X AXIS SOFTWARE#
The blue trendline is the trendline the software outputs. Seem to match the data as close as I would expect. But when I use the "exponential" or "power" trendline, the trendline the software creates doesn't I am using excel to plot a trendline to essentially smooth out the irregular data.
Hello Microsoft Software Engineers and Other Intelligent People!
0 kommentar(er)
