use excel

Lab Exercise 3 - Determine z-factor for a gas mixture numerically Several numerical schemes have been proposed to represent the Standing-Katz z-factor chart shown in Figure 2. One of the preferred is the Dranchuk Abou-Kassem equation which duplicates the data with an average absolute error of 0.6%. z=1+(A1+TprA2+Tpr3A3+Tpr4A4+Tpr5A5)pr+(A6+TprA7+Tpr2A8)pr2A9(TprA7+Tpr2A8)pr5+A10(1+A11pr2)(Tpr3pr2)e(A11pr2) Where, pr=0.27[zTprppr] and the constants are: A1=0.3265A2A3A4A5A6A7=1.0700=0.5339=0.01569=0.05165=0.5475=0.7361A8A9A10A11=0.1844=0.1056=0.6134=0.7210 The range of application for Eq. (1.5) is given by the following inequalities. 1.0