Get instant live Excel expert help to learn how to create a statistical function in Excel?

please help i need to find median and quartile measures from this set of data

Hi I need to find out what this excel formula means =(NETWORKDAYS(F2,Q2,'Change of Status'!$A$1:$A$17)-1)*("16:00"-"08:00")+IF(NETWORKDAYS(P2,P2,'Change of Status'!$A$1:$A$17),MEDIAN(MOD(P2,1),"16:00","08:00"),"16:00")-MEDIAN(NETWORKDAYS(F2,F2,'Change of Status'!$A$1:$A$17)*MOD(F2,1),"16:00","08:00") FYI the "change of status" is a tab that includes holidays for the year, Thanks

Hi, I have two types of data. One shows the distribution of a large data set (highest, high quartile, median, low quartile, and lowest.). Another shows the data of 7 companies (out of the large data set). I want to make a Box and Wisker chart for the first data and a scatter chart (on one vertical line) for the second data, and put them in one graph. Is it possible to make it?

How do I explain this calculation a. =(NETWORKDAYS(C2,G2,$O$2)-1)*("17:00"-"8:00")+IF(NETWORKDAYS(G2,G2,$O$2),MEDIAN(MOD(G2,1),"17:00","8:00"),"17:00")-MEDIAN(NETWORKDAYS(C2,C2,$V$2)*MOD(C2,1),"17:00","8:00")

Need help explain a formula =(NETWORKDAYS(C2,G2,$O$2)-1)*("17:00"-"8:00")+IF(NETWORKDAYS(G2,G2,$O$2),MEDIAN(MOD(G2,1),"17:00","8:00"),"17:00")-MEDIAN(NETWORKDAYS(C2,C2,$V$2)*MOD(C2,1),"17:00","8:00")

I need to calculate the median & mean number of calls to a lead before that lead was first marked as interested?

Is there a formula to find a mean or median of the same column in multiple (≥200) sheets?

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

I had some help with this chart yesterday but have thought about it and would like to try something different. See sheet 1 on attached spreadsheet. I'd like to have Range values as a stacked column and hide the Range bottom of the stack as shown. Then have the median as a line chart, also as shown. The Sale Values Adopted can also remain as shown but the values outside the ranges will then clearly shown as in the hidden bottom of the column stack. Some problems though: 1. Want 1-4 on x axis to be labelled as As New/Full Renovated, Good, Fair and Poor. 2. The stacked columns should pull the data from each row not from the columns. See file

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))