Tutorial on Analysis ToolPak in Excel

This Tutorial illustrates the use of Excel’s Analysis ToolPak add-in for data analysis. Analysis ToolPak in Excel is an add – in program that helps to analyze the data for the purpose of finance, statistics and Engineering. This tutorial on analysis toolpak in Excel will take you through the method of implementation of analytical methods with examples. Following are the analytical methods that we have implemented.

 

How to install or load Analysis ToolPak in Excel:

In this tutorial we will learn how to load or install the Analysis ToolPak in Excel.

Tutorial on ANALYSIS TOOLPAK IN EXCEL 1

 

One way ANOVA in Excel:

In this Tutorial we will learn how to perform a single factor or One-way ANOVA in Excel. A single factor or one-way ANOVA is used to test the null hypothesis, i.e. the mean from all the population are all equal. And alternate hypothesis is at least one among the mean is different.

                                              H0: μ1 = μ2 = μ3

H1: at least one mean is different.

Create Correlation matrix in Excel:

In this Tutorial we will learn how to create correlation matrix in Excel. Correlation is used to measure strength of the relationship between two variables. It can be positive, negative or zero.

Tutorial on ANALYSIS TOOLPAK IN EXCEL 2

 

 

Create Covariance matrix in Excel:

In this Tutorial we will learn how to create covariance matrix in Excel. Covariance is a measure of how much two random variables vary together.

Tutorial on ANALYSIS TOOLPAK IN EXCEL 3

 

Summary Statistics in Excel:

In this tutorial we will learn how to create a summary statistics or descriptive statistics in Excel for a given set of values.

Tutorial on ANALYSIS TOOLPAK IN EXCEL 4

 

Exponential Smoothing in Excel:

In this tutorial we will learn how to implement Exponential smoothing in Excel for a time series data. Exponential smoothing is a statistical smoothing technique for detecting significant changes in data by ignoring the fluctuations irrelevant to the purpose.

Tutorial on ANALYSIS TOOLPAK IN EXCEL 5

 

 

F Test in Excel:

In this tutorial we will learn how to perform F Test in Excel. When we want to compare two variances we use F Test. F Test is the test of null hypothesis, which states the variance of two population are equal.

H0: σ12 = σ22

H1: σ12 ≠ σ22

Create Histogram in Excel:

In this tutorial we will see how to create Histogram in Excel. Histogram is nothing but the frequency distribution of data.

Tutorial on ANALYSIS TOOLPAK IN EXCEL 6

Moving Average in Excel:

In this tutorial we will learn how to compute Moving Average in Excel. Moving Average can be defined as the Mean of time series data from several consecutive periods.

Tutorial on ANALYSIS TOOLPAK IN EXCEL 7

T Test in Excel:

In this tutorial we will learn how to perform T Test in Excel. When we want to compare two means we use T Test. T Test is the test of null hypothesis, which states the mean of two population are equal.

H0: μ1 – μ2 = 0

H1: μ1 – μ2 ≠ 0

Z Test in Excel:

In this tutorial we will learn how to perform Z Test in Excel. When we want to compare two means when variance are known, then we use Z Test. Z Test is the test of null hypothesis, which states the mean of two population are equal.

H0: μ1 – μ2 = 0

H1: μ1 – μ2 ≠ 0

Data Sampling – Create Random Sample in Excel :

In this tutorial we will learn how to create sampling in Excel. We will explain how to create a simple random sampling in excel and periodic sample in Excel.

lets get started towards Tutorial on Analysis ToolPak in Excel

next Tutorial on Analysis ToolPak in Excel