Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Median for Year
How do I set up a formula that will calculate the job that produced
the median amount of revenue for each year? (Jobs are counted in the year they were submitted.) My data is set up as below: Columns: A: Customer Name B: Customer Number C: Date Job was Submitted D: Date Job was Returned E: Turnaround Time F: Associate who Completed the Job G: Revenue from Job Thanks in advance for your help, Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Median for Year
try
to get the row try =MATCH(MEDIAN(IF(year(C:C)=2007,G:G)),G:G*(year(C: C)=2007),0) this will select the first job with the median. you can use index match to extract the specific info you want if there are several the job gets a little harder. " wrote: How do I set up a formula that will calculate the job that produced the median amount of revenue for each year? (Jobs are counted in the year they were submitted.) My data is set up as below: Columns: A: Customer Name B: Customer Number C: Date Job was Submitted D: Date Job was Returned E: Turnaround Time F: Associate who Completed the Job G: Revenue from Job Thanks in advance for your help, Kevin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Median for Year
If there is an even number of data points the median will never (?) be one
of those data points. -- Biff Microsoft Excel MVP "bj" wrote in message ... try to get the row try =MATCH(MEDIAN(IF(year(C:C)=2007,G:G)),G:G*(year(C: C)=2007),0) this will select the first job with the median. you can use index match to extract the specific info you want if there are several the job gets a little harder. " wrote: How do I set up a formula that will calculate the job that produced the median amount of revenue for each year? (Jobs are counted in the year they were submitted.) My data is set up as below: Columns: A: Customer Name B: Customer Number C: Date Job was Submitted D: Date Job was Returned E: Turnaround Time F: Associate who Completed the Job G: Revenue from Job Thanks in advance for your help, Kevin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Median for Year
If there is an even number of data points the median will never (?) be one
of those data points. Unless all the data points are the same but in a practical application when is that ever the case? -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... If there is an even number of data points the median will never (?) be one of those data points. -- Biff Microsoft Excel MVP "bj" wrote in message ... try to get the row try =MATCH(MEDIAN(IF(year(C:C)=2007,G:G)),G:G*(year(C: C)=2007),0) this will select the first job with the median. you can use index match to extract the specific info you want if there are several the job gets a little harder. " wrote: How do I set up a formula that will calculate the job that produced the median amount of revenue for each year? (Jobs are counted in the year they were submitted.) My data is set up as below: Columns: A: Customer Name B: Customer Number C: Date Job was Submitted D: Date Job was Returned E: Turnaround Time F: Associate who Completed the Job G: Revenue from Job Thanks in advance for your help, Kevin |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Median for Year
Ok, this is my final** answer <g :
If there is an even number of data points the median will never (?) be one of those data points. Let me rephrase that: If there is an even number of data points the median will most likely not be one of those data points. ** until my next answer -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... If there is an even number of data points the median will never (?) be one of those data points. Unless all the data points are the same but in a practical application when is that ever the case? -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... If there is an even number of data points the median will never (?) be one of those data points. -- Biff Microsoft Excel MVP "bj" wrote in message ... try to get the row try =MATCH(MEDIAN(IF(year(C:C)=2007,G:G)),G:G*(year(C: C)=2007),0) this will select the first job with the median. you can use index match to extract the specific info you want if there are several the job gets a little harder. " wrote: How do I set up a formula that will calculate the job that produced the median amount of revenue for each year? (Jobs are counted in the year they were submitted.) My data is set up as below: Columns: A: Customer Name B: Customer Number C: Date Job was Submitted D: Date Job was Returned E: Turnaround Time F: Associate who Completed the Job G: Revenue from Job Thanks in advance for your help, Kevin |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Median for Year
On Jul 6, 2:28 pm, "T. Valko" wrote:
Ok, this is my final** answer <g : If there is an even number of data points the median will never (?) be one of those data points. Let me rephrase that: If there is an even number of data points the median will most likely not be one of those data points. ** until my next answer -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... If there is an even number of data points the median will never (?) be one of those data points. Unless all the data points are the same but in a practical application when is that ever the case? -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... If there is an even number of data points the median will never (?) be one of those data points. -- Biff Microsoft Excel MVP "bj" wrote in message ... try to get the row try =MATCH(MEDIAN(IF(year(C:C)=2007,G:G)),G:G*(year(C: C)=2007),0) this will select the first job with the median. you can use index match to extract the specific info you want if there are several the job gets a little harder. " wrote: How do I set up a formula that will calculate the job that produced the median amount of revenue for each year? (Jobs are counted in the year they were submitted.) My data is set up as below: Columns: A: Customer Name B: Customer Number C: Date Job was Submitted D: Date Job was Returned E: Turnaround Time F: Associate who Completed the Job G: Revenue from Job Thanks in advance for your help, Kevin The median will only be one of the data points if: 1)There is an odd number of data points. OR 2)There is an even number of data points and the middle two are the same. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Median for Year
"Tim Shnell" wrote in message
oups.com... On Jul 6, 2:28 pm, "T. Valko" wrote: Ok, this is my final** answer <g : If there is an even number of data points the median will never (?) be one of those data points. Let me rephrase that: If there is an even number of data points the median will most likely not be one of those data points. ** until my next answer -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... If there is an even number of data points the median will never (?) be one of those data points. Unless all the data points are the same but in a practical application when is that ever the case? -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... If there is an even number of data points the median will never (?) be one of those data points. -- Biff Microsoft Excel MVP "bj" wrote in message ... try to get the row try =MATCH(MEDIAN(IF(year(C:C)=2007,G:G)),G:G*(year(C: C)=2007),0) this will select the first job with the median. you can use index match to extract the specific info you want if there are several the job gets a little harder. " wrote: How do I set up a formula that will calculate the job that produced the median amount of revenue for each year? (Jobs are counted in the year they were submitted.) My data is set up as below: Columns: A: Customer Name B: Customer Number C: Date Job was Submitted D: Date Job was Returned E: Turnaround Time F: Associate who Completed the Job G: Revenue from Job Thanks in advance for your help, Kevin The median will only be one of the data points if: 1)There is an odd number of data points. OR 2)There is an even number of data points and the middle two are the same. That's an excellent way of explaining it! So, if you're using a MATCH formula to find the MEDIAN there's a good possibilty that it may not exist. -- Biff Microsoft Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
how do I convert a dates in a year quarters in a year? | Excel Discussion (Misc queries) | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel |