+ Reply to Thread
Results 1 to 2 of 2

Pearson's Formula Error

Hybrid View

  1. #1
    Registered User
    Join Date
    04-15-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    3

    Pearson's Formula Error

    Sorry to post another question so soon but I'm working on a research paper and my professor is slow to respond while you guys are light speed.

    Ok so here's an example of my data that I'm working with:
    1 3
    1 4
    1 3

    When I go to do Pearson's forumal on that set I get the #DIV/0! error. I've learned that I'm getting that error because the denominator is the same, all 1s. What I'm confused about then is how do I see if there's a correlation between the two variables using pearson's formula.

    If I can't use Pearson's formula than I'm wondering what else would work.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Pearson's Formula Error

    Look at how PEARSON is calculated in Help; you can't calculate it if either series is flat, and correlation has no meaning. What's the average of no numbers?
    Entia non sunt multiplicanda sine necessitate

+ 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