There are standard equations for calculating the heat capacity of a gas at specified temperature.

One common heat capacity equation is a third order polynomial as follows;

$C=a+bT+c{T}^2+d{T}^3$

If the coefficients a to $d$ are known for a particular gas, you can calculate the heat capacity.

Write a VBA function to calculate the heat capacity and write a sub procedure to test your

function. Please ask the user to enter the number of gases she$/$he wants to calculate the heat

capacity and write your code using FOR NEXT loop. Please let the user know that the

temperature should be entered in Celcius Degrees. Please use double precision variables.

Outputs should be written to Excel as shown below.