THE SOLUTION IS ON HERE BUT CAN YOU SHOW THE STEPS ON HOW TO GET THERE? NEED HELP. THANKS!

Jon Shu ui5cl a - o 5 - Quiz 5 CH 10-11 - PREP - IN CLASS V2.is - Excel Developer Kofax FOF Tell me what you want to do... File Data Review View Home Insert Page Layout Formulas X Arial 12 A E2 - BIU.9. A. Insert - Wrap Text General Paste L'Homme, Jon Share - 47 o Sort & Find & ' Filter - Select Editing Es Merge & Center $ % 41. Conditional Formatas Call Formatting Table Styles Styles 4* Delete- Format Clipboard Font Allgrment Number Cells G14 X f A G L N 0 P 1 B c D E F H 10.4 The Variabinty of Returns. The Second Lesson Over the past tree years, Alpha had ammual returns of 11 percet, -12 percent, and 20 percent, respectively. Over the same time period, Beta had annual returns of 10 percent. -2 percent, and 14 percent, respectively Which stock has the higher average return? Which is more volatie? Why? 4 5 DO 5 7 Use DATA and STAT functions on calculator. Beta has the higher average return. Alpba is more volatile, because the returns are more spre out (per the Variance and SD) 9 10 11 12 13 14 15 16 17 18 19 20 21 22 22 24 25 26 27 28 29 30 31 32 CH10.181 CH10.1 +3 CH10.1 #4 CH10.4 82 AAR-SD CH10.5 #1 GAR CH11.1 81 CH11.1 #2 CH11.2 +1 Ready 90% O