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!
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.
How to i calculate the beta and alpha parameters in my market model.
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:
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,
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?