A statistics question

[bradyj7]

Does anybody know if excel has a function to the following.

I have historical data for a whole year with time in one column and CO2 emissions (values between 200 and 600) in another column. I want to figure out, at what time (or time range) statistically do the lowest values of CO2 emissions (in the range 200-250) tend to occur at.

Any ideas?

Help much appreciated.

Thank you

 

[Trevor G]

Can you copy some data in your thread, also are you looking for a date range or specific time of any day?

 

[doublej_jj]

Assumptions:
Column A is Time (time of the day / the hour of the day, ie 1, 2, 3,....22, 23, 24)

Column B is CO2 emission levels

Headers
Column C = Hour of Day
Column D = Frequency
Column E = Average

Additions:
Column C starting in cell C2, the sequential numbers 1 - 24
Cell D2 =sumproduct(($A$1:$A$8760=C2)*($B$1:$B$8760<=250)*1)
Cell E2 =sumproduct(($A$1:$A$8760=C2)*($B$1:$B$8760))/Countif($A$1:$A$8760,C2)

Copy D2 and E2 down for Column C, 1 to 24.

This is probably over-simplified, but may get you started.