Search for question
Question

Using the experimental vapor pressure 2 data in the Homework 2 data file on Canvas, create a VBA macro-enabled Excel file to fit the data to the Wagner expression below.

Additionally, in the spreadsheet portion of Excel, produce the appropriate fit statistics, and generate a professionally formatted plot (P (kPa) vs. T(K), markers for experimental data, line for model, suitable for printing in black and white). Problem 2 - Data Fitting: Vapor pressure data to a Wagner Expression \ln P_{r}^{\text {sut }}=\frac{A \tau+B \tau^{1.5}+C \tau^{3}+D \tau^{6}}{1-\tau} \quad \tau=1-T_{r}

Fig: 1

Fig: 2

Fig: 3