**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.

**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

**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

**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.

**Calculating the alpha and beta parameters.**

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

**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

**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?