+ Reply to Thread
Results 1 to 2 of 2

finding he median subject to certain criteria

  1. 02-20-2007, 02:40 PM #1
    Cubsfan1
    Cubsfan1 is offline
    Registered User
    Join Date
    02-20-2007
    Posts
    3

    Question finding the median subject to certain criteria

    I have a data set 1557 rows by 26 columns. I am looking to get the mean and median values of column x for all associated values when column s is greater than 360. Any ideas?
    Last edited by Cubsfan1; 02-20-2007 at 03:14 PM.
    Reply With QuoteRegister To Reply
  2. 02-20-2007, 04:14 PM #2
    duane
    duane is offline
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    =median(if(s1:s1500>360,x1:x1500))

    an array formula so instead of enter use control+shift+enter

    similar for average function
    not a professional, just trying to assist.....
    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)

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