Plot the data below from a sample of Copper $($II$)$ Sulfate solution at a constant wavelength of $780nm.$ Prepare two graphs, the first graph should plot the Concentration on the X$-$Axis vs the $\%$ transmittance on the Y$-$Axis. Convert the Transmittance to Absorbance using the above equation and prepare a second graph plotting Concentration vs$.$ Absorbance.

$\backslash$table$[[$Concentration$,\%$ Transmittance,Absorbance$],[0mM,100\%,0],[10mM,80\%,0\mathrm{.}0969],[20mM,64\%,0\mathrm{.}1938],[40mM,41\%,0\mathrm{.}3872],[60mM,26\%,0\mathrm{.}585],[80mM,17\%,0\mathrm{.}7695],[100mM,11\%,0\mathrm{.}9586],[120mM,7\%,1\mathrm{.}1549],[140mM,5\%,1\mathrm{.}301],[160mM,3\%,1\mathrm{.}5228],[180mM,2\%,1\mathrm{.}6989],[200mM,1\%,2]]$

Using the data provided, plot the Concentration on the X$-$Axis vs the $\%$Transmittance on the $Y$ Axis. Include this graph in your report

Using the data provided, plot the Concentration on the X$-$Axis vs the Absorbance on the Y$-$Axis. Include this graph in your report. GRAPH MUST BE DONE ON EXCEL