How to activate Data Analysis tool in MS Excel 2007

Asked By damnhasan 0 points N/A Posted on - 10/31/2011

I want to use "Data Analysis" tool in MS Excel 2007 to do some statistical analysis. But, unfortunately I am not finding the tool in MS Excel 2007 version as I find it in 2003 version. It would be highly appreciated if anyone help me out to solve the problem. Thanking you in advance for your quick response.

Best regards,

Damn Hasan.

• Status: Open
• Question Views: 1262
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by JENNIFER ROTH

Go To Solution

Best Answer

Best Answer

Answered By JENNIFER ROTH 0 points N/A #98615

How to activate Data Analysis tool in MS Excel 2007

Hello,

• In Excel 2007, you have to activate 'bundle of hardware of data analysis' to use the data analysis tool.
• The method of activating the hardware bundle appears next
• Select the button of Microsoft Office and click in Options of Excel.
• Now click in Add-Ins, in picture to administer, it selects Excel Add-ins.
• Click in going.
• It will see the picture complements available, select the pigeonhole of cross-check hardware for analysis and, next, click in Accepting.
• If the complement cannot see Hardware for analysis in the picture of available complements, click in examining to locate it.
• If it him is requested that the hardware for analysis is not installed in its computer, click in himself to install it.
• After Hardware loads the complement for analysis, the command data analysis is available in the group of analysis in the information card

JR

About JENNIFER ROTH

Questions
2

Answers
13

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 10/31/2011
• Question Category: MS Excel

Answered By pankajvishwakarm 0 points N/A #98616

How to activate Data Analysis tool in MS Excel 2007

1. Click the button of Microsoft Office
2. Click in Options of Excel.
3. Click of Add-Ins, then in administering picture, selects Excel Add-Ins.
4. Click in going.
5. In the picture available Complements, select the hardware for analysis, click in Ok.
   • If hardware for analysis it does not appear, next, to examine to locate it.
   • If bundle(beam) requests that the hardware for analysis is not installed in its computer, click in himself to install it.
6. After Hardware loads the complement for analysis, the command data analysis is available in the group of analysis in the information card

About pankajvishwakarm

Questions
0

Answers
26

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 01/25/2012
• Question Category: MS Excel