Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please write the specific steps, like how to get the answer in the excel. For example: =D1*D2+D3. Thanks! FILE HOME INSERT PAGE LAYOUT FORMULAS DATA

image text in transcribedplease write the specific steps, like how to get the answer in the excel. For example: =D1*D2+D3. Thanks!
FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in Calibri 11 - A A % Paste BIU- FH- 6.25 points Cells Editing Alignment Number Conditional Format as Cell Formatting" Table Styles Styles Clipboard Font fo eBook B D E F G H 1 2 Print 3 Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. 4 References 5 6 7 8 Year 1 2 3 4 15% 26% 7% -13% Y 21% 36% 13% -26% 15% 9 10 11 12 11% 13 14 Complete the following analysis. Do not hard code values in your calculations. Make sure to use the "sample" Excel formulas in your calculations. You must use the built-in Excel functions to answer this question. 15 16 X 9.20% 0.02042 Y 11.80% 0.05277 17 Arithmetic average return Variance Standard Deviation 18 19 20 4 Sheet1 Prey Mc Graw Next > 1 of 16

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

High Frequency Financial Econometrics

Authors: Yacine Aït Sahalia, Jean Jacod

1st Edition

0691161437, 978-0691161433

More Books

Students also viewed these Finance questions

Question

7. Identify four antecedents that influence intercultural contact.

Answered: 1 week ago

Question

5. Describe the relationship between history and identity.

Answered: 1 week ago