Grossmont College Economics & Finance Question

User Generated

Zbrcf2000

Business Finance

Grossmont College

Description

Using four firms’ stock prices, calculate the average return (4), standard deviation (4), and correlation (6).

Explanation & Answer length: Excel Spreadsheet

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached. Please let me know if you have any questions or need revisions.

Date
1/22/2019
1/23/2019
1/24/2019
1/25/2019
1/28/2019
1/29/2019
1/30/2019
1/31/2019
2/1/2019
2/4/2019
2/5/2019
2/6/2019
2/7/2019
2/8/2019
2/11/2019
2/12/2019
2/13/2019
2/14/2019
2/15/2019
2/19/2019
2/20/2019
2/21/2019
2/22/2019
2/25/2019
2/26/2019
2/27/2019
2/28/2019
3/1/2019
3/4/2019
3/5/2019
3/6/2019
3/7/2019
3/8/2019
3/11/2019
3/12/2019
3/13/2019
3/14/2019
3/15/2019
3/18/2019
3/19/2019
3/20/2019
3/21/2019
3/22/2019
3/25/2019
3/26/2019
3/27/2019
3/28/2019
3/29/2019
4/1/2019
4/2/2019
4/3/2019
4/4/2019

AAPL - Adjusted Close
37,38
37,53
37,23
38,47
38,11
37,72
40,29
40,58
40,60
41,76
42,47
42,48
41,68
41,73
41,49
41,85
41,67
41,82
41,73
41,86
42,13
41,89
42,36
42,66
42,69
42,82
42,40
42,85
43,06
42,98
42,74
42,24
42,34
43,81
44,30
44,50
44,99
45,58
46,04
45,68
46,08
47,77
46,78
46,22
45,74
46,15
46,21
46,51
46,83
47,51
47,84
47,92

AAPL - % Return
0,4044%
-0,7926%
3,3137%
-0,9254%
-1,0365%
6,8334%
0,7201%
0,0481%
2,8405%
1,7110%
0,0344%
-1,8939%
0,1175%
-0,5751%
0,8617%
-0,4155%
0,3643%
-0,2225%
0,2993%
0,6435%
-0,5639%
1,1166%
0,7284%
0,0574%
0,3098%
-0,9836%
1,0511%
0,5029%
-0,1820%
-0,5754%
-1,1575%
0,2377%
3,4642%
1,1235%
0,4422%
1,1116%
1,3008%
1,0209%
-0,7925%
0,8739%
3,6830%
-2,0708%
-1,2091%
-1,0332%
0,8994%
0,1326%
0,6518%
0,6791%
1,4536%
0,6855%
0,1740%

MSFT - Adjusted Close
103,05
104,05
103,56
104,50
102,46
100,38
103,73
101,83
100,22
103,11
104,55
103,39
102,65
103,04
102,63
104,23
104,15
104,24
105,53
105,48
104,93
107,14
108,67
109,28
110,03
109,84
109,71
110,20
109,93
109,38
109,43
108,10
108,22
110,49
111,26
112,13
112,21
113,51
115,13
115,21
115,08
117,73
114,62
115,22
115,47
114,35
114,51
115,49
116,55
116,72
117,48
116,88

4/5/2019
4/8/2019
4/9/2019
4/10/2019
4/11/2019
4/12/2019
4/15/2019
4/16/2019
4/17/2019
4/18/2019
4/22/2019
4/23/2019
4/24/2019
4/25/2019
4/26/2019
4/29/2019
4/30/2019
5/1/2019
5/2/2019
5/3/2019
5/6/2019
5/7/2019
5/8/2019
5/9/2019
5/10/2019
5/13/2019
5/14/2019
5/15/2019
5/16/2019
5/17/2019
5/20/2019
5/21/2019
5/22/2019
5/23/2019
5/24/2019
5/28/2019
5/29/2019
5/30/2019
5/31/2019
6/3/2019
6/4/2019
6/5/2019
6/6/2019
6/7/2019
6/10/2019
6/11/2019
6/12/2019
6/13/2019
6/14/2019
6/17/2019
6/18/2019
6/19/2019
6/20/2019
6/21/2019
6/24/2019

48,24
49,00
48,85
49,13
48,72
48,70
48,79
48,79
49,74
49,92
50,08
50,81
50,73
50,27
50,03
50,10
49,14
51,55
51,21
51,85
51,05
49,67
49,68
49,15
48,47
45,65
46,38
46,93
46,72
46,46
45,01
45,87
44,93
44,16
43,99
43,81
43,60
43,83
43,03
42,60
44,16
44,87
45,53
46,74
47,34
47,89
47,73
47,72
47,38
47,66
48,78
48,64
49,03
48,86
48,81

0,6694%
1,5736%
-0,2999%
0,5614%
-0,8324%
-0,0402%
0,1810%
0,0100%
1,9473%
0,3594%
0,3286%
1,4423%
-0,1542%
-0,9075%
-0,4774%
0,1517%
-1,9256%
4,9086%
-0,6508%
1,2431%
-1,5443%
-2,6957%
0,0197%
-1,0744%
-1,3853%
-5,8120%
1,5830%
1,1979%
-0,4400%
-0,5682%
-3,1270%
1,9171%
-2,0472%
-1,7070%
-0,3841%
-0,4135%
-0,4769%
0,5187%
-1,8115%
-1,0110%
3,6584%
1,6143%
1,4682%
2,6617%
1,2779%
1,1580%
-0,3183%
-0,0206%
-0,7262%
0,5966%
2,3519%
-0,2923%
0,8036%
-0,3409%
-0,1006%

117,40
117,44
116,81
117,70
117,83
118,44
118,54
118,27
119,24
120,81
121,19
122,84
122,42
126,47
127,20
127,08
127,89
125,23
123,59
126,23
125,49
122,92
122,91
122,90
124,49
120,79
122,14
123,86
126,72
125,88
124,06
124,73
125,49
124,02
124,08
124,00
122,80
123,58
121,56
117,79
121,05
123,68
125,63
129,15
130,33
129,84
129,24
130,06
130,18
130,58
132,85
133,37
134,61
134,63
135,42

6/25/2019
6/26/2019
6/27/2019
6/28/2019
7/1/2019
7/2/2019...


Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4