This is what the graph is supposed to look like. I don't know how to plot it in excel. Can anyone help me plot it and show what you did?

16-14. Use the Redlich-Kwong equation to plot the compressibility factor, Z, against P for methane for T = 180 K, 189 K, 190 K, 200 K, and 250 K. Hint: Calculate Z as a function of V and P as a function of V, and then plot Z versus P. Z = For methane, A = 32.205 dm bar-mol-2. K1/2 and B = 0.029850 dmmol-'. By definition, PV RT and the Redlich-Kwong equation of state is (Equation 16.7) RT A V-B 11/27(V + B) We can create a parametric plot of Z versus P for the suggested temperatures, shown below. Note that the effect of molecular attraction becomes less important at higher temperatures, as observed in the legend of Figure 16.4. Chapter 16 1.2 N 180 K - 189 K 190 K 200 K -- 250 K - 100 300 200 P/ bar 16-14. Use the Redlich-Kwong equation to plot the compressibility factor, Z, against P for methane for T = 180 K, 189 K, 190 K, 200 K, and 250 K. Hint: Calculate Z as a function of V and P as a function of V, and then plot Z versus P. Z = For methane, A = 32.205 dm bar-mol-2. K1/2 and B = 0.029850 dmmol-'. By definition, PV RT and the Redlich-Kwong equation of state is (Equation 16.7) RT A V-B 11/27(V + B) We can create a parametric plot of Z versus P for the suggested temperatures, shown below. Note that the effect of molecular attraction becomes less important at higher temperatures, as observed in the legend of Figure 16.4. Chapter 16 1.2 N 180 K - 189 K 190 K 200 K -- 250 K - 100 300 200 P/ bar