Data Analysis with Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wally - 05 Nov 2007 19:11 GMT

Hello.
At home I have Office 2007 and I have some questions on being able to
run a multiple regression model with Excel 2007.

- In my work copy of Excel 2003 I woudl typically go to Tools and then
Data Analysis to be able to run a statistical analysis. If data
analysis was not installed/available I would click Tools and then Add-
Ins for the Analysis ToolPak.
Can I assume that Data Analysis is probably not included by default
with a typical Office 2007 install? How do I go about enabling it in
Excel 2007?
- As for a multiple regression model, I have data that includes
character data (i.e. gender, color, etc). How do I handle column data
that is character as a statistical analysis only works on numerical
data?

Thank you so much!
Walter

Reply to this Message

Wally - 05 Nov 2007 20:19 GMT

> Hello.
> At home I have Office 2007 and I have some questions on being able to
[quoted text clipped - 14 lines]
> Thank you so much!
> Walter

Actually I found the answers I need. Thanks anyway!!

I do have one related question though----if I'm running a multiple
regression and I have two columns of qualitative variables I need to
change those variables into numerical data.
Let's say I have data for a person's gender (m/f) and data for colors
(black/white). I can change the gender to 0 and 1. Can I also use
the same values of 0 and 1 for the colors or should I instead use 3
and 4, for instance. Does it matter in the Excel results?

Thanks,
Walter

Reply to this Message

Jerry W. Lewis - 06 Nov 2007 13:30 GMT

The specific values that code your qualtative levels are immaterial to the
ANOVA (analysis of variance), but would change the interpretation of the
regression coefficients (which you may not care about).

If you do care about the regression coefficients, then you would typically
use either 0,1 or -1,1 for your coding.

Jerry

> Actually I found the answers I need. Thanks anyway!!
>
[quoted text clipped - 8 lines]
> Thanks,
> Walter

Reply to this Message

mahsa - 17 Nov 2007 04:46 GMT

Please tell me how did you get it... i am going crazy on Excel 2007....

> Hello.
> At home I have Office 2007 and I have some questions on being able to
[quoted text clipped - 14 lines]
> Thank you so much!
> Walter

Reply to this Message

Roger Govier - 17 Nov 2007 18:19 GMT

HI

Click on the round Office Button>Excel options>Macros>addins>bottom of
Page>Manage Excel Addins>Go>click Analysis Toolpak>OK>
On the Data tab a new group will appear at far right called Data Analysis.

Signature

Regards
Roger Govier

> Please tell me how did you get it... i am going crazy on Excel 2007....
>
[quoted text clipped - 16 lines]
>> Thank you so much!
>> Walter

Reply to this Message