Instructions: 1. Solve these problems using Microsoft Excel. Problem-4 For a stream having composition as shown in Table 2. Solve the Rachford-Rice equation to find out the v', and then find out the vapor and liquid composition. NCOMP (K-1) = 0 Rachford-Rice equation, zi is mole fraction; 1 +(K-1) 21 1 (K; v I+* - 1) Liquid composition if v is known. ' . y = kx Vapor composition Table 2 Stream data Chemical Propane n-Butane n-Pentane Ibmol/hr 20 30 50 Ki 3.7 1.4 0.6 1+(Ki-1) Hint: First find out (Ki-1) z for each component assuming a value for v'; then set the sum of this to zero by varying v?. Once the value for v' is found, xi and yi can be calculated by using equations given above