Excel for Statistics

How to Perform Regression Analysis in Excel? (3 Methods)

Regression Analysis helps to predict values depending on two or more variables. In this article, we will show you how to perform regression analysis ...

Anova in Excel (One and Two-Way)

In this Excel tutorial, you will learn everything about ANOVA in Excel. We will show the way of enabling the Data Analysis feature and step-by-step ...

Excel Interpolation (Linear & Non-linear Interpolation)

We can use interpolation in financial analysis to estimate missing values. In engineering, estimation of variables like temperature or pressure can ...

Confidence Interval in Excel (Upper & Lower Limit)

In this article, you will learn about confidence interval in Excel. You will learn the formula, calculations, and different functions for confidence. ...

Excel Probability

In this article, we have used PROB, fractional method, NORM.DIST and NORMDIST function to find out Excel probability. Unraveling uncertainty in ...

Bell Curve in Excel (Plot and Format)

In this article, we will learn about the Bell curve in Excel. You will get the step-by-step procedure to draw a Bell curve with the necessary ...

Frequency Distribution in Excel (4 Suitable Methods)

Frequency distribution in Excel refers to a tabular representation that shows the number of occurrences of each value or range of values in a ...

Tally in Excel (All You Need to Know)

In this article, we will talk about and show how to work with tally in Excel. Following some easy and effective techniques, we will do the task ...

How to Perform Bootstrapping in Excel (with Easy Steps)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. This article ...

Scaling Formula in Excel (6 Practical Examples)

There are different ways to scale data in Excel. We can present data within a range or based on a scaling factor. In this article, we will show ...

How to Calculate Bootstrapping Spot Rates in Excel (2 Examples)

Are you an investor? Or are you willing to buy bonds or government securities? Then, you must want to know the future rate of these financial ...

How to Resample Time Series in Excel (3 Examples)

If you are trying to resample time series in Excel, then you can follow this article. Sometimes you may need to redistribute the time spaces of your ...

How to Calculate Sigma in Excel (3 Effective Methods)

This tutorial will demonstrate how to calculate sigma in Excel. The term Sigma represents the Standard Deviation which is a measurement of the ...

How to Extrapolate Data in Excel (5 Handy Ways)

Microsoft Excel comes to the rescue in the method for calculating numbers outside of a known location of numerical data. It is sufficient to use the ...

How to Create a Survey in Excel (2 Easy Methods)

If you want to create a survey in Excel, this article is for you. Here, we will walk you through 2 easy and effective methods to do the task ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo