Multiple Regression with Discrete and Continuous variables in Excel 2007

[anikamashru]

Hi,

I've got lots of rows of data in Excel (around 3,500), and multiple variables.

1 of my variables is continuous (company revenues)
1 of my variables is a Yes or No
3 of my variables have a few (3-5) discrete options
The output is money (continuous).

I'm trying to use Excel 2007 to find the effect each variable has on the output.
I've tried using things like multiple regression, but I take it that doesn't work too well with discrete inputs..?

My stats/excel knowledge is fairly basic, so any help would be much appreciated!

Thank you in advance.

 

[AhoyNC]

Perhaps the attached link will be of some help.

Multiple Regression - Dummy variables and interactions - example in Excel - YouTube