Correlation and Regression: When to use these 2 in analysis
Correlation and Regression What is a correlation: Correlation is a test in statistics to get to know if there is …
Correlation and Regression: When to use these 2 in analysis Read More »
What are measures of dispersion: How to calculate range, variance, Quartile and standard deviation
An absolute measure of dispersion is one that measures dispersion in terms of the same units as the unit of data. if the unit of data is meter, kilogram or mile then measure of dispersion will be in the same unit.
What are measures of central tendency: How to calculate it in Excel?
What are measures of central tendency? A measure of central tendency is a single value that attempts to describe a set of …
What are measures of central tendency: How to calculate it in Excel? Read More »
What is Data: 2 types of data and their general understanding
What is Data Data are basically units of information that are usually numeric. Technically it is a set of values …
What is Data: 2 types of data and their general understanding Read More »
Excel Slicer: How to use Excel slicer to filter data
Excel Slicer: How to use Excel slicer to filter data What Slicer in excel Slicers are floating buttons in excel …
Excel Slicer: How to use Excel slicer to filter data Read More »
What is Spark lines in Excel and How to use it in 3 different ways?
What is Spark lines in Excel Sparklines also known as micro charts adds rich visualization to tabular data without taking …
What is Spark lines in Excel and How to use it in 3 different ways? Read More »
How to use XLOOKUP in excel: Understanding it with 3 examples
How to use XLOOKUP in excel XLOOKUP is used to search a range or an array and then return a …
How to use XLOOKUP in excel: Understanding it with 3 examples Read More »
How to add Developer Tab in excel | adding developer tab in excel
How to add Developer Tab in excel The Developer Tab in excel is a very important tab to accomplish many …
How to add Developer Tab in excel | adding developer tab in excel Read More »
VBA in Excel: What is VBA, How to use
VBA in Excel VBA stands for Visual Basic Application. It is an event-driven programming language used by Microsoft for its …
What is Power Query in excel: how to use Power Query in excel
What is Power Query in excel Power Query in excel helps in connecting multiple sources and sizes of data. It …
What is Power Query in excel: how to use Power Query in excel Read More »