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 the Median (To IGNORE peaks and troughs such a 0 sales etc when a product was out of stock).
Please help me do this? It would save me a lot of time using manual judgement each time.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Any help would be majorly appreciated!
Many thanks
Mark
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 the Median (To IGNORE peaks and troughs such a 0 sales etc when a product was out of stock).
Please help me do this? It would save me a lot of time using manual judgement each time.
Product | Sales/week | Median sales |
Bench | 0,0,9,0,9,10,13,8,0,0,13 | ? |
Seat | 2,3,2,8,2,3,4,5,0,0,0 | ? |
Tennis Racket | 22,0,4,9,22,35 | ? |
10L Paint | 89,101,165,50 | ? |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Any help would be majorly appreciated!
Many thanks
Mark