ExcelBanter - View Single Post

David Biddulph

"tom ossieur" <tom wrote in message
...
Hi!

I have a table of data:
column A: dates
column B: values

I want to know the average value over a certain period
however, for some dates I have more values than for others, which makes
that
a classic average would give a distorted picture, very much like a wighted
average, which i don't want

eg.
13-Jun-02 8250
22-May-02 8400
16-May-02 8750
15-May-02 8000
12-Apr-02 8000
28-Mar-02 8300
22-Mar-02 8250
22-Mar-02 7750
08-Mar-02 8500
01-Mar-02 8250
26-Feb-02 7500
20-Feb-02 8400
05-Feb-02 6800
05-Feb-02 7000

I understand that the solution might take more than one step as if more
that
one value corresponds with 1 single day, first an average should be
calculated? or not?
is there a single formula covering this request?

I would have thought that one option might be:
1 Take an average for each day where you have more than one value.
2 Interpolate for days where you don't have a value.
3 Average across all the days.
--
David Biddulph