Get instant live expert help on median of two numbers

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need to find the median off a list of numbers that match a criteria of the row next to it that are percents. the median needs to be based of the numbers that fall in between 2 different percents
Solved by K. D. in 19 mins
Hello. I cannot get this formula to work. The two address functions work fine independently but not inside of the Median function. I suspect it's due to the fact that the Address functions result in a text value and the colon separates the two functions, but I'm baffled. Your assistance is appreciated. =MEDIAN(ADDRESS(COUNTA(B:B)-5,2):ADDRESS(COUNTA(B:B),2))
Solved by E. W. in 14 mins
please help i need to find median and quartile measures from this set of data
Solved by Z. Y. in 27 mins
I have a pivot table and would like to incorporate a median calculation along with the average calc. Avg is easy as it's one of the calculations available in the list but not median.
Solved by S. D. in 21 mins
Now use the RANDBETWEEN function in Microsoft Excel to select two simple random samples of 10 days sample and 500 days sample from the population. Using just your samples, calculate the mean, median, standard deviations and mode if applicable for each random sample. [20%].
Solved by D. S. in 26 mins