Question: Based on Lab 9 . 1 Excel, Descriptive and Diagnostic Analytics: Calculating Returns to Investments Using the Sharpe Ratio, using the results of the descriptive

Based on Lab 9.1 Excel, Descriptive and Diagnostic Analytics: Calculating Returns to Investments Using the Sharpe Ratio, using the results of the descriptive statistics below, which statistic would you use to identify the investment with the highest risk?
A spreadsheet shows statistical results for S and P 500(includes dividends), B a a Corporate Bond, and U S T. Bond. The results for S and P 500 are shown in columns A and B from rows 3 through 15, as follows: Mean, 0.118206. Standard error, 0.020072. Median, 0.1452. Mode, not available. Standard deviation, 0.194608. Sample variance, 0.037872. Kurtosis, 0.125039. Skewness, negative 0.44474. Range, 0.964. Minimum, negative 0.4384. Maximum, 0.5256. Sum, 11.1114. Count, 94. The results for B a a Corporate Bond are shown in columns C and D from rows 3 through 15, as follows: Mean, 0.071857. Standard error, 0.007748. Median, 0.06465. Mode, not available. Standard deviation, 0.075121. Sample variance, 0.005643. Kurtosis, 0.64706. Skewness, 0.296424. Range, 0.4473. Minimum, negative 0.1568. Maximum, 0.2905. Sum, 6.7546. Count, 94. The results for U S T Bond are shown in columns E and F from rows 3 through 15, as follows: Mean, 0.051099. Standard error, 0.007921. Median, 0.0328. Mode, not available. Standard deviation, 0.076795. Sample variance, 0.005897. Kurtosis, 1.642672. Skewness, 0.980655. Range, 0.4393. Minimum, negative 0.1112. Maximum, 0.3281. Sum, 4.8033. Count, 94.
Multiple Choice
Mean
Range
Standard Deviation
Count

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 General Management Questions!