Regression Model in Excel.

[dude777]

Hi All,

Has anyone got any idea how to create a regression model in excel to predict weather at one specific location for 9th of may at 2pm. Has to be done 1 month prior. I have data for weather in that location from 2005 (9.05 2pm) + all data from 01.04.-09.05 2005-2011.. Any possible ways to do it? Maybe not even regression model, maybe some other ways?

[Søren Larsen]

Now, I don't know exactly which variables your dataset contains, but I think it's a pretty ambitious task. Not even professionel forecasters can do that very precisely; and they have some pretty sophisticated weather models.

But you can do regression analyses in Excel; with limited functionality though.