| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trendline Significant Values | Charts and Charting in Excel | |||
| How would I attach or assign values to a trendline? | Excel Worksheet Functions | |||
| How to get the trendline values in excel 03 direct into cells ? | Charts and Charting in Excel | |||
| Getting the values of the points in a trendline | Excel Discussion (Misc queries) | |||
| How can i find specific values along a trendline? | Charts and Charting in Excel | |||
Hybrid Mode
