[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
In descriptive statistics, there are some measures that can help you assess the spread of the values in your dataset. While the range measures the distance between the lowest and highest values, the interquartile range (IQR) indicates where most of the values lie in your dataset.<\/p>\n
In this guide, you will learn what the interquartile range (IQR) means, what it says about the spread of the majority of your values, and how to find it for odd and even sets of numbers. You will learn how to find the interquartile range manually and using Google Sheets.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”what-is-the-interquartile-range-iqr” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The interquartile range (IQR) refers to the middle 50% of the values in your dataset. Once a dataset has been ordered and divided into four equal quarters, the interquartile range focuses on the middle quartiles – second and third – while ignoring the top and bottom quartiles.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how-to-find-the-interquartile-range” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
To find the interquartile range of your dataset, you must first find the median<\/a> for both the lower and upper half of your data. These correspond to the first (Q1) and third (Q3) quartiles. The interquartile range is found using the following formula:<\/p>\n IQR = Q3 – Q1<\/p>\n<\/blockquote>\n However, keep in mind that there are different methods available depending on whether you include the median value when finding Q1 and Q3: inclusive and exclusive.<\/p>\n For the sake of clarity, all the odd-numbered examples below use the inclusive method, as this is also the method used to calculate quartiles in Google Sheets.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-calculate-the-interquartile-range” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Below, you have step-by-step instructions on how to find the interquartile range manually. First, for an odd set of numbers, then an even one.<\/p>\n Follow the instructions below to find the interquartile range of an odd set of numbers: 1,10,3,13,5,8,14.<\/p>\n 1.<\/strong> Order your values in ascending order.<\/p>\n Ordered set: 1,3,5,8,10,13,14<\/p>\n 2.<\/strong> The median or middle value in your set should have the same number of values above and below it. For this set, the median is 8.<\/p>\n 1,3,5,(8)<\/strong>,10,13,14<\/p>\n 3.<\/strong> Now that you have the two halves of your dataset, you need to find Q1 and Q3. When using the inclusive method, you must include the median in both halves.<\/p>\n Lower half: 1,3,5,8<\/strong><\/p>\n Q1 = (3+5)\/2 = 4<\/p>\n Upper half: 8<\/strong>,10,13,14<\/p>\n Q3 = (10+13)\/2 = 11.5<\/p>\n 4.<\/strong> To get the interquartile range, subtract the value for Q1 from Q3. The IQR for this set is 7.5.<\/p>\n IQR = Q3 – Q1 = 11.5 – 4 = 7.5<\/p>\n In the previous example, finding the median is very straightforward since there is an odd number of values in the set. However, what happens when it\u2019s an even set? Follow the steps below to find the interquartile range of an even set of numbers: 1,16,3,13,8,10,14,5<\/p>\n 1.<\/strong> As before, order your values in ascending order.<\/p>\n Ordered set: 1,3,5,8,10,13,14,16<\/p>\n 2.<\/strong> Since the set has an even number of values, there are two middle values instead of one. To find the median, take the mean of these two middle values: 8 and 10.<\/p>\n 1,3,5,8,10<\/strong>,13,14,16<\/p>\n Median = (8+10)\/2 = 9<\/p>\n 3.<\/strong> However, you can split the values into the lower and upper halves without calculating the median since you need the values for the median of each half. To get Q1 and Q3, find the median for the lower and upper halves.<\/p>\n Lower half: 1,3,5<\/strong>,8<\/p>\n Q1 = (3+5)\/2 = 4<\/p>\n Upper half: 10,13,14<\/strong>,16<\/p>\n Q3 = (13+14)\/2 = 13.5<\/p>\n 4.<\/strong> Calculate the IQR by subtracting Q1 from Q3.<\/p>\n IQR = 13.5 – 4 = 9.5<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-find-iqr-in-google-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that you know how to find the interquartile range, let’s see how much quicker it is to do it in Google Sheets. For comparability, let\u2019s use the same sets as in the examples worked out manually. There are two Google Sheets functions you can use to find Q1 and Q3: QUARTILE and MEDIAN.<\/p>\n This first example uses the QUARTILE function, which uses the inclusive method to calculate the quartiles. Quartile 1 matches the 25th percentile and quartile 3 the 75th, so the PERCENTILE formula in Google Sheets<\/a> gives the same results with 0.25 and 0.75.<\/p>\n 1.<\/strong> Open Google Sheets to the spreadsheet containing your ordered dataset. QUARTILE works on unsorted data too, but an ordered list makes the results easier to check. The SORT formula<\/a> can put your values in order.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-find-iqr-google-sheets-odd-set-of-values.webp” alt=”How to find IQR in Google Sheets \u2014 odd set of values 1 to 14 selected in cells A2:A8″ title_text=”Odd set of values 1 to 14 selected in cells A2:A8″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> In an empty cell, type in the QUARTILE function.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/quartile-function-google-sheets-q1.webp” alt=”QUARTILE function in Google Sheets \u2014 =QUARTILE( typed in D2 next to the Q1 label, with the formula help box open” title_text=”=QUARTILE( typed in D2 next to the Q1 label, with the formula help box open” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> For the first parameter, select the cells containing the values.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/quartile-google-sheets-select-values.webp” alt=”QUARTILE in Google Sheets \u2014 =QUARTILE(A2:A8 with the odd set of values highlighted” title_text=”=QUARTILE(A2:A8 with the odd set of values highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> The second parameter specifies the number of the quartile you want to find. In this case, you want Q1, so type \u201c1\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/find-q1-google-sheets-quartile.webp” alt=”Find Q1 in Google Sheets \u2014 =QUARTILE(A2:A8,1) in cell D2″ title_text=”=QUARTILE(A2:A8,1) in cell D2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> In another empty cell, type the QUARTILE function and select the values. This time, use \u201c3\u201d as the second parameter to get Q3.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/find-q3-google-sheets-quartile.webp” alt=”Find Q3 in Google Sheets \u2014 =QUARTILE(A2:A8,3) in cell D3, with Q1 showing 4″ title_text=”=QUARTILE(A2:A8,3) in cell D3, with Q1 showing 4″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 6.<\/strong> To get the IQR, subtract Q1 from Q3. The IQR for this set is 7.5.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/iqr-google-sheets-odd-set-result.webp” alt=”IQR in Google Sheets \u2014 =D3-D2 returns an IQR of 7.5 for the odd set” title_text=”=D3-D2 returns an IQR of 7.5 for the odd set” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This second example uses the MEDIAN function, which is closer to the manual method. Remember that the results will vary depending on the method used.<\/p>\n 1.<\/strong> Open Google Sheets to the sheet with the even set of values.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/iqr-google-sheets-even-set-of-values.webp” alt=”IQR in Google Sheets \u2014 even set of values 1 to 16 in column F next to the odd set results” title_text=”Even set of values 1 to 16 in column F next to the odd set results” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> In an empty cell, type in the MEDIAN function and select the lower half of your values to get Q1. Press ‘Enter’ to get the result.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/iqr-google-sheets-median-lower-half-q1.webp” alt=”IQR in Google Sheets \u2014 =MEDIAN(F2:F5) on the lower half of the even set for Q1″ title_text=”=MEDIAN(F2:F5) on the lower half of the even set for Q1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> In another empty cell, type in the MEDIAN function again, but this time, select the upper half of your values to get Q3.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/iqr-google-sheets-median-upper-half-q3.webp” alt=”IQR in Google Sheets \u2014 =MEDIAN(F6:F9) on the upper half of the even set for Q3, with Q1 showing 4″ title_text=”=MEDIAN(F6:F9) on the upper half of the even set for Q3, with Q1 showing 4″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> To get the IQR, subtract Q1 from Q3. The IQR for this set is 9.5.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/iqr-google-sheets-even-set-result.webp” alt=”IQR in Google Sheets \u2014 =I3-I2 returns an IQR of 9.5 for the even set” title_text=”=I3-I2 returns an IQR of 9.5 for the even set” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”is-a-higher-interquartile-range-good” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The interquartile range (IQR) measures the spread of the middle half of your dataset. For this reason, the higher the IQR value, the more spread out the values in the middle half of your dataset. This allows you to assess the variability within the bulk of your dataset. Whether you consider the values to be good or bad will depend on the circumstances and the purpose of your analysis.<\/p>\n Because the IQR leaves out the top and bottom quarters of your data, a few extreme values won’t change it much. To measure how far every value sits from the mean, use the STDEV formula in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you have seen, the interquartile range is a useful measure. Unlike the range, which illustrates the spread of your entire dataset, the interquartile range shows the spread of the middle half of your dataset. The IQR allows you to assess how much variability is present in the bulk of your dataset.<\/p>\n You now know what the interquartile range is and what it can tell you about the variability in the middle half of your dataset. In addition to knowing how to do this manually for even and odd sets of numbers, you also know how to find the interquartile range using two different functions in Google Sheets: QUARTILE and MEDIAN.<\/p>\n For the range of the whole dataset, use the MAX formula in Google Sheets<\/a> to find the highest value and the MIN formula<\/a> to find the lowest, then subtract one from the other.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Apprenez \u00e0 calculer l'\u00e9cart interquartile dans Google Sheets avec les fonctions QUARTILE et MEDIAN, et \u00e0 le faire \u00e0 la main pour des s\u00e9ries paires et impaires.<\/p>","protected":false},"author":2,"featured_media":264904,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-264893","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/264893","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=264893"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/264893\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/264904"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=264893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=264893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=264893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
\n
How to calculate the interquartile range manually?<\/h2>\n
The interquartile range for an odd set of numbers<\/h3>\n
The interquartile range for an even set of numbers<\/h3>\n
How to find IQR in Google Sheets?<\/h2>\n
How to find quartiles in Google Sheets with QUARTILE<\/h3>\n
How to find quartiles in Google Sheets with MEDIAN<\/h3>\n
Is a higher interquartile range good?<\/h2>\n
Conclusion<\/h2>\n