Question
The daily returns over a selected period for shares in Aarons Adventures and Bradleys Boats (A and B) have been recorded and provided to you
The daily returns over a selected period for shares in Aarons Adventures and Bradleys 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.
a) (C) State the Pearsons correlation coefficient for these daily returns.
*i need to know how to do this on excel. All they've given me is daily returns. thanks*
| Boat A | Boat B |
| -0.00336 | -0.00909 |
| -0.01236 | -0.02342 |
| -0.02446 | -0.00482 |
| -0.04781 | -0.03177 |
| 0.001225 | 0.008746 |
| -0.04893 | 0.009686 |
| -0.03473 | -0.0005 |
| -0.01599 | 0.007171 |
| 0.007448 | -0.02338 |
+500~ more
Step 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
Financial Terms Dictionary Investment Terminology Explained
Authors: Thomas Herold, Wesley Crowder
1st Edition
1521725764, 978-1521725764
