# Get instant live expert help on How do I calculate median 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
I need to calculate the median & mean number of calls to a lead before that lead was first marked as interested?
Solved by V. F. in 13 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
Here's the question, ''for participants estimates for the jar with 100 jelly beans calculate and present the mean, median, ​and standard deviation. In addition, calculate the proportion of estimates that were closer than the mean to the correct answer.'' I've already calculated the mean, median and standard deviation but don't know how to do the 2nd part of the question, which is the proportion part.
Solved by B. H. in 25 mins
I am trying out a formula I saw in google but its not working in my excel and producing an error. Can you please help me? =(NETWORKDAYS(StartDT,EndDT)-1)*(StopTime-StartTime)+IF(NETWORKDAYS(EndDT,EndDT),MEDIAN(MOD(EndDT,1),StopTime,StartTime),StopTime)-MEDIAN(NETWORKDAYS(StartDT,StartDT)*MOD(StartDT,1),StopTime,StartTime)
Solved by T. U. in 29 mins