The Analysis ToolPak in Excel 2010

 

In this article we will learn about the Analysis Toolpak in Excel.

The Analysis ToolPak is an add-on in Microsoft Excel. By default this add-in is not installed in Excel.

Steps for user to manually install it:

  • Click on File ribbon
  • Click on Options

img1

  • From Options, select Add-Ins
  • Select Analysis ToolPak and click on Go button

img2

  • You can see 4 Add-Ins options are available, check the Analysis ToolPak

img3

  • Click on OK button
  • When you check Data ribbon, this time you will see Data Analysis option appears in Analysis Group.

img4

  • When you click on Data Analysis, you will find the dialog box as shown below:

img5

There are a total of 19 options available in the Data Analysis:

1. Anova: Single Factor
2. Anova: Two-Factor with Replication
3. Anova: Two-Factor without Replication
4. Correlation
5. Covariance
6. Descriptive Statistics
7. Exponential Smoothing
8. F-Test Two Sample for Variance
9. Fourier Analysis
10. Histogram
11. Moving Average
12. Random Number Generation
13. Rank and Percentile
14. Regression
15. Sampling
16. t-Test: Paired Two Sample for Means
17. t-Test: Two-Sample Assuming Equal Variances
18. t-Test: Two-Sample Assuming Unequal Variances
19. Z-Test: Two-Samples for Mean

An add-in is simply a hidden tool that adds new features in Microsoft Excel 2010 and 2013.



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>