Results 1 to 5 of 5

P Value from Pearson r

Threaded View

  1. #1
    Registered User
    Join Date
    06-07-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    12

    P Value from Pearson r

    I am not sure if this is the correct place to ask this question, but forgive me for having a try if wrong.

    If have a fairly extensive spreadsheet from which I calculate Correlation/Pearson data, giving me an "r" number.

    There are tables on the internet for "P" numbers for comparison. I cannot find anywhere either the formula/equation for these tables, or anything like it within Excel 2007.

    I will attach below a table from the internet. My aim is to have a formula/equation that I can put in a cell to give me the table answers. In other words if by example a formula for if N=5 and CI = .05 then 0.80 etc.

    I hope I have explained myself.

    Many Thanks
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1