answersLogoWhite

0

If you want to get the median of numbers within the first quartile, you have to use the QUARTILE, MEDIAN and IF functions together and then enter it as an array formula. Say your values are in the cells from E2 to E27.

=MEDIAN( IF( E2:E27<=QUARTILE( E2:E27,1 ), E2:E27 ) )

To enter it as an array formula, you must press Ctrl- Shift - Enter together. The formula will then appear with curly braces around it, indicating that it is an array function.

User Avatar

Wiki User

9y ago

Still curious? Ask our experts.

Chat with our AI personalities

BlakeBlake
As your older brother, I've been where you are—maybe not exactly, but close enough.
Chat with Blake
SteveSteve
Knowledge is a journey, you know? We'll get there.
Chat with Steve
TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga

Add your answer:

Earn +20 pts
Q: What is the Excel formula for Median quartile 1?
Write your answer...
Submit
Still have questions?
magnify glass
imp