Cumulative Distribution Function (CDF) vs Probability Distribution Function (PDF)
The Cumulative Distribution Function (CDF) of a random variable 'X' is the probability that the variable value is less than or equal to 'X'. It is the cumulative of all possible values between two defined ranges.On the other hand, Probability Distribution Function (PDF) is the probability of random variable...
Showing posts with label analytics. Show all posts
Showing posts with label analytics. Show all posts
The difference between DAYS and DAYS360 formulas
DAYS360:
The DAYS360 function is used to calculate number of days between two dates. But it is based on the assumption that each month in a year has 30 days. This method is adopted in some financial institutions for the calculation of interest and other accounting purposes.
DAYS():
However Excel 2016 version has DAYS() formula which calculates the number of calendar days between two dat...
CAGR calculation in Excel
CAGR:
CAGR - Compounded Annual Growth Rate is a measure of growth over a period of time. It is usually calculated for number of years. Businesses use CAGR to measure the growth in their revenue over a period of time. In finance CAGR is used as a measure that indicates appreciation in the value of...
How to use SUMPRODUCT to calculate mean of Discreet Distribution
Discreet Distribution:
A Discreet Distribution is a distribution constructed from a random variable produced by non-negative whole numbers. MEAN or AVERAGE is nothing but Expected Value of a Discreet Distribution.
The MEAN of any discreet distribution is calculated by taking the sum of product of...
How to convert number to words in Excel
In this example let us learn to build excel template to convert a three digit number to words. Consider a three digit number say 256 in cell B1. We need to get "Two Hundred and Fifty Six" in cell C1.
First create two separate table as shown below in sheet 2 of the workbook. Values have to be entered...
Stem and Leaf Diagram in Excel
in analytics
with
No comments
Stem and Leaf Plots:
Stem and Leaf diagram is simple and useful tool to organize data into groups. Representing data in Stem and Leaf diagram gives the birds eye view of data and gives basic picture of how data is distributed across different Levels.
How to construct Stem and Leaf diagram?
Stem and...
How to create barcode in Excel
This tutorial is aimed at generating barcode equivalent of a alphanumeric number into an Excel cell. There are different types of Barcodes, such as
EAN 13,
EAN 8,
UPC A,
UPC E,
Code 128,
ITF 14 and
Code 39.
The first step is to decide on the right Barcode type to create (or print) depending...
How to use Goal Seek in Excel
Goal Seek is one of the most important tool in Excel which helps in calculating the value input when the output is known. In other words, it calculates the value of input for the desired value of output.
Consider an Example, where a product of $ 50000 is bought on installment basis. The down payment...
How to save an Excel Workbook as HTML document?!!
Saving an Excel workbook as HTML document is necessary whenever it is required to publish reports generated in Excel on Web portals.
The following are the steps to save an Excel sheet as HTML document.
1) Open the Excel workbook which you want to save as HTML.
2) Select File menu and click...
How to generate dummy data in Excel
Whenever you want to test a formula or build a data model involving complex business logic, It becomes necessary to create set of sample data by yourself to work with. RANDBETWEEN function is an useful tool to generate random numbers.
syntax:
RANDBETWEEN(lower value, upper value)
Consider a scenario...
How to use skip blanks feature in paste special option?!?
There exists a lot of confusion among excel users on usage of "skip blanks" feature in paste special. They expect the skip blanks to filter and paste the non blank cells but, skip blanks retains the original value of the destination cell if the corresponding cell in the source cell is blank.
Let...
How to import file names of a folder into an Excel spreadsheet
Following are the steps to import list of file names from a folder in to an Excel sheet.
1) Select a folder in which the files to be imported are saved. In this case, I've selected AV files folder on my desktop with 4 files in it.
2) Now, hold the Shift key on keyboard and right click on...