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)

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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT