The estimated beta for DELL is . (Round to five decimal places.)

b. The estimated beta for Nike is . (Round to five decimal places.)

c. The estimated alpha for DELL is . (Round to five decimal places.)

d. The estimated alpha for Nike is . (Round to five decimal places.)

Do not really need an answer, please just tell me how to do it on excel step by step. Thank you!!

I cannot directly copy paste since there is a word limitation, please just tell me the steps i can do it along.

Date 20040130 20040227 20040331 20040430 20040528 20040630 20040730 20040831 20040930 20041029 20041130 20041231 20050131 20050228 20050331 20050429 20050531 20050630 20050729 20050831 20050930 20051031 20051130 20051230 20060131 20060228 20060331 20060428 20060531 20060630 20060731 Monthly Returns 2004-2008 Value Weighted Risk-free Rate Market DELL 0.00071 0.023064 -0.015892 0.0006 0.015467 -0.023624 0.0009 -0.010685 0.029709 0.0008 -0.02423 0.034503 0.0006 0.014127 0.013226 0.0008 0.021563 0.016459 0.001 -0.037681 -0.009771 0.0011 0.002714 -0.017762 0.0011 0.020555 0.021814 0.0011 0.01781 -0.015168 0.0015 0.048243 0.155733 0.0016 0.03518 0.03998 0.0016 -0.026557 -0.009018 0.0016 0.022695 -0.03999 0.0021 -0.016937 -0.041656 0.0021 -0.025182 -0.093441 0.0024 0.037916 0.146425 0.0023 0.011531 -0.011771 0.0024 0.043331 0.025596 0.003 -0.005943 -0.120336 0.0029 0.010609 -0.039326 0.0027 -0.020784 -0.067836 0.0031 0.040406 -0.054235 0.0032 0.003476 -0.006666 0.0035 0.040112 -0.021369 0.0034 -0.001644 -0.010577 0.0037 0.01906 0.026207 0.0036 0.012968 -0.119624 0.0043 -0.031042 -0.031298 0.004 -0.000396 -0.036249 0.004 -0.001902 -0.113655 NKE 0.017529 0.051536 0.065802 -0.076024 -0.011119 0.067463 -0.040132 0.035758 0.048998 0.031853 0.0412 0.074179 -0.044768 0.003694 -0.038988 -0.078022 0.070173 0.056569 -0.032333 -0.058353 0.038271 0.029016 0.014872 0.021102 -0.067289 0.07202 -0.015787 -0.038308 -0.018695 0.012452 -0.024691 2006031 20060831 20060929 20061031 20061130 20061229 20070131 20070223 20070330 20070430 20070531 20070629 20070731 20070831 20070923 20071031 20071130 20071231 20080131 20080229 20080331 20080430 20080530 20080630 20080731 20080829 20080930 20081031 20081128 20081231 0.004 0.0042 0.0041 0.00411 0.0042 0.004 0.0044 0.0038 0.0043 0.0044 0.0041 0.004 0.004 0.0042 0.0032 0.0032 0.0034 0.0027 0.0021 0.0013 0.0017 0.0017 0.0017 0.0017 0.0015 0.0012 0.00 15 0.0008 0.0002 0.0009 -0.00 1902 0.025085 0.019452 0.037086 0.023716 0.010823 0.019438 -0.013998 0.012949 0.039893 0.038894 -0.014758 -0.031753 0.011623 0.040903 0.025842 -0.049279 -0.004342 -0.062305 | -0.02204 -0.01047 0.051144 0.023825 -0.078625 -0.01315 0.011042 -0.09806 -0.184726 -0.085206 0.021482 -0.113655 0.040129 0.01286 0.065236 0.119605 -0.078928 -0.034675 -0.0565 0.015755 0.08617 0.067473 0.060904 -0.0203 0.010011 -0.023009 0.108696 -0.198039 -0.00 1223 -0.182375 -0.006981 0.001 -0.064759 0.23779 -0.051171 0.122943 -0.11558 -0.241601 -0.25979 -0.084426 -0.083259 -0.024691 0.022279 0.088782 0.048619 0.076948 0.004548 -0.002222 0.057282 0.020676 0.01374 0.053658 0.030396 -0.031566 -0.001949 0.044462 0.12956 -0.009206 -0.017974 -0.045299 -0.018425 0.133389 -0.017647 0.023503 -0.124762 -0.015601 0.03289 0.107573 -0.138565 -0.076002 -0.037559