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 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.
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 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.