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 ...

How to Do F Test in Excel

In this article, we will explore how to do F test in Excel, using two methods: the built-in function and the Data Analysis ToolPak. Moreover, we will ...

How to Do a T Test in Excel (2 Ways with Interpretation of Results)

The article will show you how to do a T Test in Excel. T-Tests are hypothesis tests that evaluate one or two groups' means. Hypothesis tests employ ...

Excel for Statistics (Functions, Tools and Examples)

In this article, we will present 111 Excel functions for statistics and 10 practical examples to apply some of these functions. We will also discuss ...

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 ...

How to Calculate Variance in Excel (3 Handy Approaches)

In this article, we shall show you how to calculate variance in Excel. Variance is one of the most useful concepts in statistics. It gives the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo