|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 26th, 2009, 05:02 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Trendline values
I used the function "LOGEST" to get an exponential fit of a series of
numbers, which gives me a value of 1.0610. I also used "RSQ" function to get the R-square, which is 0.9442. Then I made a chart based on the same series of numbers and add trendline to the curve. I selected "Exponential" under "Type" and checked "Display equation on chart" and "Display R-Squared value on chart". The value shown on the chart is "y=3928.8e^0.0592x" and "R^2=0.9104". I expected to see "y=3928.8e^0.0610x" and "R^2=0.9442". Why are the values on the chart different from those produced by the functions? 
|
|
#2
February 27th, 2009, 02:34 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Trendline values
All this and more is explained at
http://people.stfx.ca/bliengme/Excel...&%20LOGEST.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Scott" wrote in message ... I used the function "LOGEST" to get an exponential fit of a series of numbers, which gives me a value of 1.0610. I also used "RSQ" function to get the R-square, which is 0.9442. Then I made a chart based on the same series of numbers and add trendline to the curve. I selected "Exponential" under "Type" and checked "Display equation on chart" and "Display R-Squared value on chart". The value shown on the chart is "y=3928.8e^0.0592x" and "R^2=0.9104". I expected to see "y=3928.8e^0.0610x" and "R^2=0.9442". Why are the values on the chart different from those produced by the functions?
|
|
#3
February 27th, 2009, 03:54 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Trendline values
Thanks a lot. That solved my problem.
"Bernard Liengme" wrote: All this and more is explained at http://people.stfx.ca/bliengme/Excel...&%20LOGEST.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Scott" wrote in message ... I used the function "LOGEST" to get an exponential fit of a series of numbers, which gives me a value of 1.0610. I also used "RSQ" function to get the R-square, which is 0.9442. Then I made a chart based on the same series of numbers and add trendline to the curve. I selected "Exponential" under "Type" and checked "Display equation on chart" and "Display R-Squared value on chart". The value shown on the chart is "y=3928.8e^0.0592x" and "R^2=0.9104". I expected to see "y=3928.8e^0.0610x" and "R^2=0.9442". Why are the values on the chart different from those produced by the functions?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
