+ Reply to Thread
Results 1 to 7 of 7

Morans function

Hybrid View

  1. 06-15-2015, 11:28 AM #1
    trapjooge12
    trapjooge12 is offline
    Registered User
    Join Date
    06-06-2015
    Location
    .
    MS-Off Ver
    .
    Posts
    6

    Morans function

    Please see morans function as listed on Wikipedia. I can't seem to rewrite the formula on here.
    How would I put that into excel?
    Reply With QuoteRegister To Reply
  2. 06-15-2015, 11:34 AM #2
    shg
    shg is offline
    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: Morans function

    Maybe you could post a link ...
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 06-15-2015, 11:39 AM #3
    trapjooge12
    trapjooge12 is offline
    Registered User
    Join Date
    06-06-2015
    Location
    .
    MS-Off Ver
    .
    Posts
    6
    https://en.m.wikipedia.org/wiki/Moran%27s_I
    Reply With QuoteRegister To Reply
  4. 06-15-2015, 11:45 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Morans function

    You could try to follow this:

    http://www.google.co.uk/url?sa=t&rct...,d.ZGU&cad=rja
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  5. 06-15-2015, 11:52 AM #5
    trapjooge12
    trapjooge12 is offline
    Registered User
    Join Date
    06-06-2015
    Location
    .
    MS-Off Ver
    .
    Posts
    6

    Re: Morans function

    Glenn, Fantastic! Ive been looking all over for something like this!
    Reply With QuoteRegister To Reply
  6. 06-15-2015, 11:55 AM #6
    shg
    shg is offline
    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: Morans function

    Maybe ...

    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    1
    w
    X
    2
    4
    4
    3
    1
    3
    5
    2
    5
    2
    4
    1
    4
    5
    3
    5
    xBar
    2
    		 G5: =AVERAGE(X)
    6
    7
    0.6818
    		 G7: {=COUNT(w) / SUM(w) * SUMPRODUCT(w * (X - xBar) * TRANSPOSE(X - xBar)) / SUMPRODUCT((X - xBar)^2)}
    Reply With QuoteRegister To Reply
  7. 06-15-2015, 12:18 PM #7
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Morans function

    Glad to have helped & thanks for the Rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trouble identifying nth instances using *match/index function* with *offset function*
    By donnieboy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  2. Excel 2010 VBA Sheets Copy function works, but then jumps to the beginning of a function
    By mycroft in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  3. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  4. Excel NORM.DIST function gives results greater than 1 with probability mass function. How
    By jano_rajmond in forum Excel General
    Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  5. Inserting an INDEX,MATCH function into a HYPERLINK function instead of cell reference
    By giallofever in forum Excel General
    Replies: 2
    Last Post: 03-20-2009, 01:29 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1