solve using EXCEL

do not solve using matlab or paper

For a stream having composition as shown in Table-2. Solve the Rachford-Rice equation to find out the v (vapor fraction), and then find out the vapor and liquid composition. f()=i=1n1+(Ki1)(Ki1)zi Rachford-Rice equation, zi is mole fraction xi=1+(Ki1)zi Liquid composition if v is known. yi=Kixi Vapor composition Table I Stream data Hint: First find out 1+(Ki1)v(Ki1)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