# Tag Archives: excel

## Normal Distribution: How to build it and plot it in Excel

The NORM.DIST Function Download the file The NORM.DIST function, as its name implies, returns the normal distribution (continuous probability function) given the mean and the standard deviation of your observations. The NORM.DIST function can return

## Formula to count number of days in a given month (with a twist)

The Data A user on MrExcel Forum asked, given two columns one with a start date and one with an end date, for an excel formula to count the number of days which fall within a

## Excel Forecast Charts (building different Trendlines)

Excel Forecast Charts In the paragraphs below I will show how to calculate the different types of trendlines available in Excel charts: Linear, Exponential, Logarithmic, Polynomial, Power.  Download the Excel file Given a data set

## Alternative Charts for Climate Bonds Report

Climate Bonds Charts Yesterday I saw a post on LinkedIn where the Lux Stock Exchange was sharing some charts done by Climate Bonds.  The full report can be found here. By looking at the charts I thought

## Excel Dot Plots and other charts to plot Number of Students by Country

The Data While browsing the internet looking for students data, I stumbled upon one chart on the OECD website which was plotting number of students by Country divided between tertiary and non tertiary sectors. In

## Excel Marimekko Charts

Excel Marimekko Charts Excel Marimekko Charts are a great way of displaying market or sales data for different companies competing in the same sectors. Download the file Imagine you had the following data: You have

## Ranking in Excel

Ranking in Excel You can use two different function for ranking in Excel: RANK.EQ and RANK.AVG. These two functions do essentially the same job but return different results for the items in your data set that

## Scatter Chart for Countries Education Performance

Scatter Chart for Countries Education Performance I found some interesting data on the OECD website ranking Countries Education Performance of 15 years old from one year to another which I thought would make an interesting