HW#$2$ Summer $2023$

See attached spreadsheet with A versus $x$ data.

a$.$ Plot it and see what form of fit you think might work. $($It is adsorption data$)$

b$.$ Suppose a Michaelis form might be appropriate $...A=\frac{a}{(b+cx{)}^2}$ find $a,bc$ using the solver and a least squares fit

Suppose we are using the ideal gas law $PV=NRT.R=8\mathrm{.}3143\frac{J}{\text{m}\text{o}\text{l}-K}.$ Make a table to show the volume of $1$mol of methane at T from $100$ to $300C,$ and p from $500$ to $2000$kPa. $($that$\text{'}$s a $2$d Table$)$ Use a step size of $50C$ and $100$kPa. Put T across the top.

a$.$ Use direct calculation with copying

b$.$ Use the data table function

c$.$ Optional $-$ Create a function in VBA called m$.$V to calculate $V$ with arguments $N,T,P$

d$.$ Make a plot of $V$ vs $P$ with $4$ lines at $T=100,150,200,$ and $300C$