Question: Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year Y 1 15% 21%

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year Y 1 15% 21% 2345 26% 36% 3 7% 13% -13% -26% 11% 15% 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. Arithmetic average return Variance Standard Deviation Y

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!

Vibrant Company had $850,000 of sales in each of Year 1. Year 2, and Year 3, and it purchased merchandise costing $500,000 in each of those years. It also maintained a $250,000 physical inventory...

Explain the expansion of the work by Hazen and Shaver and Identify how the attachment styles might look in adult relationships. Do you agree with the expansion of the work by Hazen and Shaver (and...

my.charlotte.edu learn.hawkeslearning.com 4.1a Higher Order Derivatives and Conc... Lesson 4.1a Higher Order Derivatives a... Lizzie Borden Murder Case (143) TIMTHETATMAN REACTS TO STR... - Save...

The following data relates to direct labor costs for August: Actual costs: 5,500 hours at $24.00 per hour. Standard Costs: 5,000 hours at $23.70 per hour. What is the direct labor rate variance?

What are the advantages and disadvantages associated with the unadjusted rate of return method for evaluating capital investments?

Who gets progressive disease without attacks?

=+b) Develop a 6-month and 12-month moving average model for this series.

The management of a factory is going to erect a maintenance building with a connecting electrical generator and Water tank. The activities, activity descriptions, and estimated durations are given in...

C. Use the following to answer questions 29-32 Match the four underlying assumptions of Generally accepted Accounting Principles with its description Assumption Description 29 Economic entity a. In...

Your grandfather has offered you a choice of one of the three alternatives Option 1 Option 2 Option 3 $5000 today $1000 a year for eight years $12000at the end of eighth year. a.Assume you can earn...

Can you show me steps and solution to solve these

1) If Bellevue was using Class B private addresses for internal computers and they had 16 departments where each department had their own subnet, how many computer hosts could be in each department...

1-25 Strategic decisions and management accounting. A series of independent situations in which a firm is about to make a strategic decision follow. Decisions: a. Roger Phones is about to decide...

If you were faced with an imminent catastrophic attack or security event and you have only the time to secure one thing, what would it be and why? What would come in second?

Q4. For each of the three Southern Water Corp. Desalination Plants, they produce desalinated water which is then consumed via private, public or residential usage. These costs are then aggregated at...

Question 1: Write a select statement to create the inner join of tables sec1310_table1 and sec1310_table2 . The join condition should say that the first three columns of these tables are equal. ...

. Question 4 (total of 10 marks): David has some Australian and Indian assets and liabilities as follows: AUD 800,000 apartment which is partly financed with a loan. AUD 600,000 mortgage loan. AUD...

Decades after the event, Johnson & Johnson (J&J), the 130-year-old American multinational, is still praised for swiftly The company indicated that its response was based on the expectations set forth...

Cloud Fund had the following trades in Sun in the options market through David Brother Brokers. The stock exchange requires that the writer of the options maintain 10 percent of the value of the...

For each of the following scenarios, prepare journal entries, general ledger, trial balance, income statement, and balance sheet.

Cerebros Fund had the following trades in ABB in the options market through James Brothers Brokers. The stock exchange requires that the writer of the options maintain 10 percent of the value of the...