How to Run a Two-Way Analysis of Variance (ANOVA) in Excel

Recently, we looked at how to Perform a One-Way Analysis of Variance in Excel. In today’s article, we will take that a step further and a look at a Two-Factor ANOVA. The Two-Way Analysis of Variance (ANOVA) is a statistical test to evaluate the difference between the means of more than two groups. It is […]

Perform a One-Way Analysis of Variance (ANOVA) in Excel

The Analysis of Variance (ANOVA) has many varieties, but in essence, it has the purpose of evaluating whether factors are associated with any outcome values. And factors are categorical variables we use to group the outcome variables. In this article, we will not be focusing on the underlying statistical principles and formulas. We will briefly […]

Creating a Variance Analysis Model – Part 2

This article builds upon the theory discussed in Creating a Variance Analysis Model – Part 1. Be sure to read this article before looking at the more practical examples below. Building a Variance Analysis Model in Excel Let’s create an Excel model to perform our variance analysis. For the exercise, we will assume a simple scenario […]

Creating a Variance Analysis Model – Part 1

Today we will take a more detailed look at Variance Analysis. In this article, we will deal with the theory, and in next week’s article, we will build an Excel model to look more practically at the subject. Variance Analysis Variance analysis looks at the differences between planned and actual numbers. This method is used […]

Types of Financial Analysis

Today we will take a brief look into the most commonly used types of Financial Analysis. We will see some examples but will not go into detail for each method. This article aims to show you the vast techniques you can apply when doing financial analytics. Hopefully, after reading it, you will be better equipped […]