Dear community!
I'm currently working on my bachelor's project which examines the performance of mutual funds here in Denmark. As you might know, when you look at the performance of mutual funds, you are interested in whether the fund has beaten its benchmark or not. To comment on this, you look at Alphas, which is the intercept of a regression analysis. So far, me and my partner have written the intercept manually into an Excel file one by one but this is taking way too much time. (we still need to do 7000 more). Is there a way to save the intercept for multiple analyses at the same time? I might have 100 y variables explained by 4 factors, and I want to save the intercepts of the 100 analyses instead of having to write them down one by one. Is this possible?
Thank you very much!