It essentially segregates the data points into 100 equidistant segments. D4 1 20 Increase by percentage or. In effect it is the real average rate of annual return for an investment.
One using the generic SUMPRODUCT function and another using a special Google Sheets function WEIGHTEDAVERAGE.
UNARY_PERCENTpercentage Returns a value interpreted as a percentage. How to Create a Percentage Progress Bar in Google Sheets. UNARY_PERCENTpercentage Returns a value interpreted as a percentage. To_percentB1sumB1B Array Formula to Get Percentage of Total in Infinite Rows.