Question: calculate the standard deviation and expected return. S&P 500 Closing Data Company b = 1.31 Date Adjusted Close Returns Risk Free Rate (R f )

 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









Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!