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) | |