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.
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.
Please histogram and other function are not available in you post
ReplyDeletePlease send me this following info
Please histogram and other function are not available in you post
ReplyDeletePlease send me this following info
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.
ReplyDeleteThis 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
ReplyDeleteBreathtakingly delightful utilization of words.
ReplyDeletecanon ink
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
ReplyDeleteWhen this happen we are forced to look for some alternative ways that will help us go on with our daily activities.Safer Reviews
ReplyDeleteThe 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
ReplyDeleteThanks 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
ReplyDeleteThe Microsoft Office suite is adequately coordinated to make this generally clear. excel consultants uk
ReplyDeleteThe information you have posted is very useful. The sites you have referred was good. Thanks for sharing this:Tables
ReplyDelete