Calculate mean and st dev from hist weather data

Hi,

I have hourly weather data for every year from 2000-2013. Please see attached for the weather data format.

I would like to determine the mean as well as st dev values for every hour!

Can you please support?

best

Answer 1

[Star Strider]

Maybe I’m missing something in your description, but with one scalar value for each hour, the mean is that value, and the standard deviation is 0 by definition.

[Endric Schenk]

I have data from year 2000 through 2013, which mean that I have 13 values, for example, for July 3rd 1pm. Sorry for the too short description above.

[Star Strider]

I have to imagine what your data look like, so I created a column vector of 13 years of hourly wind data, then reshaped it to a 24-row matrix, and took the statistics along the rows:

WindSpeed = randi(40, fix(365.25*13)*24, 1);                % Create Wind Speed Data As One Column Vector (No Missing Data)
WindSpeed_Hrs = reshape(WindSpeed, 24, []);                 % Matrix (24xN)
WindWpeedMean = mean(WindSpeed_Hrs, 2);                     % Take Mean By Rows, Across Columns
WindWpeedStDv = std(WindSpeed_Hrs, [], 2);                  % Take Mean By Rows, Across Columns