Get instant live expert help on median function in excel

“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

In cell C3, use a function to calculate the median amount spent at the spa by the wedding parties.
Solved by O. E. in 23 mins
Hi, my name is Henry. I am working with the excel to analyse my data for psychological experiment. I have to code 4 condition. 0=both masculinity score and femininity score lower than median 1=masculinity score over median but feminity score lower than median, and it is male 2= masculinity score lower than median but femininity score over median, and it is female 3=both score over median I tried to make the "nested IF function" but it said error after I made this formula: =IF((AX>=2.727272,AY>=3.117646),"3", IF((AU=1,AX>=2.727272,AY<3.117647),"1", IF((AU=2,AX<2.727272,AY>=3.117647),"2","0"))) I dont get why it is wrong, thanks!
Solved by C. S. in 25 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
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
I need to extract multiple values that meet a certain vlookup criteria and in the same function I would like to find the median of these values that are returned.
Solved by C. J. in 12 mins