- #1
Obanion
- 2
- 0
Hello all,
My boss wants me to create a form of short term wind prediction based off a collection of long term wind data. I haven't taken a course in statistics so this is totally new to me. Basically, the data is organized by Year > Month > Day > Hour > Wind Speed with data stretching back three years. There is also another set of data that spans over a time period of twenty years. Unfortunately, this data isn't of much use to do the absence of a given altitude which renders it useless for our use.
I was given instructions to take the moving average or something of the sort and try to predict at most 6 hours into the future, but I've never had experience with this sort of thing. I'm limited to using Excel as of this moment, but in a few weeks they will shift a thorough analysis to specialists due to the extreme complexion. This further analysis will include humidity, radiation, and all the other requirements for a decent model. Consequently, my predictions do not have to be extremely accurate, but they should be able to provide a general idea of what the wind speed should be.
I'm quite overwhelmed since I've never had this sort of task assigned before. I've worked with Excel before, but it was mostly for very simple data analysis. I'm looking for guides, methods or suggestions on how I would go about doing this analysis. I was hoping that the users at this forum could be of assistance.
Thanks kindly,
Obanion
I can provide more information
My boss wants me to create a form of short term wind prediction based off a collection of long term wind data. I haven't taken a course in statistics so this is totally new to me. Basically, the data is organized by Year > Month > Day > Hour > Wind Speed with data stretching back three years. There is also another set of data that spans over a time period of twenty years. Unfortunately, this data isn't of much use to do the absence of a given altitude which renders it useless for our use.
I was given instructions to take the moving average or something of the sort and try to predict at most 6 hours into the future, but I've never had experience with this sort of thing. I'm limited to using Excel as of this moment, but in a few weeks they will shift a thorough analysis to specialists due to the extreme complexion. This further analysis will include humidity, radiation, and all the other requirements for a decent model. Consequently, my predictions do not have to be extremely accurate, but they should be able to provide a general idea of what the wind speed should be.
I'm quite overwhelmed since I've never had this sort of task assigned before. I've worked with Excel before, but it was mostly for very simple data analysis. I'm looking for guides, methods or suggestions on how I would go about doing this analysis. I was hoping that the users at this forum could be of assistance.
Thanks kindly,
Obanion
I can provide more information