RESEARCH-RELATED QUESTION AND ANSWERS RESEARCH CONCEPTS
Ask a Question | Research Section | Analytics Tools | Discussion | Blog | Scholarly Works | Data Science
 
 

 
 

DATA ANALYTICS TOOLPACK IN MS EXCEL

This comes handy as an alternative to customized tools such as SPSS, Matlab, etc. Excel Data Analysis Toolpack is an component(Add-In) of MS Excel to allows you to perform more complex data analysis opertions including Correlation and Regression, ANOVA, Histogram among others

How to Use Data Analysis ToolPack

By default the data analysis toolpack icon does not appear in the ribbon. To Add it:

1.Open the Options dialog box (File>Options)

Excel Data Analysis Toolpack

2. Click on Add-Ins

3. Select Analysis Toolpack and Click Go

Analysis Toolpack- Add-Ins Manager

4. Check the Analysis Toolpack and Click OK

At this point the Analysis Toolpack Icon appears under The Analysis section in the ribbon

Contributed by: KINDSON MUNONYE


 
Follow @datarmatics
Mail


Privacy Policy | Terms of Use | Site Map
Copyright 2014. Datarmatics Integrated Services Limited. All Rights Rerserved. Designed by KTTPRO and KTGEN