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

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