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 Read more…
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 Read more…
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 Read more…
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 Read more…
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, Read more…
