Question

Hello, this is for a design of experiment class. I need to Plot 1/(mean MW) Versus 1/(mean Tg). Can someone do this for me in excel?

Mw= Molecular Weight

Tg= Glass Transition temperature

Mean MW (kDa)
4.8
9.3
14.0
19.5
25.5
36.7
66.4
88.5
111.8
144.4
176.0

Mean Tg (K)
349.1
360.0
364.3
366.9
368.1
369.9
371.2
371.7
371.6
372.3
372.3

Answer 1

As seen in the plot, the relationship seems to be linear between the two reciprocals

Mean MW Mean Tg 1/Mean MW 1/Mean Te 1/Mean MW vs 1/Mean Tg 4.8 9.3 14 19.5 25.5 36.7 66.4 88.5 349.1 360 364.3 366.9 368.1 369.9 371.2 371.7 371.6 372.3 372.3 0.208333 0.107527 0.071429 0.051282 0.039216 0.027248 0.015060 0.011299 0.008945 0.006925 0.005682 0.002865 0.002778 0.002745 0.002726 0.002717 0.002703 0.002694 0.002690 0.002691 0.002686 0.002686 0.002880 0.002860 0.002840 0.002820 0.002800 0.002780 S 0.002760 0.002740 0.002720 0.002700 0.002680 0.002660 144.4 176 0.0000 0.0500 0.1000 0.1500 0.2000 0.2500 1/Mean MW