Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's equation for R-Squared value given for chart trendlines? | Charts and Charting in Excel | |||
R squared | Excel Worksheet Functions | |||
how can i make a squared chart area | Charts and Charting in Excel | |||
extracting comments in a cell and making these part of the Chart . | Charts and Charting in Excel | |||
extracting data from seating chart | Excel Worksheet Functions |