1. Home
  2. MS Office

Excel 2010 Data Analysis

Introduction

The popularity of Excel around the world needs no explanation. It includes almost all the features to satisfy the needs of professionals. Microsoft Excel also bundles strong features for statistical and engineering calculations. All such features are called Data Analysis techniques and Excel contains the Data Analysis (aka. Analysis Toolpak ) tab.

How To Enable Data Analysis ( Analysis Toolpak)

Data Analysis(Analysis Toolpak) is an add-in for Microsoft Excel which is disabled by default. To enable it click the Office button, then go to Options.

Excel 2010 Options

Click on the Add-Ins option and you will see Analysis ToolPak option in the list. Hit the Go button at the bottom.

Analysis Toolpak Now select the Analysis Toolpak option and click OK to complete the configuration.

Analysis  ToolPak Excel 2010

How To Access Data Analysis

Once you have enabled it, go to the Data tab and locate the Data Analysis option under the Analysis category.

Launch Data Analysis

A Bird’s Eye View Of Data Analysis

In order to use the Data Analysis feature of Excel, you must be familiar with Engineering and Statistical terminology. Hit the Data Analysis option and it will launch the screenshot as shown below. Now choose the appropriate option and Excel will process your data according to the option that you selected.

Data Analysis Followings is the list of Engineering and statistical functions which you can perform with the Data Analysis option.

  • Anova: Single Factor
  • Anova: Two-Factor with Replication
  • Anova: Two-Factor Without Replication
  • Correlation
  • Covariance
  • Descriptive Statistics
  • Exponential Smoothing
  • F-Test Two Sample for Variance
  • Fourier Analysis
  • Histogram
  • Moving Average
  • Random Number Generation
  • Rank and Percents
  • Regression
  • Sampling
  • t-Test: Paired Two Sample for Means
  • t-Test: Two-Sample Assuming Equal Variances
  • t-Test: Two-Sample Assuming Unequal Variances
  • Z-Test: Two-Samples for Mean

73 Comments

  1. data analysis option is not showing in my excel 2010 even after this above process and i need it too much 🙁

  2. It’s pretty frustrating to hide this several menues deep. With all the customization availabel in this version, how do I add frequently used functions, like regression analysis, to a top level toolbar?

  3. At last, after countless hours trying to understand why all the posts for producing bell curves refered to the data anlysis section…..which of course didn’t exist until I came across this invaluable information. Many, many thanks, greatly appreciated. I can’t help wondering why this isn’t made public knowledge or referenced more clearly in Excel. What the heck I have it now…well done you guys!

  4. Thank’s a lot! It was very helpfull. I have an old version of excel at my job, and was so dissapointed by my new one.

  5. Hello, I have Ms 2010 and I have been doing as above million times but it doesn’t work. Data analysis did not show on tool bar. It doesn’t ask me to install. Once I click OK then it gone. When I check on Add-ins it shows that it already active. Is anyone can help me please…

  6. Thanks!!! Have been wracking my brain for hours trying to do this! And project is in, in 3 days! You are simply a life saver!!! 🙂

  7. Thank you so much for this post, my professor only gave instruction for how to use ANOVA on Excel 2003 and 2007. I was wonder why I didn’t have a Data Analysis in my toolbar. This was very helpful.

  8. GREAT HELP
    i was confused regarding the use of excel 2010 in reasearch like t-test and z test. anova n all. this virtually solved all my probs.
    thanks again

  9. Thanks for posting this! I’m pretty frusterated. I’m taking Advanced Statistics for school and our textbook has instructions for Excel 2007 and earlier, and 2010 is a whole new monster, so this was VERY helpful!

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.