Data Driven Insights

In this tutorial, we'll explore what percentiles are, what they are used for, the ways of calculating them in Excel, simple examples of such calculations, and possible errors to be aware of when computing percentiles in Excel. Percentiles represent a popular concept and practical method widely used in statistics and having various real-world applications. Because of their usefulness, the great majority of modern programs and programming languages allow easy calculation of percentiles. Microsoft Excel is one such tool. This tutorial will explore what percentiles are, what they are used for, how to calculate them in Excel, simple examples of such calculations, and possible errors to be aware of when computing percentiles in Excel. What Percentiles Are and What They Are Used For? A percentile, or centile, is a value of a variable of interest at or below (or strictly below) which a defined percent of values of that variable fall. In practice, we usually speak about a k-th percentile, w...

Learn how to arrange rows and columns, add values, calculate the sum of a value, and use filtering to choose a subset of a dataset. Using a retail dataset as an example, we'll learn how to use this in Excel. In the information era, there are numerous ways to deal with your data; nonetheless, pivot tables are one of the most straightforward and effective ways to evaluate your data. In this article, we'll show you how to create pivot tables in Excel and how to use them for data analysis.  What are pivot tables? Pivot tables in Excel offer several benefits that enable you to summarize and analyze large amounts of data to help quickly identify trends and patterns. They are a popular user-friendly tool enabling technical/non-technical people alike to dive deeper into their data.  At the most basic level, pivot tables enable you to create a data matrix in a row and column formats. You can apply filtering, sorting, aggregation, and summarization of your data in various ways.  Be...