Question: Given an array of values called SalesVals, what function would return the percent of these values greater than 50? PERCENTRANK.INC(SalesVals,50) ?-PERCENTRAN K.EXC(SalesVals.50) O 1-PERCENTRANK.INC(SalesVals,50) 1-PERCENTRANK.EXC(SalesVals,50)

Given an array of values called "SalesVals", what function would return the percent of these values greater than 50? PERCENTRANK.INC(SalesVals,50) ?-PERCENTRAN K.EXC(SalesVals.50) O 1-PERCENTRANK.INC(SalesVals,50) 1-PERCENTRANK.EXC(SalesVals,50)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
