using visual basic

Question 1: Integration You will be supplied an excel spreadsheet containing a list of data points in the form of a column of Interval ( t ) values, and a list of concentration values C(t), taken from a Residence Time Distribution experiment. You are to write a function that takes in these two columns of data and finds the MEAN RESIDENCE TIME for the given set. The mean residence time is given by the equation: t=t=1s1C(t)dtt=1te1tC(t)dt You should also generate a plot of the data set, the concentration vs time and mark on this plot the mean residence time as a vertical line that divides the data set into two parts. Note - You are strongly advised to try this calculation using only the spreadsheet - to prove that you acknowledge the technique