Data Analysis

Learn about Analysis ToolPak and How to Activate

Analysis ToolPak is a very powerful Microsoft Excel add-in which has a pack of tools you can use to do data analysis tasks such as ANOVA test, descriptive statistics, generating histograms and regression analysis. Total of nineteen analysis tool are there in this add-in that comes with the latest Microsoft Excel version which Excel 2019.

Linear Regression analysis in Excel- A complete guide

In this tutorial, we discuss how to do a regression analysis in Microsoft Excel.If you do not know where is the regression in excel, what are functions and methods we can use to do regression analysis and how to interpret the regression analysis results, this is the best tutorial for you.

One variable data table in excel – Easy 5 Step Guide

This tutorial created using Microsoft Excel 2016. Other compatible versions are Excel for Office 365 Excel for Office 365 for Mac; Excel 2016; Excel 2019 for Mac; Excel 2013; Excel 2010; Excel 2007; Excel 2016 for Mac; Excel for Mac 2011. If you find any issues using Data Tables in those versions, please leave a

Two Variable Data Table In Excel – Easy 4 Step Guide

This tutorial created using Microsoft Excel 2016. Other compatible versions are Excel for Office 365 Excel for Office 365 for Mac; Excel 2016; Excel 2019 for Mac; Excel 2013; Excel 2010; Excel 2007; Excel 2016 for Mac; Excel for Mac 2011. If you find any issues doing regression analysis in those versions, please leave a

What is Pivot Table feature in Excel ?

Microsoft excel Pivot table is a very powerful feature, if not the most powerful feature available for data analyzing and summarizing. But it is also a least understood feature by the most. I ask you to closely follow this tutorial series. Then, you will learn how easy to use the Pivot Table feature. May be

How to create a Pivot Table in Excel?

In the previous tutorial we learnt what is the pivot table feature in Excel. In this tutorial you will be able to learn how to create a Pivot Table. Let’s move straight into a simple example. This guide will be very easy and useful for you to understand the essential steps of how to create