turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- SAS Procedures
- /
- proc reg what is the r-squared really for

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-14-2009 02:30 PM

someone asked the question here

how is the r-squared from the proc reg computed and what is it used for?

I tried to explain but failed.

any ideas appreciated

how is the r-squared from the proc reg computed and what is it used for?

I tried to explain but failed.

any ideas appreciated

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

10-14-2009 02:52 PM

This note may help.

http://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/statug_introreg_sect009.htm

It doesn't get to the history of the term. If the regression has just one continuous predictor, then the r-squared is algebraically identical to the squared Pearson correlation coefficient, though the interpretation (causation vs association) is different.

http://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/statug_introreg_sect009.htm

It doesn't get to the history of the term. If the regression has just one continuous predictor, then the r-squared is algebraically identical to the squared Pearson correlation coefficient, though the interpretation (causation vs association) is different.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Doc_Duke

10-14-2009 03:00 PM

ah but when they calculated the correlation in excel the number was not the same

anyone know what excel is really doing?

anyone know what excel is really doing?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

10-14-2009 03:02 PM

I don't know what Excel is really doing ... but ... no one should be using Excel for statistical calculations. There have been paper after paper showing flaws in Excel's algorithm. Sometimes, it isn't able to compute variances properly.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Paige

10-14-2009 03:12 PM

I'd love a reference

I get tired of numbers not coming out the same when someone does the same thing in excel and points out that the numbers are different

I get tired of numbers not coming out the same when someone does the same thing in excel and points out that the numbers are different

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

10-14-2009 11:07 PM

just go to Google scholar and search for

excel statistics accuracy

and you will find a host of references.

excel statistics accuracy

and you will find a host of references.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Doc_Duke

10-15-2009 12:24 PM

From "On the accuracy of statistical procedures in Microsoft Excel 2007", B.D. McCullough and and David A. Heiser, Computational Statistics & Data Analysis

Volume 52, Issue 10, 15 June 2008, Pages 4570-4578.

"The statistical literature has regularly identified flaws in Excel’s statistical procedures at least since Sawitzki (1994), and Microsoft has repeatedly proved itself incapable of providing reliable statistical functionality. It is little wonder that introductory texts on statistics warn students not to use Excel when the results matter (e.g., Keller (2001) and Levine et al. (2002))."

Volume 52, Issue 10, 15 June 2008, Pages 4570-4578.

"The statistical literature has regularly identified flaws in Excel’s statistical procedures at least since Sawitzki (1994), and Microsoft has repeatedly proved itself incapable of providing reliable statistical functionality. It is little wonder that introductory texts on statistics warn students not to use Excel when the results matter (e.g., Keller (2001) and Levine et al. (2002))."

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Paige

10-15-2009 03:49 PM

how bad are any of these problems with excel?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

10-15-2009 03:51 PM

Bad enough so that "introductory texts on statistics warn students not to use Excel when the results matter". In other words, we're not talking about advanced methods in bioinformatics that involve millions of data points ... we are talking about every day statistics.

Do your results matter? Message was edited by: Paige

Do your results matter? Message was edited by: Paige

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Paige

10-15-2009 04:01 PM

one of the things that has been done here and other places where I've worked is using excel addons for monte carlo simulation work like crystal ball. Do these problems persist there?