The file Delldata.xlsx (see attached) contains monthly - 94997

Solution Posted by
Solution Detail
Price: $10.00
Request Description
The file Delldata.xlsx (see attached) contains monthly returns for the Standard & Poor's stock index and for Dell Stock. The beta of a stock is defined as the slope of the least-squares line used to predict the monthly return for a stock from the monthly return for the market. -Estimate the beta of Dell? Date S and P return Dell return 1-Sep-88 0.042 0.282112845 1-Oct-88 0.027 0.1582397 1-Nov-88 -0.014 -0.084074373 1-Dec-88 0.018 -0.080317741 1-Jan-89 0.072 -0.049904031 1-Feb-89 -0.025 -0.171717172 1-Mar-89 0.024 -0.095121951 1-Apr-89 0.052 0.105121294 1-May-89 0.04 0.079268293 1-Jun-89 -0.005 -0.073446328 1-Jul-89 0.09 -0.142682927 1-Aug-89 0.019 0.036984353 1-Sep-89 -0.004 0.017832647 1-Oct-89 -0.023 -0.157681941 1-Nov-89 0.021 -0.0416 1-Dec-89 0.024 -0.043405676 1-Jan-90 -0.067 -0.158813264 1-Feb-90 0.013 0.350622407 1-Mar-90 0.026 0.219662058 1-Apr-90 -0.025 0.114609572 1-May-90 0.098 0.294915254 1-Jun-90 -0.007 0.147469459 1-Jul-90 -0.003 -0.069201521 1-Aug-90 -0.09 0 1-Sep-90 -0.049 -0.255718954 1-Oct-90 -0.004 0.215148189 1-Nov-90 0.064 0.234869015 1-Dec-90 0.027 0.409656181 1-Jan-91 0.044 0.223144785 1-Feb-91 0.072 0.115825202 1-Mar-91 0.024 0.128897338 1-Apr-91 0.003 -0.179858538 1-May-91 0.043 0.058726899 1-Jun-91 -0.046 -0.010085337 1-Jul-91 0.047 0.173589342 1-Aug-91 0.024 0.134557596 1-Sep-91 -0.016 0.02324897 1-Oct-91 0.013 -0.254817371 1-Nov-91 -0.04 -0.055191046 1-Dec-91 0.114 0.090277778 1-Jan-92 -0.019 0.243911577 1-Feb-92 0.013 0.094277108 1-Mar-92 -0.02 0.042939719 1-Apr-92 0.029 0.082607548 1-May-92 0.005 0.023647001 1-Jun-92 -0.015 -0.325553703 1-Jul-92 0.04 0.269067797 1-Aug-92 -0.02 0.097662771 1-Sep-92 0.012 0.133840304 1-Oct-92 0.004 0.192041136 1-Nov-92 0.034 0.076894224 1-Dec-92 0.013 0.306165099 1-Jan-93 0.007 -0.0364 1-Feb-93 0.014 -0.305382593 1-Mar-93 0.022 0.093227092 1-Apr-93 -0.025 -0.174380466 1-May-93 0.027 -0.167954094 1-Jun-93 0.003 -0.222811671 1-Jul-93 -0.005 0.07337884 1-Aug-93 0.038 -0.087122417 1-Sep-93 -0.007 -0.095088819 1-Oct-93 0.02 0.217859892 1-Nov-93 -0.009 0.339443742 1-Dec-93 0.012 -0.165880132 1-Jan-94 0.034 -0.027439887 1-Feb-94 -0.027 0.136125654 1-Mar-94 -0.044 0.009984639 1-Apr-94 0.013 -0.12851711 1-May-94 0.016 0.30104712 1-Jun-94 -0.025 -0.078694389 1-Jul-94 0.033 0.061635525 1-Aug-94 0.041 0.160685714 1-Sep-94 -0.024 0.152028358 1-Oct-94 0.023 0.188547009 1-Nov-94 -0.037 -0.03221631 1-Dec-94 0.015 -0.048001189 1-Jan-95 0.026 0.039650328 1-Feb-95 0.039 -0.026426426 1-Mar-95 0.03 0.054287477 1-Apr-95 0.029 0.251462844 1-May-95 0.04 -0.079953244 1-Jun-95 0.024 0.193622157 1-Jul-95 0.033 0.081000532 1-Aug-95 0.003 0.184619929 1-Sep-95 0.042 0.103898263 1-Oct-95 -0.004 0.097055945 1-Nov-95 0.044 -0.050926561 1-Dec-95 0.019 -0.21752965 1-Jan-96 0.034 -0.209334566 1-Feb-96 0.01 0.255639977 1-Mar-96 0.01 -0.025414262 1-Apr-96 0.015 0.369376254 1-May-96 0.026 0.207101004 1-Jun-96 0.004 -0.081305981 1-Jul-96 -0.045 0.090954837 1-Aug-96 0.021 0.209467251 1-Sep-96 0.056 0.15826858 1-Oct-96 0.027 0.046631271 1-Nov-96 0.076 0.248839953 1-Dec-96 -0.02 0.045500346 1-Jan-97 0.062 0.244706804 1-Feb-97 0.008 0.075614595 1-Mar-97 -0.042 -0.049198029 1-Apr-97 0.06 0.237519519 1-May-97 0.061 0.34426919 1-Jun-97 0.045 0.04389009 1-Jul-97 0.079 0.456102346 1-Aug-97 -0.056 -0.040205848 1-Sep-97 0.055 0.180506541 1-Oct-97 -0.033 -0.172906998 1-Nov-97 0.046 0.050700907 1-Dec-97 0.017 -0.002223616 1-Jan-98 0.011 0.183780952 1-Feb-98 0.072 0.406663073 1-Mar-98 0.051 -0.031279312 1-Apr-98 0.01 0.191881919 1-May-98 -0.017 0.020512693 1-Jun-98 0.041 0.1262766 1-Jul-98 -0.011 0.170033315 1-Aug-98 -0.145 -0.079135419 1-Sep-98 0.064 0.315 1-Oct-98 0.081 -0.003802281 1-Nov-98 0.061 -0.071566412 1-Dec-98 0.058 0.203497971 1-Jan-99 0.042 0.366351677 1-Feb-99 -0.031 -0.19875 1-Mar-99 0.04 0.020280811 1-Apr-99 0.039 0.00764526 1-May-99 -0.024 -0.163884674 1-Jun-99 0.056 0.074410163 1-Jul-99 -0.031 0.10472973 1-Aug-99 -0.005 0.194189602 1-Sep-99 -0.027 -0.14340589 1-Oct-99 0.063 -0.040358744 1-Nov-99 0.02 0.07165109 1-Dec-99 0.059 0.186046512 1-Jan-00 -0.05 -0.246323529 1-Feb-00 -0.019 0.061788618 1-Mar-00 0.098 0.321592649 1-Apr-00 -0.03 -0.070683662 1-May-00 -0.021 -0.139650873 1-Jun-00 0.025 0.143478261 1-Jul-00 -0.016 -0.108998733 1-Aug-00 0.062 -0.007112376 1-Sep-00 -0.053 -0.293696275 1-Oct-00 -0.004 -0.042596349
Solution Description
Attachments
The_file_Delldata.xlsx_contains_monthly_returns_for_the_Standard___Poors_stock_index.xlsx
The_file_Dellda...