how do i get the p-value for regression or correlation

[tamir caras]

quick one...
i want to get the p value for corresponding r^2 correlation (or regression for that matter). the only way i can get it now is by going to the statistics rout and getting the full stats output etc etc. all i wanted is to have two values - the square (=rsq(......)) and the relevant correlation p value for the same data...
can anyone help?
cheers
tamir

 

[Michaels]

Hello !

Can you post some data ?

 

[tamir caras]

hi there
many thanks for trying to help....
your data example is ready (excel spread sheet), with explanation etc etc... how do i send it over?
(sorry if its a naive or trivial question, im a first timer....)
my email is divething@yahoo.com if you want to make direct contact.
all the best
tamir

 

[Michaels]

Hi Tamir !

You can download Excel HTML Maker and present your data nicely. Its on mrexcel.com.