Question: PLEASE EXPLAIN STEP BY STEP IN EXCEL THANK YOU :) Returns Year Y 1 12 % 14 % 24 29 -27 -33 14 17 19

PLEASE EXPLAIN STEP BY STEP IN EXCEL THANK YOU :) Returns

PLEASE EXPLAIN STEP BY STEP IN EXCEL

THANK YOU :)

Returns Year Y 1 12 % 14 % 24 29 -27 -33 14 17 19 37 UWN Using the returns shown above, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. (Do not round intermediate calculations. Enter your average return and standard deviation answers as a percent rounded to 2 decimal places, e.g., 32.16. Enter your variance answers as a decimal (not as a percent) rounded to 5 decimal places, e.g., .16161.) Y % % Average returns Variances Standard deviations % ... : %

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!

Returns Year Y 1 12% 14 % 2 29 3 - 27 -33 4 14 17 5 19 37 24 Using the returns shown above, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. (Do not...

7. Calculating Returns and Variability Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y: Returns Year Y 1 12% 14% 2 24 29...

please explain step by step thank youuuu D E F G H 1 j 2754 3% Loan Amount Nominal Periodic # of Payments Payment 60 Interest Amount Principal Amount Balance 13 A B 1 Step 1 Student Number 2 Input...

A retail store has recently started paying attention to customer analytics. The store collected data from a sample of 133 walk-in customers about registration in the store's points program and about...

Forms 1-11 On form 1 you are being told to record an investment the owner made in the business. We have seen this type of transaction since chapter 1. How does this transaction affect the business?...

The following pages contain annual data on interest rates, inflation rates, and percentage change in exchange rates (based on indirect quotes) for foreign countries, including the US, for the period...

If you could please solve this question using the pictures provided and if you make your own tables, make them look like the one's in the picture, It throws me way off track if done otherwise. Thank...

I was assigned Turkey 2001-2006 Instructions for the project: FIN 4375 The following pages contain annual data on interest rates, inflation rates, and percentage change in exchange rates (based on...

I have got transactions 1-33, but I am getting stuck at 34-39 to fill in the yellow boxes. Could you please explain how you get the answer. Thank you! Sorry it's so many pictures, the last person...

Use the International Stock Market database from "Excel Databases.xls" on Blackboard.Use Excel to develop a multiple regression model to predict the DJIA by the Nasdaq, the S&P 500, the Nikkei, the...

Use the formula for calculating a taxpayer's medical expense deduction. Make sure to properly label each medical expense and provide an explanation for any medical expenses that are nondeductible in...

1. Acceleration of a particle is given by: a = -bx, where "x" is the displacement from the mean position and "b" is a constant. The period of oscillation is: 2n a) b) c) d) b 2. In SHM path length is...

A criticism of the Basel I risk - based capital ratio is Question 2 0 Answer a . the more systematic accounting of credit risk differences. b . the application of a similar capital requirement across...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".