Published April 17, 2025Updated November 5, 202610 min read

Interquartile Range in Transfer Pricing: Calculation & Examples

Calculate the interquartile range in transfer pricing with a worked example and Excel formulas. Compare the U.S. rank method, Excel INC/EXC and local rules.

  • BorysCEO of ArmsLength AI
Interquartile Range in Transfer Pricing: Calculation & Examples
Contents

TL;DR key takeaways

  • The quartile interval runs from Q1 to Q3. Its statistical width is Q3 minus Q1; these are different outputs.
  • The U.S. regulatory rank method is not the same as Excel PERCENTILE.INC or PERCENTILE.EXC.
  • For comparable prices of 42, 44, 45 and 47.5, the U.S. quartile interval is 43 to 46.25 and its width is 3.25.
  • First establish comparability and the applicable local rule. Statistical trimming does not make unsuitable comparables reliable.
  • Record the dataset, percentile algorithm and tax year so another reviewer can reproduce the result.

Sources

  1. 01U.S. Treasury Regulations §1.482-1(e): range, quartiles and Example 3
  2. 02OECD Transfer Pricing Guidelines 2022, paragraphs 3.55–3.63
  3. 03Microsoft: PERCENTILE.INC
  4. 04Microsoft: PERCENTILE.EXC
  5. 05India: Income-tax Rules 2026, Rule 81, Notification 22/2026
  6. 06India: Income Tax Department explanation of Rule 10CA
  7. 07Ukraine: State Tax Service explanation of Resolution 381 and Article 39
  8. 08Australia: OECD country profile, October 2025, question 10
  9. 09Germany: Außensteuergesetz §1(3a)
  10. 10Canada: Income Tax Act, section 247
  11. 11Canada Revenue Agency: TPM-16
  12. 12Malaysia Transfer Pricing Guidelines 2024, chapter 2

Related articles

Benchmarking12 min read

The Berry Ratio in Transfer Pricing: Complete Guide with Examples

The Berry Ratio (gross profit ÷ operating expenses) is a specialized PLI for low-risk distributors and agents. Learn when it's appropriate, when to avoid it, and how to defend your analysis—with calculation examples and jurisdictional guidance.

More resources for your next workflow step

Browse the full resource library or contact us if you want recommendations for your specific use case.