Welcome to the forum.
One way:
Row\Col A B C D 1 Bi x q(x) 2 0.1 0.050 -0.88043C2: =1 - EXP(SUMPRODUCT($A$2:$A$4 * B2^{0,1,2})) 3 0.2 0.100 -0.94644 4 0.3 0.150 -1.02081 5 0.200 -1.10434 6 0.250 -1.19789 7 0.300 -1.30251 8 0.350 -1.41935 9 0.400 -1.54976 10 0.450 -1.69527 11 0.500 -1.85765 12 0.550 -2.03891 13 0.600 -2.24138 14 0.650 -2.46773 15 0.700 -2.72103 16 0.750 -3.00483 17 0.800 -3.32322 18 0.850 -3.68094 19 0.900 -4.0835 20 0.950 -4.53726 21 1.000 -5.04965
Bookmarks