BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
9 REPLIES 9
Doc_Duke
Rhodochrosite | Level 12
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.
deleted_user
Not applicable
ah but when they calculated the correlation in excel the number was not the same

anyone know what excel is really doing?
Paige
Quartz | Level 8
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.
deleted_user
Not applicable
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
Doc_Duke
Rhodochrosite | Level 12
just go to Google scholar and search for
excel statistics accuracy
and you will find a host of references.
Paige
Quartz | Level 8
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))."
deleted_user
Not applicable
how bad are any of these problems with excel?
Paige
Quartz | Level 8
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
deleted_user
Not applicable
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?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 9 replies
  • 958 views
  • 0 likes
  • 3 in conversation