The template contains the daily prices of BAC, C, CMCSA, COP, CVX, DIS, FDX, IBM, JBLU, JPM, KO, MCD, MSFT, ORCL, PG, UPS, WMT, XOM for the period of January 2, 2017 to December 31, 2019. It also includes the Fama-French 3 factors.
finance
Description
The template contains the daily prices of BAC, C, CMCSA, COP, CVX, DIS, FDX, IBM, JBLU, JPM, KO, MCD, MSFT, ORCL, PG, UPS, WMT, XOM for the period of January 2, 2017 to December 31, 2019. It also includes the Fama-French 3 factors. Use the adjusted close prices to do the following calculations.for each of the stock return series. Report the estimates of α, β1, β2, β3, and their T-statistics and the R2 values for all the models. Calculate the P-values of all the parameter estimates using the student-t distribution function: P = t.dist.2t(abs(t − stat), dof). Here, dof is the degree of freedom of residual, the number at (4, 2) in the output matrix of the Linest function. The P-values can also be approximated by P = 2(1 − Norm.s.dist(t − stat, 1)) when the degree of freedom is large.
