1/5/16

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.









11 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
  6. I really impressed after read this because of some quality work and informative thoughts . I just wanna say thanks for the writer and wish you all the best for coming!. Using the Pareto Chart

    ReplyDelete
  7. When this happen we are forced to look for some alternative ways that will help us go on with our daily activities.Safer Reviews

    ReplyDelete
  8. The lines are distinguished by the numbers on the left side section on the left half of the screen. There are up to 1,048,576 columns in an Excel accounting page. Excel Expert

    ReplyDelete
  9. Thanks for taking the time to discuss this, I feel strongly about it and love learning more on that topic. If possible, while you gain knowledge, would you mind updating your blog with more information? It is extremely helpful for me. help with excel spreadsheet

    ReplyDelete
  10. The Microsoft Office suite is adequately coordinated to make this generally clear. excel consultants uk

    ReplyDelete
  11. The information you have posted is very useful. The sites you have referred was good. Thanks for sharing this:Tables

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Mad About Computer. Powered by Blogger.