Why are the percentiles different than when calculated in a scientific calculator?

%3CLINGO-SUB%20id%3D%22lingo-sub-2435476%22%20slang%3D%22en-US%22%3EWhy%20are%20the%20percentiles%20different%20than%20when%20calculated%20in%20a%20scientific%20calculator%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2435476%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20calculate%20position%20measures%20like%20percentiles%20from%20a%20data%20base%2C%20excel%20returns%20values%20with%20decimals%20that%20have%20nothing%20to%20do%20with%20the%20accurate%20result.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20in%20the%20image%20I%20attach%2C%26nbsp%3B%20I'm%20signaling%20the%20results%20of%20the%20percentiles%20I%20want%2C%20but%20in%20the%20case%20of%20the%20Decile%208%2F%20Percentile%2080%2C%20the%20result%20should%20be%209.5%2C%20as%20it%20is%20the%20result%20of%20the%20average%20of%209.1%20and%209.9%2C%20but%20excel%20returns%209.26%20%3F%3F%3F%20And%20I%20don't%20understand%20where%20does%20it%20get%20that%20from.%20Same%20happens%20with%20the%20other%20results.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20really%20appreciate%20if%20someone%20could%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2435476%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2437107%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20are%20the%20percentiles%20different%20than%20when%20calculated%20in%20a%20scientific%20calculator%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2437107%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1075884%22%20target%3D%22_blank%22%3E%40XimenaO%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20it%20possible%20to%20share%20Excel%20file%20with%20the%20same%20information%20as%20on%20screenshot%3F%20It's%20not%20clear%20do%20you%20use%20inclusive%20or%20exclusive%20percentile%20and%20on%20which%20array.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When I calculate position measures like percentiles from a data base, excel returns values with decimals that have nothing to do with the accurate result. 

 

For example, in the image I attach,  I'm signaling the results of the percentiles I want, but in the case of the Decile 8/ Percentile 80, the result should be 9.5, as it is the result of the average of 9.1 and 9.9, but excel returns 9.26 ??? And I don't understand where does it get that from. Same happens with the other results. 

 

I would really appreciate if someone could help me.

1 Reply

@XimenaO 

Is it possible to share Excel file with the same information as on screenshot? It's not clear do you use inclusive or exclusive percentile and on which array.