On Sun, 5 Feb 2006 15:43:26 -0800, "Paula"
wrote:

I am building a multiple linear regression model to predict peak power demant
using maximum daily temerature (in degrees) and the day of the week as
independent variables. I am unsure how to code the days of the week in order
to get the result I want. (when I use the days - the regression add-in tool
states that I'm not using the correct type of data, its non-numeric). I
believe this model will have 7 seperate independent variables, but am unsure
on how to get there.

Sunday = 1
Monday = 2

etc.

or, if you have actual dates, use the WEEKDAY worksheet function.


--ron