LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 36
Default extracting R-squared value from a chart

Hello,
I have a scatter chart with a power trendline. The R-squared value is
displayed. I did find formulae that I can use to calculate the c & b value
(for the equation y=c*x^b) directly from the data. My question is whether
there is a formula that I can use to either:

a-extract the R-squared value from the chart, or
b-calculate the R-sqared value directly from the data and equation values (c
& b).

I hope that makes sense. It's been a looooong time since I've used
Statistics, so I may have used some terms incorrectly. If so, I apologize.
Let me know and I can clarify.

Thanks for the help.
--
Mike Lee
McKinney,TX USA
 
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
What's equation for R-Squared value given for chart trendlines? Sarah Charts and Charting in Excel 4 October 29th 07 12:39 PM
R squared David Excel Worksheet Functions 11 July 27th 07 01:02 AM
how can i make a squared chart area squared chart area Charts and Charting in Excel 1 March 12th 07 03:07 PM
extracting comments in a cell and making these part of the Chart . Charles Charts and Charting in Excel 2 April 19th 05 03:40 PM
extracting data from seating chart cds Excel Worksheet Functions 2 January 2nd 05 11:00 PM


All times are GMT +1. The time now is 01:11 AM.

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"