Datarmatics  
RESEARCH-RELATED QUESTION & ANSWERS RESEARCH CONCEPTS | SEARCH WHATSAPP DISCUSSION
Research Section | Analytics Tools | Blog | Scholarly Works | Machine Learning |Data Science
AI and Machine Learning Section
 
Digital Research
 
 
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.

This is a list of things you can do with MS Excel Data Analytics ToolPack

  • Single Factor Analysis of Variance
  • Two-Factor Analysis of Variance
  • Two Factor Analysis of Variance with Replication
  • Correlation
  • Covariance
  • Descriptive Statistics
  • Exponential Smoothing
  • F-Test Two-Sample for Variances
  • Fourier Series Analysis
  • Histogram Analysis
  • Random Number Generation
  • Regression Analysis
  • Moving Average
  • Paired-Two Sample t-Test for Means
  • Two Sample t-Test With Equal Variances
  • Two Sample t-Test With Unequal Variances
  • Two Sample t-Test for Means

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
Webmail


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