Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. zamuro

    Percentiles using VBA

    Michael thank you for your help. However I still haven't been able to solve my problem. Imagine I have a list of numbers (many) 1324.34 3432.43 43543.32 11.343 444.213 ... ... What I need is to find the 10,50 and 90th percentile of the list without storing them in a queue or an array and...
  2. zamuro

    Percentiles using VBA

    Sorry Michael but I was not able to follow you. could you explain me what you wrote with an example? thanks
  3. zamuro

    Percentiles using VBA

    I forgot to mention that the data is not sorted therefore I cannot use the N forula for Percentiles and I can't sort the data either because it will also take much memory and time
  4. zamuro

    Percentiles using VBA

    I am trying to generate a function to calculate percentile from a list of random numbers in Excel. However I do not want to use the formula WorksheetFunction.Percentile(queue(), 0.5) because I have too many numbers and generating a queue() will take too much memory. What I need is an...

Part and Inventory Search

Back
Top