Data-yNum-Bin

Binning a Continuous Variable

 Num Bins = 5

 k-th percentile
 k = 0: 0.2: 1

 | yBin | Percentile | yBin_Edge_Lower | 	
 |    1	|          - |            1.71 | =PERCENTILE.INC( <col_yValues> , k_Percentile )
 |    2	|       0.20 |	         20.63 |	 
 |    3	|       0.40 |	         41.35 |
 |    4	|       0.60 |	         69.86 |
 |    5 |       0.80 | 	        128.61 |

 Create new column next to Data_Calumn, call it "yBin"
 =OFFSET( <header_yBin>, MATCH( <yValue_on_this_row>, <col_yBin_Edge_Lower>, 1), 0)