Oct 24 2023 01:51 PM
How do I find the equation of the trendline line on the graph (under “more options”) along with the r squared value (coefficient of determination).
Oct 24 2023 02:03 PM
@pippins_2586
For a linear trendline, see the LINEST function
For an exponential trendline, there is a similar LOGEST function.
Oct 24 2023 02:42 PM
You could simply display the values on the chart or calculate them as @Hans Vogelaar suggests.
Oct 24 2023 02:46 PM
Right-click the trendline | Format trendline:
Last two checkboxes in this menu:
