Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
How can I find a median?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Lori Miller, post: 3264423"] With the (unordered) data set in the range A3:B36, try either of these: =MEDIAN(IF(COLUMN(A:IV)<=B3:B36,A3:A36)) (returns 5 if executed with CTRL+SHIFT+ENTER but assumes ALL frequencies <=255, but could be extended in XL2007.) =LOOKUP(2,1/FREQUENCY(0.5,PROB(A3:A36,B3:B36/SUM(B3:B36),,A3:A36)),A3:A36) (returns 5 also - finds the halfway mark in the cumulative frequencies.) [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
How can I find a median?
Top
