Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jean
 
Posts: n/a
Default R² expression for trendline in chart

Using trendline in a chart, and forcing the trendline to cross the origin, I
get a R² value. The R² expression, in the help, is wrong in this case (origin
crossing).
What is the true exression used for R² calculation ?
Thanks
  #2   Report Post  
Michael R Middleton
 
Posts: n/a
Default

jean -

Using trendline in a chart, and forcing the trendline to cross the origin,
I get a R² value. The R² expression, in the help, is wrong in this case
(origin crossing). What is the true exression used for R² calculation ?
Thanks <


Perhaps this knowledge base article is relevant:

http://support.microsoft.com/default...b;en-us;829249

- Mike

www.mikemiddleton.com


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combination of stock chart and line chart hwatari Charts and Charting in Excel 2 September 24th 07 10:52 PM
Impedding/Overlaying Charts Phil Hageman Charts and Charting in Excel 4 December 17th 04 07:25 PM
Changing chart orientation Melissa Charts and Charting in Excel 3 December 10th 04 10:15 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM


All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"