LinkBack URL
About LinkBacks
I need your help using the percentile.inc function. My input is not a single array, but it is the product of 2 arrays (A and B). So I have to do this in 2 steps:
Step 1: Create a new array (C) which is the product of A and B
Step 2: Apply the percentile.inc function on Array C.
I have to apply the percentile function 1000 times.
Is there a way to run this in a single step without creating C?
I tried to use the "Product" function but this function will only produce a single number not an array which I can use to run the percentile function.
Here's a small example.
Any help would be appreciate
A B C = A X B
2,283 0.0071 16.3
10,887 0.0077 84.3
8,503 0.0084 71.6
10,349 0.0092 94.7
5,646 0.0099 56.2
10,254 0.0108 110.9
4,914 0.0118 57.8
13,525 0.0128 172.8
10,593 0.0139 147.1
16,681 0.0151 251.8
=PERCENTILE.INC(AB228:AB237, 0.05) 34.2
Register To Reply
Bookmarks