How do I find percentiles of data sets (Even vs odd)?

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
3
down vote

favorite
2












Given the following data set with an even number of values:

$100, 100, 105, 113, 129, 132, 146, 152, 176, 200$



The value representing the 30th percentile, using the formula n(p/100) where n = sample size and p = percentile, is at position 10(0.30) = 3. So the 30th percentile of this data is 105.



Given the following data set with an odd number of values:

$100, 100, 105, 113, 129, 132, 146, 152, 176, 200, 300$



The value representing the 30th percentile, using the formula n(p/100) where n = sample size and p = percentile, is at position 11(0.30) = 3.3. So now what does one do?



I realize that this formula can yield a decimal even if the data set has an even amount of values, say if n = 36, and you want the 10th percentile, 36(.10) = 3.6.



In this situation, do you average the 3rd and 4th values? Or is it the 3rd value? or the 4th value? How do you decide? What if the position was 3.2 or 3.7? Does it matter in choosing which value is represents the given percentile?



Thanks for any help ahead of time.




statistics median percentile




share|cite|improve this question


















  • 1




    According to wikipedia article on percentiles, you use the ceiling. But this conflicts with the article on median which it says is the same as the 50th percentile and calculates it as an interpolation. So it is either an interpolation: 105+0.3(113-105), or it is the "next biggest": 113.
    – David Peterson
    Dec 17 '14 at 5:52










  • Wikipedia's Quantile article gives nine different calculation methods. Personally I like R-2 for a population and R-7 for a sample
    – Henry
    Feb 19 '17 at 20:31











  • I would expect that this very much depends on what you need to do with percentiles; although I can't think of an example, I expect if it isn't entirely clear how to resolve this based on what you're doing with the percentiles, then it probably doesn't make a whole lot of difference.
    – Vedvart1
    Jun 8 '17 at 5:40










  • From a script on probability and statistics (by L. Meier, ETHZ): For an empirical quantile $q_alpha (0<alpha<1)$ for an ordered data set: $q_alpha = frac12(x_nalpha+x_nalpha+1)$ if $alphacdot n$ is even, else $q_alpha = x_ceilalphacdot n $. Here $n$ is the number of entries in the data set.
    – Nox
    Dec 21 '17 at 14:49















up vote
3
down vote

favorite
2












Given the following data set with an even number of values:

$100, 100, 105, 113, 129, 132, 146, 152, 176, 200$



The value representing the 30th percentile, using the formula n(p/100) where n = sample size and p = percentile, is at position 10(0.30) = 3. So the 30th percentile of this data is 105.



Given the following data set with an odd number of values:

$100, 100, 105, 113, 129, 132, 146, 152, 176, 200, 300$



The value representing the 30th percentile, using the formula n(p/100) where n = sample size and p = percentile, is at position 11(0.30) = 3.3. So now what does one do?



I realize that this formula can yield a decimal even if the data set has an even amount of values, say if n = 36, and you want the 10th percentile, 36(.10) = 3.6.



In this situation, do you average the 3rd and 4th values? Or is it the 3rd value? or the 4th value? How do you decide? What if the position was 3.2 or 3.7? Does it matter in choosing which value is represents the given percentile?



Thanks for any help ahead of time.




statistics median percentile




share|cite|improve this question


















  • 1




    According to wikipedia article on percentiles, you use the ceiling. But this conflicts with the article on median which it says is the same as the 50th percentile and calculates it as an interpolation. So it is either an interpolation: 105+0.3(113-105), or it is the "next biggest": 113.
    – David Peterson
    Dec 17 '14 at 5:52










  • Wikipedia's Quantile article gives nine different calculation methods. Personally I like R-2 for a population and R-7 for a sample
    – Henry
    Feb 19 '17 at 20:31











  • I would expect that this very much depends on what you need to do with percentiles; although I can't think of an example, I expect if it isn't entirely clear how to resolve this based on what you're doing with the percentiles, then it probably doesn't make a whole lot of difference.
    – Vedvart1
    Jun 8 '17 at 5:40










  • From a script on probability and statistics (by L. Meier, ETHZ): For an empirical quantile $q_alpha (0<alpha<1)$ for an ordered data set: $q_alpha = frac12(x_nalpha+x_nalpha+1)$ if $alphacdot n$ is even, else $q_alpha = x_ceilalphacdot n $. Here $n$ is the number of entries in the data set.
    – Nox
    Dec 21 '17 at 14:49













up vote
3
down vote

favorite
2









up vote
3
down vote

favorite
2






2





Given the following data set with an even number of values:

$100, 100, 105, 113, 129, 132, 146, 152, 176, 200$



The value representing the 30th percentile, using the formula n(p/100) where n = sample size and p = percentile, is at position 10(0.30) = 3. So the 30th percentile of this data is 105.



Given the following data set with an odd number of values:

$100, 100, 105, 113, 129, 132, 146, 152, 176, 200, 300$



The value representing the 30th percentile, using the formula n(p/100) where n = sample size and p = percentile, is at position 11(0.30) = 3.3. So now what does one do?



I realize that this formula can yield a decimal even if the data set has an even amount of values, say if n = 36, and you want the 10th percentile, 36(.10) = 3.6.



In this situation, do you average the 3rd and 4th values? Or is it the 3rd value? or the 4th value? How do you decide? What if the position was 3.2 or 3.7? Does it matter in choosing which value is represents the given percentile?



Thanks for any help ahead of time.




statistics median percentile




share|cite|improve this question














Given the following data set with an even number of values:

$100, 100, 105, 113, 129, 132, 146, 152, 176, 200$



The value representing the 30th percentile, using the formula n(p/100) where n = sample size and p = percentile, is at position 10(0.30) = 3. So the 30th percentile of this data is 105.



Given the following data set with an odd number of values:

$100, 100, 105, 113, 129, 132, 146, 152, 176, 200, 300$



The value representing the 30th percentile, using the formula n(p/100) where n = sample size and p = percentile, is at position 11(0.30) = 3.3. So now what does one do?



I realize that this formula can yield a decimal even if the data set has an even amount of values, say if n = 36, and you want the 10th percentile, 36(.10) = 3.6.



In this situation, do you average the 3rd and 4th values? Or is it the 3rd value? or the 4th value? How do you decide? What if the position was 3.2 or 3.7? Does it matter in choosing which value is represents the given percentile?



Thanks for any help ahead of time.





statistics median percentile





share|cite|improve this question













share|cite|improve this question




share|cite|improve this question








edited Dec 17 '14 at 5:42

























asked Dec 17 '14 at 5:23









Riptyde4

2242413




2242413







  • 1




    According to wikipedia article on percentiles, you use the ceiling. But this conflicts with the article on median which it says is the same as the 50th percentile and calculates it as an interpolation. So it is either an interpolation: 105+0.3(113-105), or it is the "next biggest": 113.
    – David Peterson
    Dec 17 '14 at 5:52










  • Wikipedia's Quantile article gives nine different calculation methods. Personally I like R-2 for a population and R-7 for a sample
    – Henry
    Feb 19 '17 at 20:31











  • I would expect that this very much depends on what you need to do with percentiles; although I can't think of an example, I expect if it isn't entirely clear how to resolve this based on what you're doing with the percentiles, then it probably doesn't make a whole lot of difference.
    – Vedvart1
    Jun 8 '17 at 5:40










  • From a script on probability and statistics (by L. Meier, ETHZ): For an empirical quantile $q_alpha (0<alpha<1)$ for an ordered data set: $q_alpha = frac12(x_nalpha+x_nalpha+1)$ if $alphacdot n$ is even, else $q_alpha = x_ceilalphacdot n $. Here $n$ is the number of entries in the data set.
    – Nox
    Dec 21 '17 at 14:49













  • 1




    According to wikipedia article on percentiles, you use the ceiling. But this conflicts with the article on median which it says is the same as the 50th percentile and calculates it as an interpolation. So it is either an interpolation: 105+0.3(113-105), or it is the "next biggest": 113.
    – David Peterson
    Dec 17 '14 at 5:52










  • Wikipedia's Quantile article gives nine different calculation methods. Personally I like R-2 for a population and R-7 for a sample
    – Henry
    Feb 19 '17 at 20:31











  • I would expect that this very much depends on what you need to do with percentiles; although I can't think of an example, I expect if it isn't entirely clear how to resolve this based on what you're doing with the percentiles, then it probably doesn't make a whole lot of difference.
    – Vedvart1
    Jun 8 '17 at 5:40










  • From a script on probability and statistics (by L. Meier, ETHZ): For an empirical quantile $q_alpha (0<alpha<1)$ for an ordered data set: $q_alpha = frac12(x_nalpha+x_nalpha+1)$ if $alphacdot n$ is even, else $q_alpha = x_ceilalphacdot n $. Here $n$ is the number of entries in the data set.
    – Nox
    Dec 21 '17 at 14:49








1




1




According to wikipedia article on percentiles, you use the ceiling. But this conflicts with the article on median which it says is the same as the 50th percentile and calculates it as an interpolation. So it is either an interpolation: 105+0.3(113-105), or it is the "next biggest": 113.
– David Peterson
Dec 17 '14 at 5:52




According to wikipedia article on percentiles, you use the ceiling. But this conflicts with the article on median which it says is the same as the 50th percentile and calculates it as an interpolation. So it is either an interpolation: 105+0.3(113-105), or it is the "next biggest": 113.
– David Peterson
Dec 17 '14 at 5:52












Wikipedia's Quantile article gives nine different calculation methods. Personally I like R-2 for a population and R-7 for a sample
– Henry
Feb 19 '17 at 20:31





Wikipedia's Quantile article gives nine different calculation methods. Personally I like R-2 for a population and R-7 for a sample
– Henry
Feb 19 '17 at 20:31













I would expect that this very much depends on what you need to do with percentiles; although I can't think of an example, I expect if it isn't entirely clear how to resolve this based on what you're doing with the percentiles, then it probably doesn't make a whole lot of difference.
– Vedvart1
Jun 8 '17 at 5:40




I would expect that this very much depends on what you need to do with percentiles; although I can't think of an example, I expect if it isn't entirely clear how to resolve this based on what you're doing with the percentiles, then it probably doesn't make a whole lot of difference.
– Vedvart1
Jun 8 '17 at 5:40












From a script on probability and statistics (by L. Meier, ETHZ): For an empirical quantile $q_alpha (0<alpha<1)$ for an ordered data set: $q_alpha = frac12(x_nalpha+x_nalpha+1)$ if $alphacdot n$ is even, else $q_alpha = x_ceilalphacdot n $. Here $n$ is the number of entries in the data set.
– Nox
Dec 21 '17 at 14:49





From a script on probability and statistics (by L. Meier, ETHZ): For an empirical quantile $q_alpha (0<alpha<1)$ for an ordered data set: $q_alpha = frac12(x_nalpha+x_nalpha+1)$ if $alphacdot n$ is even, else $q_alpha = x_ceilalphacdot n $. Here $n$ is the number of entries in the data set.
– Nox
Dec 21 '17 at 14:49











1 Answer
1






active

oldest

votes

















up vote
0
down vote













  1. Order all the numbers in the data set from smallest to largest.

  2. Multiply percent times the total number of numbers, n.
    3a. If your result from Step 2 is a whole number, go to Step 4. If the result from Step 2 is not a whole number, round it up to the nearest whole number and go to Step 3b.
    3b. Count the numbers in your data set from left to right (from the smallest to the largest number) until you reach the value from Step 3a. This corresponding number in your data set is the kth percentile.

    4. Count the numbers in your data set from left to right until you reach that whole number. The kth percentile is the average of that corresponding number in your data set and the next number in your data set.



Given the following data set with an even number of values:



100,100,105,113,129,132,146,152,176,200-you correctly caculated 3 which is a whole number. Step 4 says to count from left to right until you reach the third number which is 105. Additionally step 4 says to average 105 and the next number in the set which is 113. You get 109. Therefore the 30th percentile of this data is 109.



Now for the set 100,100,105,113,129,132,146,152,176,200,300 you correctly figured 3.3 so according to step 3a round 3.3 up to 4 and go to step 3b. Step 3b says to count from left to right until you get to the 4th number which is 113. 113 is the 30th percentile in this case.






share|cite|improve this answer




















    Your Answer




    StackExchange.ifUsing("editor", function ()
    return StackExchange.using("mathjaxEditing", function ()
    StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix)
    StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
    );
    );
    , "mathjax-editing");

    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "69"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    convertImagesToLinks: true,
    noModals: false,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    noCode: true, onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );








     

    draft saved


    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f1071653%2fhow-do-i-find-percentiles-of-data-sets-even-vs-odd%23new-answer', 'question_page');

    );

    Post as a guest

















    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    0
    down vote













    1. Order all the numbers in the data set from smallest to largest.

    2. Multiply percent times the total number of numbers, n.
      3a. If your result from Step 2 is a whole number, go to Step 4. If the result from Step 2 is not a whole number, round it up to the nearest whole number and go to Step 3b.
      3b. Count the numbers in your data set from left to right (from the smallest to the largest number) until you reach the value from Step 3a. This corresponding number in your data set is the kth percentile.

      4. Count the numbers in your data set from left to right until you reach that whole number. The kth percentile is the average of that corresponding number in your data set and the next number in your data set.



    Given the following data set with an even number of values:



    100,100,105,113,129,132,146,152,176,200-you correctly caculated 3 which is a whole number. Step 4 says to count from left to right until you reach the third number which is 105. Additionally step 4 says to average 105 and the next number in the set which is 113. You get 109. Therefore the 30th percentile of this data is 109.



    Now for the set 100,100,105,113,129,132,146,152,176,200,300 you correctly figured 3.3 so according to step 3a round 3.3 up to 4 and go to step 3b. Step 3b says to count from left to right until you get to the 4th number which is 113. 113 is the 30th percentile in this case.






    share|cite|improve this answer
























      up vote
      0
      down vote













      1. Order all the numbers in the data set from smallest to largest.

      2. Multiply percent times the total number of numbers, n.
        3a. If your result from Step 2 is a whole number, go to Step 4. If the result from Step 2 is not a whole number, round it up to the nearest whole number and go to Step 3b.
        3b. Count the numbers in your data set from left to right (from the smallest to the largest number) until you reach the value from Step 3a. This corresponding number in your data set is the kth percentile.

        4. Count the numbers in your data set from left to right until you reach that whole number. The kth percentile is the average of that corresponding number in your data set and the next number in your data set.



      Given the following data set with an even number of values:



      100,100,105,113,129,132,146,152,176,200-you correctly caculated 3 which is a whole number. Step 4 says to count from left to right until you reach the third number which is 105. Additionally step 4 says to average 105 and the next number in the set which is 113. You get 109. Therefore the 30th percentile of this data is 109.



      Now for the set 100,100,105,113,129,132,146,152,176,200,300 you correctly figured 3.3 so according to step 3a round 3.3 up to 4 and go to step 3b. Step 3b says to count from left to right until you get to the 4th number which is 113. 113 is the 30th percentile in this case.






      share|cite|improve this answer






















        up vote
        0
        down vote










        up vote
        0
        down vote









        1. Order all the numbers in the data set from smallest to largest.

        2. Multiply percent times the total number of numbers, n.
          3a. If your result from Step 2 is a whole number, go to Step 4. If the result from Step 2 is not a whole number, round it up to the nearest whole number and go to Step 3b.
          3b. Count the numbers in your data set from left to right (from the smallest to the largest number) until you reach the value from Step 3a. This corresponding number in your data set is the kth percentile.

          4. Count the numbers in your data set from left to right until you reach that whole number. The kth percentile is the average of that corresponding number in your data set and the next number in your data set.



        Given the following data set with an even number of values:



        100,100,105,113,129,132,146,152,176,200-you correctly caculated 3 which is a whole number. Step 4 says to count from left to right until you reach the third number which is 105. Additionally step 4 says to average 105 and the next number in the set which is 113. You get 109. Therefore the 30th percentile of this data is 109.



        Now for the set 100,100,105,113,129,132,146,152,176,200,300 you correctly figured 3.3 so according to step 3a round 3.3 up to 4 and go to step 3b. Step 3b says to count from left to right until you get to the 4th number which is 113. 113 is the 30th percentile in this case.






        share|cite|improve this answer












        1. Order all the numbers in the data set from smallest to largest.

        2. Multiply percent times the total number of numbers, n.
          3a. If your result from Step 2 is a whole number, go to Step 4. If the result from Step 2 is not a whole number, round it up to the nearest whole number and go to Step 3b.
          3b. Count the numbers in your data set from left to right (from the smallest to the largest number) until you reach the value from Step 3a. This corresponding number in your data set is the kth percentile.

          4. Count the numbers in your data set from left to right until you reach that whole number. The kth percentile is the average of that corresponding number in your data set and the next number in your data set.



        Given the following data set with an even number of values:



        100,100,105,113,129,132,146,152,176,200-you correctly caculated 3 which is a whole number. Step 4 says to count from left to right until you reach the third number which is 105. Additionally step 4 says to average 105 and the next number in the set which is 113. You get 109. Therefore the 30th percentile of this data is 109.



        Now for the set 100,100,105,113,129,132,146,152,176,200,300 you correctly figured 3.3 so according to step 3a round 3.3 up to 4 and go to step 3b. Step 3b says to count from left to right until you get to the 4th number which is 113. 113 is the 30th percentile in this case.







        share|cite|improve this answer












        share|cite|improve this answer



        share|cite|improve this answer










        answered Jun 8 '15 at 23:35









        Hope It Helps

        1




        1






















             

            draft saved


            draft discarded


























             


            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f1071653%2fhow-do-i-find-percentiles-of-data-sets-even-vs-odd%23new-answer', 'question_page');

            );

            Post as a guest
































































            -

            這個網誌中的熱門文章

            How to combine Bézier curves to a surface?

            圖片
            Clash Royale CLAN TAG #URR8PPP up vote 2 down vote favorite My aim is to smooth the terrain in a video game. Therefore I contrived an algorithm that makes use of Bézier curves of different orders. But this algorithm is defined in a two dimensional space for now. To shift it into the third dimension I need to somehow combine the Bézier curves. Given two curves in each two dimensions, how can I combine them to build a surface? I thought about something like a curve of a curve. Or maybe I could multiply them somehow. How can I combine them to cause the wanted behavior? Is there a common approach? In the image you can see the input, on the left, and the output, on the right, of the algorithm that works in a two dimensional space. For the real application there is a three dimensional input. The algorithm relays only on the adjacent tiles. Given these it will define the control points of the mentioned Bézier cur...
            閱讀完整內容

            Propositional logic and tautologies

            圖片
            Clash Royale CLAN TAG #URR8PPP up vote 0 down vote favorite Taken from P. Suppes "Introduction to logic" pp16 Starting from the sentence "If $P$ tautologically implies $Q$, then.." Question: Is it true that, at least within propositional logic, we are able to prove only tautologies or do I mis-understand something? If yes, is propositional logic special in some way? Is the notion of tautology meaningful only in propositional logic? logic propositional-calculus share | cite | improve this question edited Nov 29 '17 at 18:53 Mauro ALLEGRANZA 60.8k 4 46 105 asked Nov 29 '17 at 16:32 Alvin Lepik 2,448 9 20 add a comment  |  up vote 0 down vote favorite Taken from P. Suppes "Introduction to logic" pp16 Starting from the sentence "If $P$ tautologically implies $Q$, then.." Question: Is it true that, at least within propositional logic, we are able to prove only tautologi...
            閱讀完整內容

            Distribution of Stopped Wiener Process with Stochastic Volatility

            圖片
            Clash Royale CLAN TAG #URR8PPP up vote 0 down vote favorite Let $(W_s)_s geq 0$ be a Wiener process and $tau$ be a random variable with an exponential distribution with parameter $lambda$. Suppose that $W$ and $tau$ are independent. In this question, we see that the distribution of the stopped Wiener process $W_tau$ corresponds to a Laplace distribution with scale parameter $fracsigmasqrt2lambda$ where $sigma$ is the instantaneous variance of the Wiener process. Suppose now, that the variance $sigma^2$ also follows a stochastic process such that we have: $$dS = sigma SdW_s \ dsigma^2 = alphasigma^2dt + xisigma^2dW_sigma$$ where $alpha$ and $xi$ are independent of $S$ and $dW_s$ and $dW_sigma$ are independent Wiener processes. My aim is to derive the distribution of $log S_tau$. First, if $barV_T$ denotes the mean variance over some time interval $[0,T]$ defined by $$barV_T = frac1T intlimits_0^Tsigma^2(t)dt,$$ it is easy to show (Lemma of Îto) that $$...
            閱讀完整內容