In: Statistics and Probability
Can someone also tell me how to write the commands in excel for 1/T and ln(tgel). I have to plot 1/T versus ln(tgel).
Cure temp. | Gel time | Linearized Forms | ||
T (K) | tgel (h) | 1/T (K-1) | ln(tgel) | |
373.15 | 9.007 | |||
383.15 | 6.200 | |||
393.15 | 4.016 | |||
403.15 | 2.533 | |||
413.15 | 1.711 | |||
423.15 | 1.549 | |||
433.15 | 0.780 | |||
443.15 | 0.619 | |||
453.15 | 0.635 | |||
463.15 | 0.708 | |||
473.15 | 0.549 |
Cure temp. | Gel time | Linearized Forms | ||
T (K) | tgel (h) | 1/T (K-1) | ln(tgel) | |
373.15 | 9.007 | 0.00268 | 2.198002 | |
383.15 | 6.2 | 0.00261 | 1.824549 | |
393.15 | 4.016 | 0.002544 | 1.390286 | |
403.15 | 2.533 | 0.00248 | 0.929404 | |
413.15 | 1.711 | 0.00242 | 0.537078 | |
423.15 | 1.549 | 0.002363 | 0.43761 | |
433.15 | 0.78 | 0.002309 | -0.24846 | |
443.15 | 0.619 | 0.002257 | -0.47965 | |
453.15 | 0.635 | 0.002207 | -0.45413 | |
463.15 | 0.708 | 0.002159 | -0.34531 | |
473.15 | 0.549 | 0.002113 | -0.59966 |
=ln(cell) for ln
=1/cell for inverse
formula
Cure temp. | Gel time | Linearized Forms | ||
T (K) | tgel (h) | 1/T (K-1) | ln(tgel) | |
373.15 | 9.007 | =1/B3 | =LN(C3) | |
383.15 | 6.2 | =1/B4 | =LN(C4) | |
393.15 | 4.016 | =1/B5 | =LN(C5) | |
403.15 | 2.533 | =1/B6 | =LN(C6) | |
413.15 | 1.711 | =1/B7 | =LN(C7) | |
423.15 | 1.549 | =1/B8 | =LN(C8) | |
433.15 | 0.78 | =1/B9 | =LN(C9) | |
443.15 | 0.619 | =1/B10 | =LN(C10) | |
453.15 | 0.635 | =1/B11 | =LN(C11) | |
463.15 | 0.708 | =1/B12 | =LN(C12) | |
473.15 | 0.549 | =1/B13 | =LN(C13) |