(Solved): By using Microsoft Excel solve these: The Van Der Waals equation of state is given by: (P+V2a)(V ...

The Van Der Waals equation of state is given by: $\left(P+\frac{a}{V^2}\right)(V?b)=RT\text{ (A.1) }$ where $a=\frac{27}{64}\left(\frac{R^2{T}_e^2}{P_e}\right)\text{ (A.2) }$ and $b=\frac{R{T}_c}{8P_c}$ (A.3) where $P$ is the pressure ( $\mathrm{atm}),V$ is the molar volume $\left(\mathrm{L}{\mathrm{g}}^{?1}{\mathrm{mol}}^{?1}\right),T$ is the temperature $(\mathrm{K}),R$ is the gas constant $\left(R=0.08206\mathrm{atm}{\mathrm{L}}^{?1}{\mathrm{mol}}^{?1}{\mathrm{K}}^{?1}\right)$, $T_c$ is the critical temperature $(405.5\mathrm{K}$ for ammoammonia). Reduced pressure is defined as $P_r=\frac{P}{P_c}$ and the compressibility factor is given by $Z=\frac{PV}{RT}$ Using Newton Raphson numerical method and Excel: 1. Calculate the molar volume (V) and compressibility factor (Z) for gaseous ammonia at a pressure of $\mathrm{P}=56\mathrm{atm}$ and a temperature $\mathrm{T}=450\mathrm{K}$ using the Van Der Waals equation of state. 2. Repeat the calculations for the following reduced pressure: ${\mathrm{P}}_{\mathrm{r}}=1,2,4,10$, and 20. 3. How does the compressibility factor vary a function of ${\mathrm{P}}_{\mathrm{r}}$ ? Draw $\mathrm{Z}$ versus $\mathrm{Pr}$ using Excel.