Median by groups

F

freefighter

My question is about median calculation. If there is a simple list of data,
its easy to do. But when we want to calculate median of a variable for one or
two groups then I dont know what to do ? Say I have a 300 line list
containing selling prices of a product in 30 shops for 10 years. I want to
see the median of the seeling price of this product for each year. When I
create a pivot table for this data, there are a number of averages (such as
arithmetic mean) which could be calculated by any group you want. But there
is not a solution for calculating median according to grouped data. If there
is a solution please let me know
Thank you in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top