LARGE function - The function returns the kth largest value in a dataset in Excel

QUARTILE function - The function returns the quartile of a dataset in Excel
QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel

The following article introduces you to the LARGE function - one of the functions in the statistical function group is very popular in Excel.

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 1

Description: The function returns the kth value in the dataset. Use the function to determine the position of the value in a dataset.

Syntax: LARGE (array, k)

Inside:

- array : Array or range of data containing the kth largest value in it.

- k: What is the largest position (the largest ad is 1) in the array to return.

Attention:

- If the argument in the array is a blank -> the function returns the #NUM! Error value .

- If k ≤ 0 or k is greater than the number of data points in the array -> the function returns the #NUM! Error value

- If n is the number of data points of the array, then:

+ LARGE (array, 1) -> returns the largest value in the array array.

+ LARGE (array, n) -> returns the smallest value in the array array.

For example:

Find the kth largest value as described in the data table below:

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 2

1. Calculate the 3rd and smallest largest values in array1

- Calculate the 3rd largest value in array1. In a cell to calculate enter the formula : = LARGE (C6: C10,3)

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 3

- Press Enter -> the 3rd largest value in array1 is:

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 4

- Calculate the smallest value in array1. Using the LARGE up the smallest value in the array is the largest value in the array n where n is the total number of elements in the array -> enter the formula: = LARGE (C6: C10,5) ( array array1 5 parts death) -> press Enter -> minimum values are:

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 5

2. Calculate the 2nd and 3rd largest values in array2.

- Because array2 has 2 equal elements of 6. Two equal values but the function still ranks them in 2 different positions:

- Calculate the second largest value in the array -> enter the formula: = LARGE (D6: D10,2)

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 6

- Press Enter -> the second largest value is:

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 7

- 3rd largest value in the array -> enter the formula: = LARGE (D6: D10,3) -> press Enter -> 3rd largest value is:

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 8

Thus the 2nd and 3rd largest values in the same array are 6.

Above are instructions and some specific examples when using the LARGE function in Excel.

Good luck!

Micah Soto

Update 19 May 2020

You should read it

May be interested

HARMEAN function - The function returns the harmonic average of a data set in Excel
harmean function: the function returns the harmonic mean of a dataset, the harmonic mean is the reciprocal of the arithmetic mean of the reciprocals. syntax: harmean (number1, [number2], ...)
AVEDEV function - The function returns the average absolute deviation of data points from their midpoint in Excel
avedev function: the function returns the average absolute deviation between a given data point and the average value of the population. the function is a measure of the variability of a dataset
How to use MAXIFS function in Excel 2016
maxifs function in excel is a statistical function that returns the largest value based on one or more conditions from the specified cells. maxifs function was introduced in ms excel 2016.
How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
the normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
CHISQ.TEST function - The function returns the independence test in Excel
chisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
How to use the IF function in Excel
the if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
MAXA function - The function returns the largest value in a set of values including text and logical values in Excel
maxa function: the function returns the largest value in a set of values including text and logical values. syntax: maxa (value1, [value2], ...)
F.TEST function - The function returns the result of the F - test in Excel
f.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
GAMMA function - The function returns the gamma function value in Excel
gamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
POISSON.DIST function - The function returns the Poisson distribution in Excel
poisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)

LARGE function - The function returns the kth largest value in a dataset in Excel

You should read it

May be interested

Office information