DigiTools Digital Workbook

Enter values from 0.1 to 1.0 in a column, say from L21 to L30. Then in M20 use the formula =P19 to get a copy of the expected percentage discount. Now select the whole area L20:M30, use Data | Table and in the window labelled "Column input cell" type in B3 (or the address of whichever cell you have used to store your claim frequency parameter). ................
................