**Estimation window adjustement**

I am trying to conduct event studies for a large sample and I am using your website tools in order to get my abnormal returns, t-tests.

Your template shows estimation window length as:

-2 ; 2 ; -11 ; 120

However, my teacher told me to examine a larger estimation window, of 240 days, with 40 days prior to the event date. How should I put the data in excel in order to extend the window?

**Possible error in the demo work of J-test**

Dear Dr Muller,

I am Vineet, a PhD student and who is referring to your demo work in excel for various event study methodology.

I appreciate the work done here and I find it very helpful.

I am currently referring to your work done on J-Test on the following page:

http://www.eventstudytools.com/significance-tests

I tried to replicate the methodology and got different results. I wish to resolve the inconsistencies.

Calculation of average correlation is certainly one problematic area. The paper says to use Residuals in estimation period to calculate that. However, your work is using Standardized Residuals in estimation period. Probably, I am misinterpreting the paper. Please verify.

Also, would it be possible for you to extend your work to demonstrate t-test for SCARs as well. That is where I think the analysis gets very tricky. And I am struggling a lot.

Thank you very much for your help,

Vineet

**Calculating the alpha and beta parameters.**

How to i calculate the beta and alpha parameters in my market model.

**Incorrect calculation of Alpha and Beta**

Dear Sir,

I believe that the way Alpha and Beta is calculated in the Basis Abnormal Return tool of your website is incorrect. The formula for Alpha should be as follows: Intercept(stock return of firm. return on index) while the ES with excel file that has been provided to give evidence that the results of your event study methodology tool are correct uses Intercept(return on index, stock return of firm). Same goes for Beta.

Could you please clarify this issue.

I hope to hear from you soon.

Khurram Shahzad, PhD.

**Enquiry about t-test on CAR**

Dear Dr.

Sorry to bother you. I am a Chinese student and I am doing my MSC dissertation. I am conducting an event study in order to figure out the influence of the release of movies. I feel confused about the way to test CAR. I am wondering can I calculate SD (CAR) directly through the STDEV formula in Excel? Further,I am not sure whether the "N"in the formula you provide to calculate standard deviation of AAR also stand for the number of events. Could you please give me some help? Thank you very much.

Have nice day!

ENQI

**Calculation of Average AR and CAR**

I don´t understand how I calculate average AR and CAR. I have 88 companies and 563 events. Do I need to divide AR by N events (563) or by N companies (88)? For example, event 1, is AAR=0,45629/563=0.00081046. What ist he right way to calculate AAR and ACAR? I would be very happy, if you can help me!

day abnormal_return cumulative_abnormal_return

-5 0.45629 2.65503

-4 -0.09955 2.65503

-3 0.41327 2.65503

-2 -0.16353 2.65503

-1 -0.01421 2.65503

0 0.56482 2.65503

1 -0.19816 2.65503

2 1.96007 2.65503

3 0.11497 2.65503

4 0.2138 2.65503

5 -0.59274 2.65503

**Calculation of Average AR and CAR**

I don´t understand how I calculate average AR and CAR. I have 88 companies and 563 events. Do I need to divide AR by N events (563) or by N companies (88)? For example, event 1, is AAR=0,45629/563=0.00081046. What ist he right way to calculate AAR and ACAR? I would be very happy, if you can help me!

day abnormal_return cumulative_abnormal_return

-5 0.45629 2.65503

-4 -0.09955 2.65503

-3 0.41327 2.65503

-2 -0.16353 2.65503

-1 -0.01421 2.65503

0 0.56482 2.65503

1 -0.19816 2.65503

2 1.96007 2.65503

3 0.11497 2.65503

4 0.2138 2.65503

5 -0.59274 2.65503

**Can we conduct event study using SPSS**

Dear Sir,

I am doing my Ph.D research, where I require to conduct event study (here event study is to be conducted by combining on multiple events)

Events are identified in the data series (both upper tails and lower tails)

Can it be possible to conduct this type of event study by using SPSS?

Kindly help me in this regard.

**GRANK - T and GRANK - Z estimation**

Hi, Firstly, I'm very impressed with the kind of event study calculation summary you have provided in your webpage. I have a question regarding the GRANK -T and GRANK - Z non parametric estimations. Are the GSAR ranked in ascending i.e. lowest rank for the lowest GSAR or vice versa descending order i.e. Highest rank for the lowest GSAR. I have checked other academic sources including Kolari and Pynnonen, (2011) but they don't seem to state it specifically. If I consider ranking in ascending order the T statistics are +ve for negative CAAR values whereas when ranked in decending order they are negative for -ve CAAR values. Looking forward to hear from you. Thanks for your time.

Regards,

John Pereira

**IPO CAR**

I'm trying to calculate Cumulative Abnormal Return for IPO firms after listing for 3 year trading period, by calculating monthly abnormal return and cumulating for the duration.

I went through the guides on CAR, but all of them cover event studies which include an estimation window. But as estimation windows is not available for IPO firms, I am confused how to calculate CAR. I have attached the formulas which I am considering to use.

Can you please help me to calculate CAR?