In Excel, 200 values have been entered in cells A2:A201, which has been assigned a name "data". Some of the values are negative, and some positive. In cell C1, I want a single formula that will tell...

0,data),0.3) O b. =percentile(a2:a201,30) O c. =rank(data,0.3) O d. =percentile(if(data>0,data,0),0.3) "/>
Extracted text: In Excel, 200 values have been entered in cells A2:A201, which has been assigned a name "data". Some of the values are negative, and some positive. In cell C1, I want a single formula that will tell me the 30% percentile of the POSITIVE values only from the A2:A201 range. Select one: O a. =percentile(if(data>0,data),0.3) O b. =percentile(a2:a201,30) O c. =rank(data,0.3) O d. =percentile(if(data>0,data,0),0.3)