What is CLT? The Central Limit Theorem states that: the sampling distribution of the sample means approaches a normal distribution as the size gets larger no matter the shape of the distribution. Confused?

In the article How To Create Excel Functions With Python, I talked about how you can use Python in Excel to create your own Excel functions, also known as User Defined Functions (U.D.F). Since Python and R are popular in the world of Data Science, we now have add-ins to…

It is a popular saying that action speaks louder than word, which is why in the field of data analysis we can’t over-emphasize the importance of data visualization. A single visualization has the power to convey loads of information. In this article, you will be learning how…

Excel is one of the most widely used data analytics tools due to the fact that it’s easy to use, especially for Non-technical analytics professionals. But when it comes to creating custom functions and tasks, Excel VBA is a programming language that allows you to write custom functions not available…

Legend says, the secrets and treasures of the world are hidden in books but humans are lazy to search for them, thanks to Google. If you are someone that likes reading books and more importantly uses the R Programming language, this article is for you. Based on my opinion, these…

Not here to continue the unending war of R vs Python, preach to you how R is an awesome and better programming language for Data Science than Python or how the use of white spaces irritates most of us. I am here to talk about how you can create and…

A client I worked for recently told me, a publication he is submitting his article to, only accepts 6 plots and he wanted me to combine some plots into a single plot. After extensive research, I was able to come up with some ideas on how to combine multiple plots…

Do you want to leave the CSV club? well, this post is for you. In this post, I am going to show you how you can retrieve data from API and also use it for analysis. But first, we need to understand the meaning of the term API. What is…

Power BI and R are two giants in the world of data but with different use cases. While Power BI is used in the field of Business Intelligence to build reports and interactive dashboards, R is a programming language for statistical analysis and data science. In this post, I am…