| 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? |
| 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 | |||
Threaded Mode
