Event study - Testing for Significance

[h0hesc]

Hello,

i am doing an event study in excel for my masters thesis. I have a sample of n=36 and an event period of 3 days. I already did the calculations for the (cumulative) abnormal return for all companies, which looks like this:

Bildschirmfoto 2018-01-23 um 19.16.01.png

The final step now is testing for significance. How do I do this in Excel?


Best,
Daniel

[ben_hensel]

It should be pretty simple?

Or rather -- if you need the syntax, can you post the formula you want to use; we can translate that into Excel syntax for you to use.