Question

In: Finance

price Date EMAAR MALLS ARMX 1-Jan-17 2.64 4.04 8-Jan-17 2.65 4.11 15-Jan-17 2.58 4.05 22-Jan-17 2.58...

price

Date EMAAR MALLS ARMX

1-Jan-17 2.64 4.04

8-Jan-17 2.65 4.11

15-Jan-17 2.58 4.05

22-Jan-17 2.58 4.09

29-Jan-17 2.53 4.27

5-Feb-17 2.6 4.19

12-Feb-17 2.57 4.36

19-Feb-17 2.59 4.65

26-Feb-17 2.68 4.8

5-Mar-17 2.65 5.5

12-Mar-17 2.64 5.14

19-Mar-17 2.56 5

26-Mar-17 2.64 4.95

2-Apr-17 2.65 5.2

9-Apr-17 2.62 5.25

16-Apr-17 2.68 5.3

23-Apr-17 2.57 5.28

30-Apr-17 2.51 5.33

use the excel to calculate

the average return for Emar and Aramex

the standard deviation for Emar and Aramex

THE CORRELATION AND COVARIANCE

ATTACH YOUR FILE WITH YOUR NAME AND NUMBER

IF YOU DO NOT WANT TO USE EXCEL SHOW ME THE DETAIL SOLUTION AND WRITE THE EXCEL EQUATIONS

Solutions

Expert Solution

In below mentioned table values are calculated along with Excel Formula used


	Price
Date	EMAAR MALLS	ARMX
01-Jan-17	2.64	4.04
08-Jan-17	2.65	4.11
15-Jan-17	2.58	4.05
22-Jan-17	2.58	4.09
29-Jan-17	2.53	4.27
05-Feb-17	2.6	4.19
12-Feb-17	2.57	4.36
19-Feb-17	2.59	4.65
26-Feb-17	2.68	4.8
05-Mar-17	2.65	5.5
12-Mar-17	2.64	5.14
19-Mar-17	2.56	5
26-Mar-17	2.64	4.95
02-Apr-17	2.65	5.2
09-Apr-17	2.62	5.25
16-Apr-17	2.68	5.3
23-Apr-17	2.57	5.28
30-Apr-17	2.51	5.33
Average Return	2.61	4.75
Standard Deviation	0.05	0.53
Correlation	0.17
Corvariance	0.00

Formula Used
Average Return	AVERAGE(D5:D22)	AVERAGE(E5:E22)
Standard Deviation	STDEV(D5:D22)	STDEV(E5:E22)
Correlation	CORREL(D5:D22,E5:E22)
Corvariance	COVARIANCE.P(D5:D22,E5:E22)

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

price Date EMAAR MALLS ARMX 1-Jan-17 2.64 4.04 8-Jan-17 2.65 4.11 15-Jan-17 2.58 4.05 22-Jan-17 2.58...

price Date EMAAR MALLS ARMX 1-Jan-17 2.64 4.04 8-Jan-17 2.65 4.11 15-Jan-17 2.58 4.05 22-Jan-17 2.58 4.09 29-Jan-17 2.53 4.27 5-Feb-17 2.6 4.19 12-Feb-17 2.57 4.36 19-Feb-17 2.59 4.65 26-Feb-17 2.68 4.8 5-Mar-17 2.65 5.5 12-Mar-17 2.64 5.14 19-Mar-17 2.56 5 26-Mar-17 2.64 4.95 2-Apr-17 2.65 5.2 9-Apr-17 2.62 5.25 16-Apr-17 2.68 5.3 23-Apr-17 2.57 5.28 30-Apr-17 2.51 5.33 use the excel to calculate the average return for Emar and Aramex the standard deviation for Emar and Aramex THE CORRELATION...

closing price Date EMAAR MALLS ARMX 1-Jan-17 2.64 4.04 8-Jan-17 2.65 4.11 15-Jan-17 2.58 4.05 22-Jan-17...

closing price Date EMAAR MALLS ARMX 1-Jan-17 2.64 4.04 8-Jan-17 2.65 4.11 15-Jan-17 2.58 4.05 22-Jan-17 2.58 4.09 29-Jan-17 2.53 4.27 5-Feb-17 2.6 4.19 12-Feb-17 2.57 4.36 19-Feb-17 2.59 4.65 26-Feb-17 2.68 4.8 5-Mar-17 2.65 5.5 12-Mar-17 2.64 5.14 19-Mar-17 2.56 5 26-Mar-17 2.64 4.95 2-Apr-17 2.65 5.2 9-Apr-17 2.62 5.25 16-Apr-17 2.68 5.3 23-Apr-17 2.57 5.28 30-Apr-17 2.51 5.33 use the excel to calculate the average return for Emar and Aramex the standard deviation for Emar and Aramex THE...

Please do it by type not pics. Date Event Number of Units Price/Unit 1-Jan Beg. Inv 3,000...

Please do it by type not pics. Date Event Number of Units Price/Unit 1-Jan Beg. Inv 3,000 4.50 5-Jan Purchased 5,000 3.00 14-Jan Sold 4,000 4.00 27-Jan Purchased 6,000 2.00 29-Jan Sold 2,500 3.50 1.Purple Cow Inc. uses the perpetual first-in-first-out method to account for their inventory. Using the following information calculate the ending inventory? 2.Purple Cow Inc. uses the periodic first-in-first-out method to account for their inventory. Using the following information calculate the cost of goods sold for the period?

22. On January 1, 2018, Splash City issues $490,000 of 8% bonds, due in 15 years,...

22. On January 1, 2018, Splash City issues $490,000 of 8% bonds, due in 15 years, with interest payable semiannually on June 30 and December 31 each year. Assuming the market interest rate on the issue date is 7%, the bonds will issue at $535,061. Required: 1. Complete the first three rows of an amortization table. Date Cash Paid Interest Expense Decrease in Carrying Value Carrying Value 1/1/18 6/30/18 12/31/18 2. Record the bond issue on January 1, 2018, and...

1) What is the value of b1? X: 12, 21, 28, 8, 20. Y: 17, 15,...

1) What is the value of b1? X: 12, 21, 28, 8, 20. Y: 17, 15, 22, 19, 24 2) What is the value of b0? X: 12, 21, 28, 8, 20. Y: 17, 15, 22, 19, 24 3) What is the equation of the y-hat estimator line? X: 12, 21, 28, 8, 20. Y: 17, 15, 22, 19, 24. a. Y=0.162-16.51x b. y=0.162+16.51x c. Y=16.51-0.162x d. Y=16.51+0.162x 4) If x is increased by 10 units, how much does y-hat...

year X Y 1 10% 15% 2 24% 25% 3 10% 14% 4 -17% -22% 5...

year X Y 1 10% 15% 2 24% 25% 3 10% 14% 4 -17% -22% 5 105 16% calculate the arithmetic average returns variance and standard deviation

Given the following bond quote: Maturity Date:8/15/2039 Coupon Rate: 4%, semi-annual payments Bid Price: 158% of...

Given the following bond quote: Maturity Date:8/15/2039 Coupon Rate: 4%, semi-annual payments Bid Price: 158% of par Ask Price: 158.25% of par Change: 0.4688% Part A: Calculate the price an investor would pay to acquire $85,000 of par value in this bond. Part B: Calculate the price an investor would receive for selling $60,000 of par value in this bond

On January 1, 2000, Vick Company issued $500,000 of 8%, 15 year bonds, at a price...

On January 1, 2000, Vick Company issued $500,000 of 8%, 15 year bonds, at a price of 94. The bonds pay semiannual interest on June 30 and December 31 of each year. Vick records the interest payments every six months by amortizing the discount on bonds payable using the straight-line method. On Januray 1, 2005 Vick Company retires 30% of these bonds by buying them on the open market at a price of 97. How does the market rate compare...

3 6 4 8 1 10 2 9 11 12 15 22 3 6 7 5...

3 6 4 8 1 10 2 9 11 12 15 22 3 6 7 5 8 1 12 14 Each column represents a different treatment given to sick rats. Each cell is a different rat. Use statistical analysis and use post hoc testing using contrasts to find the best treatment. Treatment 1: vitamins Treatment 2: prescription pills Treatment 3: brain surgery Treatment 4: shock therapy Treatment 5: dietary changes

For the stress data given below with the nearest error of 1: 27-17-11-24-36-13-29-22-18 23-30-12-46-17-32-48-11-18 18-32-26-24-38-24-15-13-13 18-21-27-20-16-15-37-19-19...

For the stress data given below with the nearest error of 1: 27-17-11-24-36-13-29-22-18 23-30-12-46-17-32-48-11-18 18-32-26-24-38-24-15-13-13 18-21-27-20-16-15-37-19-19 a) Construct a frequency distribution table. b) Construct the three types of statistical graphs. c) Determine the (1) Mean, (2) Median, (3) Mode, (4) Range, Variance, and (6) Standard Deviation.

Subjects