calculate the standard deviation and expected return.

S&P 500 Closing Data			Company b =	1.31
Date	Adjusted Close	Returns		Risk Free Rate (Rf) =	2.70%
4/1/2023	6109.58
3/1/2023	6113.63
2/1/2023	6087.11
1/1/2023	6088.03
12/1/2022	6106.22
11/1/2022	6085.58
10/1/2022	6024.40
9/1/2022	5956.94
8/1/2022	6020.93
7/1/2022	5796.28
6/1/2022	5762.29
5/1/2022	5836.05
4/1/2022	5732.65
3/1/2022	5655.70
2/1/2022	5547.90
1/1/2022	5561.97
12/1/2021	5504.16
11/1/2021	5552.17
10/1/2021	5484.37
9/1/2021	5513.52
8/1/2021	5513.01
7/1/2021	5396.76
6/1/2021	5342.20
5/1/2021	5266.51
4/1/2021	5374.01
3/1/2021	5285.29
2/1/2021	5262.23
1/1/2021	5336.70
12/1/2020	5370.13
11/1/2020	5362.11
10/1/2020	5246.21
9/1/2020	5108.77
8/1/2020	5141.41
7/1/2020	5079.52
6/1/2020	5085.37
5/1/2020	5226.29
4/1/2020	5227.67
3/1/2020	5044.53
2/1/2020	4953.21
1/1/2020	4915.25
12/1/2019	4796.23
11/1/2019	4563.67
10/1/2019	4480.43
9/1/2019	4369.94
8/1/2019	4325.47
7/1/2019	4212.56
6/1/2019	4201.96
5/1/2019	4149.03
4/1/2019	4152.66
3/1/2019	4051.69
2/1/2019	3901.70
1/1/2019	3976.82
12/1/2018	3923.39
11/1/2018	3796.67
10/1/2018	3651.86
9/1/2018	3644.10
8/1/2018	3757.39
7/1/2018	3714.10
6/1/2018	3701.17
5/1/2018	3650.59
4/1/2018	3583.00
Expected Return
Std. Dev

Answer rating: 100% (QA)

To calculate the standard deviation and expected return of the SP 500 closing data we f... View the full answer