+ Reply to Thread
Results 1 to 5 of 5

P Value from Pearson r

Hybrid View

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

    Re: P Value from Pearson r

    Thanks SHG.
    The tables on the internet have no reference points or formulas that I can find.
    Will have to keep trying.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,018

    Re: P Value from Pearson r

    Here, try this:

    Biggest difference is in last column..

    Rest is more or less within 5%, if that's OK for you.
    Attached Files Attached Files
    Never use Merged Cells in Excel

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,018

    Re: P Value from Pearson r

    However, there is slightly deviation for smaller Cl values... Looks like they become numb to the left..

    it would be nice to see how result behave for Cl --> 0 so I could modificate formula.
    But there is no enough data.

    From the picture you can see Table values approaching to 1 (or some other value) while Formula values going to infinity.

    Of course, if you don't need lower values then you can use this but if you need higher precision (espetially in the middle of the table) then data should be separated for N over or below 10.
    Attached Images Attached Images

+ Reply to Thread

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