Required:
Compute descriptive statistics for the three financial investments fro
Required:
Compute descriptive statistics for the three financial investments from 1928 to 2021.
Compute the Sharpe ratio for excess returns.
Data: Lab 9-1 Data.xlsx
Specify the Question: What are the descriptive statistics for the returns to various financial investments? What are the risks relative to the returns for various financial instruments as measured by the Sharpe ratio?
Obtain the Data: The reported results of financial performance are included in the dataset for three different investments.
Analyze the Data: Refer to lab 9.1 in your text for additional instructions and steps.
Part 1: Upload one Word or PDF document containing all of your screenshots for this Lab using the button below.
Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format.
Take a screenshot of your summary statistics, paste it into a Word document named “Lab 9.1 Excel Submission.docx”, and label the screenshot Submission 1.
Take a screenshot of Sharpe ratio computation, paste it into the same Word document, and label the screenshot Submission 2. Part 2(See attached) Part 3.
If riskiness is measured by the standard deviation of returns, which is the riskiest investment: stocks, corporate bonds, or Treasury bonds? Why?
Why do investors who take on more risk require a greater return?
Leave a Reply