calculating mean daily average

[krzystam]

Hi,

I would like to be able to calculate the mean daily average for
several parameters contained within a monthly data file. The data for
each parameter are stored in columns D-P and range from row 7 to row
2886 or row 2982 depending on the month. Each day contains 96 values
for each parameter.

Could this be done with a combination of formulas or will macros be
required?

Thank you,
Andrea

 

[Bernie Deitrick]

Andrea,

Since you have the same number of data points for each day, the mean daily
average (or, the _average_ of the averages) is the same as the average of
all the data points.

If you had differing numbers of data points per day, then you would need to
average the daily average....

If I have misunderstood your requirements, post again.....

HTH,
Bernie
MS Excel MVP

 

[krzystam]

Sorry for not clarifying, but there are a maximum of 96 values per day
while the actual number of data values per day vary due to missing
data etc.

Thank you,

Andrea

 

[Bernie Deitrick]

Andrea,

The easiest way is to select your data, then use Data / Pivot table, and
finish by clicking through. Then drag the date to the row field, and the
values to the data field, and set the field setting to average. That will
produce a table of the average values for each day. Then use an AVERAGE
formula to average the values of the daily averages given in the pivot
table - DON'T use the grand average given by the pivot table - which is an
unweighted average.

HTH,
Bernie
MS Excel MVP