{"id":14983,"date":"2023-02-27T17:25:49","date_gmt":"2023-02-27T17:25:49","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=14983"},"modified":"2024-02-19T14:52:15","modified_gmt":"2024-02-19T14:52:15","slug":"calculate-percentile-rank","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/","title":{"rendered":"Calculate Percentile Rank in Excel"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-ab49f583-bd94-42e1-b7d7-1390b6a24201\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/Calculate-Percentile-Rank-in-Excel.xlsx\">Calculate-Percentile-Rank-in-Excel<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/Calculate-Percentile-Rank-in-Excel.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-ab49f583-bd94-42e1-b7d7-1390b6a24201\">Download File<\/a><\/div>\n\n\n\n<p>You might have heard about the statistical measure called <strong>percentile<\/strong> and its related term <strong>percentile rank<\/strong>. These two measures are used in reporting in various cases.<\/p>\n\n\n\n<p>A percentile rank is a measure that shows the relation between a certain score comparing with the scores of the group.<\/p>\n\n\n\n<p>For example, if a certain basketball player averages 25 points, and is ranked in the 90th percentile, this means that his average is higher than that of 90 percent of the rest of the players.<\/p>\n\n\n\n<p>In the example below, we will show how to calculate the <strong>percentile rank in Excel<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Calculate Percentile Rank in Excel<\/h2>\n\n\n\n<p>For our example, we will use the list of <strong>NBA players and their points averages<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"347\" height=\"299\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png\" alt=\"\" class=\"wp-image-14984\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png 347w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1-300x259.png 300w\" sizes=\"(max-width: 347px) 100vw, 347px\" \/><\/figure>\n\n\n\n<p>To calculate the <strong>percentile rank<\/strong>, we will use a very intuitive formula- <strong>PERCENTRANK<\/strong>. The formula that we can use can be either <strong>PERCENTRANK.INC<\/strong> (<strong>include the first and last value<\/strong>) or <strong>PERCENTRANK.EXC<\/strong> <strong>(excluding the first and last value, which means we will not have a 0% or 100% values).<\/strong><\/p>\n\n\n\n<p>We will use the <strong>PERCENTRANK.EXC<\/strong> formula which has three parameters:<\/p>\n\n\n\n<ul>\n<li><strong>Array-<\/strong> the range that we want to inspect<\/li>\n\n\n\n<li><strong>x-<\/strong> the value out of which we want to get the percentile from<\/li>\n\n\n\n<li><strong>Significance-<\/strong> not a mandatory field. The value that tells the number of digits that are important to be returned as a percentage value. If we do not choose to insert it, it uses three digits.<\/li>\n<\/ul>\n\n\n\n<p>Having all of this in mind, this is the formula that we will insert in <strong>cell C2<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=PERCENTRANK.EXC($B$2:$B$11,B2)<\/code><\/pre>\n\n\n\n<p>Numbers in our array <strong>will be locked<\/strong>, to allow us to <strong>auto-fill<\/strong> the data till the end of the table, and <strong>value x<\/strong> will be changed as we drag the data. These are our results:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"603\" height=\"347\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-2.png\" alt=\"\" class=\"wp-image-14985\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-2.png 603w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-2-300x173.png 300w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/figure>\n\n\n\n<p>In our case, Damian Lillard has a <strong>percentile rank of 82 percent<\/strong> (for example), meaning that only <strong>18 percent<\/strong> of players in the data set have a higher points average.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You might have heard about the statistical measure called percentile and its related term percentile rank. These two measures are used in reporting&#8230;<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Calculate Percentile Rank in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to calculate percentile rank in Excel, with step-by-step instructions and examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculate Percentile Rank in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to calculate percentile rank in Excel, with step-by-step instructions and examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-27T17:25:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:52:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Calculate Percentile Rank in Excel\",\"datePublished\":\"2023-02-27T17:25:49+00:00\",\"dateModified\":\"2024-02-19T14:52:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/\"},\"wordCount\":318,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png\",\"keywords\":[\"file\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/\",\"name\":\"Calculate Percentile Rank in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png\",\"datePublished\":\"2023-02-27T17:25:49+00:00\",\"dateModified\":\"2024-02-19T14:52:15+00:00\",\"description\":\"Learn how to calculate percentile rank in Excel, with step-by-step instructions and examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png\",\"width\":347,\"height\":299},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calculate Percentile Rank in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calculate Percentile Rank in Excel","description":"Learn how to calculate percentile rank in Excel, with step-by-step instructions and examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/","og_locale":"en_US","og_type":"article","og_title":"Calculate Percentile Rank in Excel","og_description":"Learn how to calculate percentile rank in Excel, with step-by-step instructions and examples.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/","article_published_time":"2023-02-27T17:25:49+00:00","article_modified_time":"2024-02-19T14:52:15+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Calculate Percentile Rank in Excel","datePublished":"2023-02-27T17:25:49+00:00","dateModified":"2024-02-19T14:52:15+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/"},"wordCount":318,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png","keywords":["file"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/","url":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/","name":"Calculate Percentile Rank in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png","datePublished":"2023-02-27T17:25:49+00:00","dateModified":"2024-02-19T14:52:15+00:00","description":"Learn how to calculate percentile rank in Excel, with step-by-step instructions and examples.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14983-1.png","width":347,"height":299},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-percentile-rank\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Calculate Percentile Rank in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/14983"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=14983"}],"version-history":[{"count":2,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/14983\/revisions"}],"predecessor-version":[{"id":15543,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/14983\/revisions\/15543"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=14983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=14983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=14983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}