median

Hi, I am working on a project and have not figured out one aspect: I have daily data that lists the number of rooms occupied through the morning. I wanted to make a dynamic calculation (calculate the Median or percentile, etc) over a specified time period. I.E. I would input a “date range”...

Hey everyone! I am working with a large set of real estate sales data (nearly 38,000 records). It spans from January 1, 2008 until March 31, 2014. I am trying to figure out a way to get the median price for each month and year. So I am looking for 75 median figures (6 years, 3 months). We...

I just can't figure out why my median formula isn't working. I am trying to get the median annual return, based on "groupings" of distances. For example, since A2:A5 are <= 50 miles and are also > 0, I want Excel to give me the median annual return for B2:B5 (which is 0.27). Help! Excel 2012...

Hello In essence what I need is very simple but I cannot find an answer anywhere online. I have a long string of numbers of variable length (sales in a week) in a format where another number simply gets added to the string each week. I think I am right in saying I want to be able to find out...

Looking for ideas on how to combat a new task. Raw Data: Column 1: Date Column 2: Folio # (Reservation #) Column 3: Price Eg. 1/1/14 65451 $60.00 1/1/14 54874 $60.00 1/1/14 78451 $70.00 1/1/14 45612 $60.00 1/2/14 87451 $80.00 1/2/14 98745 $70.00 1/2/14 12346 $80.00 1/2/14 65497 $80.00 etc...

Thanks to Barry Houdini I was able to calculate the average days between events in a table. I have a sales table with fields for salesperson ID, Sales Date, Sale Amount. Each person can have one or many sales in the table. I am trying to calculate the median days between sales for each sales...

I am having an issue that I am hoping some more experienced DAX programmers may be able to help me with. This problem is cross-posted on StackOverflow here (excel - Medians and slicers in DAX - Stack Overflow) with no answers so far. I have been trying to develop a dashboard in Excel 2013 /...

On Excel for Mac 2011 I have a median if array (am using C-S-E) that works for about 5 of my criteria, but when I add in my last criteria, it goes to #NUM!. I know I am missing something basic, and that #NUM! is a clue for where I am going wrong, but can't figure it out... So I have for...

Hi I wish to calculate the median of a column of numbers where the number is greater than zero. Sometimes there will be text in the column and I want those to be ignored. Reading the help documentation for Excel 2007 it states: "Arguments that are error values or text that cannot be...

I think I could do a simple sum of these two: =SUMIFS(A1:A10,B1:B10,"="&"Red",C1:C10,"="&"2013") =SUMIFS(A1:A10,B1:B10,"="&"Blue",C1:C10,"="&"2013") But wondering if there is a way to embed the OR into the SUMIFS. Like (I can't get this to work though..)...

Hello all- Struggling with multiconditional statements trying to find a median and average. Even trying to calc with just one condition isn't giving the right answer. Folks here just helped me with a COUNTIF (thanks again!) and now I'm trying to take the next step but flailing... Trying to find...

hi, I am trying to calculate the median in an access query. I tried various forums and I can never get it to work... I created a table called: "Ages" In the table called "Ages", I have one column called "Names" and it contains a couple of names. I also have one column called "Age". I...

I am working with an array formula that SUM's on the diagonal.. =(SUM((COLUMN($H$7:$HU$228)-ROW($H$7:$HU$228)=((INDIRECT(H2))-($G$6)))*$H$7:$HU$228)),0) it is part of a matrix i am using and I need to get this formula to work with MEDIAN rather than sum... actually I need this formula to work...

Hi, this should be really easy but im stumped. A1 needs to show "0.95%", or "0.8%", and so on, based on a figure entered into A2. Doesnt need to calculate the percentage out or anything, just return a figure based on A2 being within a certain range. Im confused by IF and AND and cant get that...

we've got a excel sheet populated with column ROA and firm year, there's over 10000+rows of data and we have already sorted the data according to the firm year but now we want to get the median ROA for each year. and the subtotal function only have ave, is there a way aotomatically group the...

Greetings: I am trying to build-up a formula to perform a median test (e.g., chi square) on a set of data. There are a number of conditions that need to be applied when looking up the data that is complicating the formula. Below is a subset of the data in my worksheet. I'm using two tables...

Hi, I have an unsorted column of values which range between 0 and 100. Using VBA formula i need to return the median (in terms of sorted position) value. An added complexity is that i only wish to look at values in the range (column) which meet criteria against another column. e.g consider the...

Hi: Quick issue I'm hoping someone can help me with. Since the Pivot function lacks a median calculation, I need to calculate some median's based off three conditions in a data sheet. I found working formulas for 2 conditions, but not three. Here is what the data like: A B...

Hey guys, I would like to find the monthly median price of daily transactions. For an average I can use a pivot table, but it does not have the median function build in. I have calculated the daily median value using an array formula...

{=MEDIAN(IF('textexport(2)'!J:J>0,'textexport(2)'!F:F))} I keep receiving 0 when using this formula. I want to take the median of values in column F if the corresponding values in colum J are above 0. Any ideas why this does not work.