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

tamir caras

New Member
Joined
Sep 21, 2009
Messages
2
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
:confused:
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

tamir caras

New Member
Joined
Sep 21, 2009
Messages
2
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

Active Member
Joined
Apr 2, 2009
Messages
404
Hi Tamir !

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

Watch MrExcel Video

Forum statistics

Threads
1,118,567
Messages
5,572,962
Members
412,491
Latest member
tweetytoon
Top