A natural dry gas has the following composition:

$\backslash$table$[[$Component$,\backslash$table$[[$Mole Fraction$],[($Yi$)]]],[N_2,0\mathrm{.}0236],[C{O}_2,0\mathrm{.}0200],[H_{2}S,0\mathrm{.}1841],[CH4,0\mathrm{.}8000],[C2H6,0\mathrm{.}0180],[C3H8,0\mathrm{.}0005],[i-C4H10,0\mathrm{.}0003],[n-C4H10,0\mathrm{.}0003],[i-C5H12,0\mathrm{.}0001],[n-C5H12,0\mathrm{.}0001],[C6H14,0\mathrm{.}0001],[C7+,0\mathrm{.}0009],[\frac{?}{\text{S}\text{U}\text{M}},1\mathrm{.}0480],[,]]$

$C_7^{+}$molecular weight $=125lb\frac{m}{l}bm-$mol, $C_7^{+}$gravity $=0\mathrm{.}77$

Calculate: $($Create excel spread sheet$)$

a$.$ Average molecular weight, $M_a,$ of the gas mixture.

b$.$ Specific gravity, ${}_g,$ of the gas mixture.

c$.$ The pseudocritical pressure, $P_{pc},$ and the pseudocritical temperature, $T_{pc},$ using MaCain's mixing rules.

d$.$ Corrected pseudocritical pressure, $P_{pc},$ and the pseudocritical temperature, $T_{pc}.$

e$.$ Use the results of part $d$ to build a table of the following gas properties $(z$ factor, gas density, ${}_g,$ gas formation volume factor, $B_g,$ gas compressibility, $C_g,$ and gas viscosity, $($:${}_g\}$ at a temperature of $250F$ and pressure of $500,1000,1500,2000,2500,$ and $3000$