Question: PLEASE SHOW STEPS WITHOUT EXCEL The historical returns for two investmentsA and Bare summarized in the following table for the period 2016 to 2020, E

PLEASE SHOW STEPS WITHOUT EXCEL The historical returns for two investmentsA andBare summarized in the following table for the period 2016 to 2020,PLEASE SHOW STEPS WITHOUT EXCEL

The historical returns for two investmentsA and Bare summarized in the following table for the period 2016 to 2020, E Use the data to answer the questions that follow. a. On the basis of a review of the return data, which investment appears to be more risky? Why? b. Calculate the standard deviation for each investment's returns. c. On the basis of your calculations in part b, which investment is more risky? Compare this conclusion to your observation in part a. a. On the basis of a review of the return data, which investment appears to be more risky? Why? (Choose the best answer below.) A. Investment A and investment B have equal risk because the average returns are the same. B. The riskier investment appears to be investment A, with returns that vary widely from the average relative to investment B, whose returns show less deviation from the average. C. The riskier investment appears to be investment B, with returns that vary widely from the average relative to investment A, whose returns show less deviation from the average. OD. The riskier investment appears to be investment B, with returns that closer to the average relative to investment A, whose returns are farther from the average. b. The standard deviation for investment A is %. (Round to two decimal places.) A B Year Rate of Return 2016 24.3% 14.3% 2017 6.9% 16.0% 2018 16.2% 17.1% 2019 30.1% 19.4% 2020 10.5% 21.2% Average 17.6% 17.6% (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.)

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 Finance Questions!