Tuesday, January 5, 2016

How to Load Analysis Toolpak in Excel 2010?

In this tutorial we will teach How to load analysis toolpak in excel 2010? in excel. First about you need to enable to the toolpak. Go to the File tab also known as backstage view and click on option tab as given in Image.
You see the excel window option go to the ADD INS tab and select the analysis toolpak given their, click the go button. you see image and follow step :-


you see a small window open in your screen its ADD INS window. You see the various option please select the option of analysis toolpak.



 How to find the analysis toolpak option? Go to the data tab and click on it you see Data analysis option on right of the screen click on it and you see data analysis option.














For example :- how to use Correlation option in analysis toolpak?
Correlation is a mathematically representation of the relationship between  two values. First select the range of data which you want to do correlation. Then go to data tab and press data analysis option right on the screen, click on it. You see data analysis window on screen , in window you see various option click on correlation option again you see correlation table, In input range column select the range of the data which you want to do correlation and mark the option in checkbox LABLE IN FIRST ROW then go to output option below in window click on it and select the range where you want to show correlation table. Below image shows that the following description


For other example moving average go to the data tab and press data analysis option right on the screen , click on it. you see Moving Average option again click on it and you see the Moving Average window, in which window you see input range click on it column and select the range which you want and uncheck the box LABLE IN FIRST ROW then go to the output option click on it and select the column where you want to show moving average table, after mark the option of chart output and ok .Below image shows that the following description.


If you like this post don't forget like us on Facebook and also follow me on twitter.If you have found any mistake or have any doubt related to above How to load analysis toolpak in excel 2010? in excel tutorial then comment below.









5 comments:

  1. Please histogram and other function are not available in you post
    Please send me this following info

    ReplyDelete
  2. Please histogram and other function are not available in you post
    Please send me this following info

    ReplyDelete
  3. Hi Mahesh , thanks for this info about data analysis techniques. i want to build my career in research and data analysis. i am not too clear about the info you explained. Could you please forward me exemplified notes. Thanks in advance.

    ReplyDelete
  4. This aspect in Forex Scanners is even more vital. That’s because of the fluctuating values of currencies. So currency movements that need to be predicted need to be tracked as well

    ReplyDelete
  5. Breathtakingly delightful utilization of words.
    canon ink

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Contact Form

Name

Email *

Message *

Mad About Computer. Powered by Blogger.