View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Data Analysis with Excel 2007

HI

Click on the round Office ButtonExcel optionsMacrosaddinsbottom of
PageManage Excel AddinsGoclick Analysis ToolpakOK
On the Data tab a new group will appear at far right called Data Analysis.
--
Regards
Roger Govier



"mahsa" wrote in message
...
Please tell me how did you get it... i am going crazy on Excel 2007....

"Wally" wrote:

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