When working with datasets in Excel, sometimes we need to perform some basic statistical analysis on the data. We might want to look at the mean value, max value and so on. One value that is often valuable and easy to calculate in Excel is the range. In this simple guide, we are going to…
This guide will provide a step by step run through on how to make a Scatter Plot in Excel. Scatter Plots can be a really useful visual representation of our data, especially when we are hoping to find any trends and correlations between two separate variables. Luckily, making a scatter plot in Excel using two…
The Excel COUNTA function is a built in function that is used as a relatively simple formula to count the number of cells that are not empty – containing numbers, text, strings in general, TRUE and so on. In this simple guide we will run through how to use the Excel COUNTA function, along with…
To separate names in excel we can simply use the LEFT and RIGHT formulas, or use the built in text to columns function. Steps for both of these methods will be explained in this guide.
The ROUNDDOWN Function allows us to easily Round down in Excel by a specified value. This can be super handy when working with a lot of data that may have far too many decimals for what we are looking to work with. Rounding down a number isn’t necessarily the most complicated thing in the world,…
Calculating Poisson Distribution in Excel is one of the many handy statistical functions that we can run with a simple formula. Poisson Distribution is a measure that we can use to predict the probability of something occurring when provided with the number of times it occurs over a period. Excel makes this super easy using…
Learning how to transpose in Excel can be a super handy skill to learn. Transposing data takes an array and flips it horizontally or vertically, depending on the initial ouutput. This can be very useful when we receive a spreadsheet that has a whole lot of horizontal rows of data, but we want the structure…
The Excel FV Function is one of the more powerful financial functions within Excel. It let’s us calculate the future value of an investment based on entering a series of inputs. In this simple guide, we are going to run through how to use the Excel FV function. We will cover: Let’s get started with…
Learning how to Capitalize in Excel can be super handy in a range of scenarios. When working with strings of text in Excel, sometimes the overall formatting of the data we are working with isn’t ideal. Luckily, we can very easily run functions to perform tasks including capitalizing in Excel. In this simple guide, we…
Excel has a pretty large range of statistics functions built in to it, including a lot of the standard measures you would expect when working with data – SUM, MODE, MEDIAN, Standard Deviation and so on. Descriptive Statistics in Excel in essentially an all in one tool that let’s us very quickly and easily measure…