STATISTICAL FUNCTIONS
STATISTICAL FUNCTIONS
STATISTICAL group of functions contain very important and widely used functions in Excel.
This group contains a vast list of ready to use functions to find out the statistical values such as FREQUENCY, AVERAGE, COUNT, COUNTA and many more.
Here is the list of functions which fall under this category. Click the function for its further details i.e. formula syntax, examples, purpose etc.
STATISTICAL FUNCTIONS
HOW TO USE COUNTBLANK FUNCTION IN EXCEL?
Table of Contents INTRODUCTION PURPOSE OF COUNTBLANK FUNCTION IN EXCEL PREREQUISITES TO LEARN COUNTBLANK FUNCTION WHAT IS THE SYNTAX OF …
HOW TO DO STANDARD DEVIATION IN EXCEL?
Table of Contents INTRODUCTION WHAT IS THE STANDARD DEVIATION? WHAT IS THE FORMULA FOR STANDARD DEVIATION? WHAT IS EXCEL FORMULA …
HOW TO USE PERCENTRANK FUNCTION IN EXCEL ?
Table of Contents INTRODUCTION WHAT IS A PERCENTILE ? WHAT IS PERCENTRANK? HOW TO CALCULATE THE PERCENTRANK MANUALLY? WHY DO …
HOW TO CALCULATE PERCENTILE IN EXCEL?
Table of Contents INTRODUCTION WHAT IS A PERCENTILE ? WHY DO WE NEED TO CALCULATE THE PERCENTILE ? HOW TO …
EXCEL FUNCTIONS- MODE.SNGL
Table of Contents INTRODUCTION PURPOSE OF MODE.SNGL FUNCTION IN EXCEL PREREQUISITES TO LEARN MODE.SNGL FUNCTION SYNTAX: MODE.SNGL FUNCTION EXAMPLE 1: …
EXCEL FUNCTIONS- MODE.MULT
INTRODUCTION EXCEL is the spreadsheet application offered by MICROSOFT which is one of the best spreadsheet application. One of the …
EXCEL FUNCTIONS- MODE
INTRODUCTION EXCEL is the spreadsheet application offered by MICROSOFT which is one of the best spreadsheet application. One of the …
EXCEL FUNCTION-RANK
Table of Contents INTRODUCTION PURPOSE OF RANK FUNCTION IN EXCEL PREREQUISITES TO LEARN RANK FUNCTION SYNTAX: RANK FUNCTION EXAMPLES:RANK FUNCTION …
EXCEL FUNCTIONS-FREQUENCY
INTRODUCTION So you must have heard this word FREQUENCY , may be not in context of EXCEL but of the …
EXCEL FUNCTIONS-COUNTIFS
INTRODUCTION COUNTIFS FUNCTION comes under the STATISTICAL FUNCTIONS category in Excel. It is an extension to the COUNTIF FUNCTION. As …
How to use COUNTIF function in Excel?
Table of Contents INTRODUCTION What is the use of COUNTIF FUNCTION in Excel? PREREQUISITES TO LEARN COUNTIF FUNCTION What is …
How to use COUNTA Function in Excel?
Table of Contents INTRODUCTION What is the use of Counta Function in Excel ? 1. Counting Entries in a List …
HOW TO USE COUNT FUNCTION IN EXCEL ?
Table of Contents INTRODUCTION WHAT IS THE USE OF COUNT FUNCTION IN EXCEL? PREREQUISITES TO LEARN COUNT FUNCTION WHAT IS …
EXCEL FUNCTIONS-AVERAGEIFS
INTRODUCTION AVERAGEIFS FUNCTIONS comes under the STATISTICAL FUNCTION group of Excel. If we remember the SUMIFS function, AVERAGEIFS function is …
EXCEL FUNCTIONS-AVERAGEIF
Table of Contents INTRODUCTION PURPOSE OF AVERAGEIF FUNCTION IN EXCEL PREREQUISITES TO LEARN AVERAGEIF SYNTAX: AVERAGEIF FUNCTION EXAMPLE 1:AVERAGEIF FUNCTION …
EXCEL FUNCTIONS-AVEDEV
INTRODUCTION AVEDEV FUNCTION comes under the STATISTICAL FUNCTIONS category in Excel. AVEDEV or AVERAGE DEVIATION function , as the name …