Exell data analysis

  • Thread starter Oliver Cullinan
  • Start date
O

Oliver Cullinan

I am currently trying to analysis guite a large amount of
data.

What I have is a colum of dates and a corresponding temp
and Humidity value.

What I need to do is get an average for each day.

Each day consists of approx 100 values and I have 6 months
worth of data.

If anyone assist me if find a quick way of doing this I
would appricicate it.

Regards

Oliver Cullinan
 
A

Arvi Laanemets

Hi

I assume your data are on sheet Data in range A2:D18000 in columns
Date, Time, Temp, Humidity

Add a sheet Averages with columns
Date, Temp, Humidity

Into A2 enter start date, and fill down for all 6 months

Into B2 enter the formula
=SUMIF(Data!$A$2:$A$18000,A2,Data!$C$2:$C$18000)/COUNTIF(Data!$A$2:$A$18000,
A2)
Into C2 enter the formula
=SUMIF(Data!$A$2:$A$18000,A2,Data!$D$2:$D$18000)/COUNTIF(Data!$A$2:$A$18000,
A2)
Copy both formulas down so for every date on sheet Averages corresponds a
formula.
 
G

Gary Rowe

You should be able to do this with a pivot table. Select data/pivottable,
select the range and put your temperatures in the data area. Select the
field settings and set to average.
 
Top