Formulas and Functions
ഈ കൺട്രോളിൽ മാറ്റം വരുത്തുന്നത് ഈ പേജ് ഒട്ടോമാറ്റിക്കായി അപ്ഡേറ്റ് ചെയ്യാനിടയാക്കും

PERCENTILE

The PERCENTILE function returns the value within a set of numeric values that corresponds to a particular percentile.

PERCENTILE(value-set, percentile-value)

value-set: A collection that must contain number values, date/time values or duration values. All values must be of the same value type.

percentile-value: A number value representing the percentile value you want to find. percentile-value is either entered as a decimal (for example, 0.25) or as a percentage (for example, 25%). It must be greater than or equal to 0 and less than or equal to 1.

Notes

  • Values included in the collection that are the same are ranked together, but impact the outcome.

Examples

Suppose the following table contains the cumulative test scores for this term for your 20 students. (The data is organised this way for the example; it would probably originally have been in 20 separate rows.)

A

B

C

D

E

1

30

75

92

86

51

2

83

100

92

68

70

3

77

91

86

85

83

4

77

90

83

75

80

=PERCENTILE(A1:E4, 0.90) returns 92, the minimum cumulative test score to be in the top 10% of the class (90th percentile).

=PERCENTILE(A1:E4, 3/4) returns 87, the minimum cumulative test score to be in the top quarter of the class (75th percentile).

=PERCENTILE(A1:E4, 0.50) returns 83, the minimum cumulative test score to be in the top half of the class (50th percentile).

See alsoFREQUENCYPERCENTRANKQUARTILE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
സഹായകമായോ?
കാരക്റ്റർ പരിധി: 250
പരമാവധി കാരക്റ്റർ പരിധി 250 ആണ്.
നിങ്ങളുടെ ഫീഡ്ബാക്കിന് നന്ദി.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.