Using DataWrapper


This is my first post on using datawrapper to map spatial data.

The fertilizer sales that has happened in India (state wise) is mapped using datawrapper and is presented below.

(The sales is given in tonnes and the sales for Andhra Pradesh includes the sales for states of Andhra Pradesh & Telangana).

Comments

Post a Comment

Popular posts from this blog

Monte Carlo Simulation in Excel

Image
Monte Carlo simulation in MS Excel We can evaluate possible scenarios in MS Excel using the help of simulation. To understand this we need to understand what is simulation & how can this be implemented in Excel. If we want to model a process, a process is typically represented as: Y = f(x1, x2…) Now in a simulation exercise, we try to estimate the ranges of the input variables and vary the input variables in this range for a sufficient number of iterations and then try to understand the distribution of the output Y. For example if we try to calculate the corpus accumulated during a period of 20 years wherein the investment amount varies between 1000 to 3500 per month and the growth expected in the corpus lies between -5% and 12%. We use the Excel formula RANDBETWEEN(1000,3500) to generate random investment amount  per month and then multiply by 12 to calculate yearly investments. The interest rate per year is also generated using RANDBETWEEN(-5,12)...
Read more

MRF story...

Image
There was this news article recently about a man who received few share certificate from his grandfather. The shares were that of MRF Ltd. and were supposedly worth INR 130 Crores now. Apparently the shares were bought sometime in 1990 or 1991 and were long forgotten by his grandfather. To illustrate the wealth creating impact of MRF Ltd, let us look at the returns given the share over the years. For simplicity, I have considered only the closing prices and have ignored the stock splits and the dividends the stock may have given. As can be seen from above the stock has exhibited a stupendous CAGR 34% since 1991 till 2017. All data is sourced from BSE website. Hypothetically speaking if someone had invested Rs 5000 in 1991 in this stock, he would have had a capital of Rs 1.01 Crores at present valuation. This illustrates the wealth creation potential of good businesses.
Read more