| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get the R² value outside side of a graph (exp regression
Hi,
Through a trendline in a chart, I know which R² is used to draw an exponential regression. I can get the exp. regression data with the growth function. But how can I get the R² value in a cell without copying it from the graph? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get the R² value outside side of a graph (exp regression
Have a look at LINEST
LINEST works with many equations; see http://people.stfx.ca/bliengme/exceltips/Polynomial.htm http://www.tushar-mehta.com/publish_...nalysis/16.htm http://spreadsheetpage.com/index.php...line_formulas/ best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Karine" wrote in message ... Hi, Through a trendline in a chart, I know which R² is used to draw an exponential regression. I can get the exp. regression data with the growth function. But how can I get the R² value in a cell without copying it from the graph? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| side-by-side relative frequency bar graph | Charts and Charting in Excel | |||
| How to do a side by side stacked bar graph using 4 data series? | Charts and Charting in Excel | |||
| How can i create a graph with 2 x-axis side by side? | Charts and Charting in Excel | |||
| How do I show data on side by side plots within the same graph ra. | Charts and Charting in Excel | |||
| Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel | |||
Linear Mode
