It must be solved by excel Questions $2(2$ Points$)$

On March $15,$ Trenton Medical received approval for a new drug. Using the data below from February $15$ through February $28$ as the measurement period:

Calculate the cumulative abnormal return $($CAR$)$ in the $+/-3$ days surrounding the announcement date.

Graph your results.

$\backslash$table$[[$Measurement Window,Event Window,$],[$Date$,$Trenton,,Date,Trenton$],[,,,,]]$

$\backslash$table$[[$February $15,1\mathrm{.}18,0\mathrm{.}19,$March $12,-0\mathrm{.}61,-0\mathrm{.}12],[$February $18,2\mathrm{.}03,-0\mathrm{.}03,$March $13,2\mathrm{.}66,0\mathrm{.}85],[$February $19,1\mathrm{.}60,0\mathrm{.}53,$March $14,3\mathrm{.}98,0\mathrm{.}13],[$February $20,2\mathrm{.}20,1\mathrm{.}92,$March $15,20\mathrm{.}69,-2\mathrm{.}48],[$February $21,-0\mathrm{.}10,-2\mathrm{.}08,$March $18,5\mathrm{.}56,3\mathrm{.}43],[$February $22,0\mathrm{.}45,0\mathrm{.}08,$March $19,3\mathrm{.}01,0\mathrm{.}70],[$February $25,-1\mathrm{.}58,-1\mathrm{.}54,$March $20,0\mathrm{.}07,0\mathrm{.}97],[$February $26,-1\mathrm{.}62,-1\mathrm{.}58,,,],[$February $27,3\mathrm{.}58,2\mathrm{.}06,,,],[$February $28,-2\mathrm{.}81,-2\mathrm{.}71,,,]]$