Question

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

Additionally, in the spreadsheet portion of Excel, produce the appropriate fit statistics and generate a professionally formatted plot (P(kPa) vs. T(°C), markers for experimental data, line for model, suitable for printing in black and white). Problem 1 - Data Fitting: Vapor pressure data to an Antoine Expression P^{n \omega}(k P a)=10^{\left(1-\frac{B}{r\left({ }^{*} c\right)+c}\right)}

Fig: 1

Fig: 2

Fig: 3