Weather data in Excel - question
I wonder if someone can suggest a way in excel to analyse weather data please.
I have a weather station which records many perameters every five minutes, into an excel spreadsheet. For the month of August there are 5,660 lines and 23 columns. Each day is around 285 lines. Each 5 minute record is a single line. I want if I can to produce a bell curve of temperature.
The temperature values on any day may be from 19.9 to 33.5 (degrees) in a single column.
I have tried and tried to find a way in excel to break these figures down so they are more meaningful by, grouping, or banding or using a logarathmic axis, but can't do it.
Is there a way to have excel create a bell curve of a day, a week or the whole month, to show temperature spread?
Thanks for reading the question
NW
Attachment | Size |
---|---|
Aug 2014 records RECORDS.xlsx | 634.63 KB |
Recent comments
5 years 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago