Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The daily prices over a selected period for shares in Aaron's Adventures and Bradley's Boats (A and B) have been recorded and provided to you
The daily prices over a selected period for shares in Aaron's Adventures and Bradley's Boats (A and B) have been recorded and provided to you in the Assignment Data spreadsheet under "Q2". Use this data to answer the following questions.
Date Daily return of A Daily return of B 30/12/16 3.963 47.88851 -0.03646973 -0.009087339 29/12/16 4.113 48.32768 0.050773136 0.016983428 Correlation by using equation =CORREL() 0.21792004 28/12/16 4.333 49.16263 0.051237136 0.004305601 27/12/16 4.567 49.37522 0.098677719 0.019333786 Correlation iby using Data Analysis 26/12/16 50.34865 0.089814981 0.019981812 Daily return of A Daily return of B 23/12/16 5.567 51.37522 0.008018532 0.013610436 Daily return of A 0.21792004 22/12/16 5.612 50.68537 -0.011101322 0.032416715 Daily return of B 0.21792004 21/12/16 5.675 52.38347 0.024918465 20/12/16 5.675 51.10989 0.030881017 0.027743917 19/12/16 5.505 49.73018 0.08463585 0.035043717 16/12/16 6.014 51.5362 0.007538951 0.012686633 15/12/16 5.969 50.89057 0.01761027 -0.01455705 14/12/16 6.076 51.64233 0.001479047 -0.00290292 13/12/16 6.085 51.79268 0.087295635 0.040953553 12/12/16 6.667 54.00435 -0.002692595 0.021787565 9/12/16 6.685 55.20718 -0.001344488 0.01462916 8/12/16 5.694 54.41119 0.017033774 0.025811056 7/12/16 6.81 55.85281 0.011887073 0.000158427 6/12/16 6.73 55.86166 0.012030075 -0.031287815 5/12/16 6.65 57.6659 0.001201562 0.01874972 2/12/16 6.658 56.60458 0.010698366 0.00078182 1/12/16 6.73 56.56036 0.002667457 0.02026133 30/11/16 6.748 55.43713 0.006624466 -0.037468613 29/11/16 6.793 57.59514 0.010343823 0.016864066 28/11/16 6.864 56.63996 0.0039491 0.005744184 25/11/16 6.837 56.96719 0.014542217 0.015449787 24/11/16 6.739 56.10045 0.002678173 -0.013836935 23/11/16 6.721 56.8876 0.004001186 0.03027346 22/11/16 6.748 55.21602 0.001331952 21/11/16 6.757 55.21602 0.003979953 0.024530877 18/11/16 6.784 56.60458 0 0.022751137 17/11/16 6.784 57.92238 0.009056383 0.006523027 16/11/16 6.846 58.30269 0.005231037 0.002270201 15/11/16 6.882 58.43535 0.001309472 0.005325518 14/11/16 6.873 58.1258 -0.057330956 0.045072139 11/11/16 7.291 60.86931 -0.002462717 0.015731655 10/11/16 7.309 61.84219 0.005983952 0.010332094 9/11/16 7.353 62.48782 0.008503635 0.007701794 8/11/16 7.291 62.01023 0.010084519 7/11/16 7.291 61.39113 0.013262958 0.002299755 4/11/16 7.389 61.53264 0.006127451 -0.002723471 3/11/16 7344 61 70068 0 003552883 0 008237883 Q2 Sheet1 Q3Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started