P12-9 Calculating Returns and Variability [LO1] You\'ve observed the following r
ID: 2804773 • Letter: P
Question
P12-9 Calculating Returns and Variability [LO1] You've observed the following returns on Crash-n-Burn Computer's stock over the past five years: 3 percent, -9 percent, 25 percent, 17 percent, and 16 percent. Requirement 1: What was the arithmetic average return on Crash-n-Burn's stock over this five year period? | 10.40% Requirement 2: (a) What was the variance of Crash-n-Burn's returns over this period? (Do not round intermediate calculations.) (Click to select) (b) What was the standard deviation of Crash-n-Burn's returns over this period? (Do not round intermediate calculations.) (Click to select)Explanation / Answer
Use average, stdev and var functions in Excel
3% -9% 25% 17% 16% average 10.40% std dev 11.99% variance 0.014384Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.