Black Water CO(BWO)TATA Steel (TATA)1.Estimate the average daily return of each fund using the arithmetic average method. (EXCEL)Below are the historical closing prices for the two funds above.2. Calculate the standard deviation of each fund (EXCEL)DateBWOTATA3. Calculate the correlation between the two funds10/20/2016 113.3374 113.69714. Calculate the covariance between the two funds using a) Excel function, Covariance.S10/21/2016 113.7611 113.6408and b) using formula (Correlation multiplied by standard deviations of both funds.10/24/2016 115.1283 114.363510/25/2016 114.7624 113.509410/26/2016 113.9825112.38310/27/2016 113.4626 111.097110/28/2016 112.7501 110.787310/31/2016 112.6442 111.228511/1/2016 111.7969 109.867511/2/2016 110.9014 108.468911/3/2016 109.8134 107.943311/4/2016 109.4282 108.637911/7/2016 112.0279 111.294211/8/2016 112.7597 111.585211/9/2016 113.2797 115.020611/10/2016 111.4502 116.860311/11/2016 111.4984 119.5448

Since you have posted a question with multiple subparts, we will solve first three subparts for you.…

Answered: Black Water CO(BWO) TATA Steel (TATA)…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

A survey is conducted on 700 Californians older than 30 years of age. The study wants to obtain inference on the relationship between years of education and yearly income in dollars. The response variable is income in dollars and the explanatory variable is years of education. A simple linear regression model is fit, and the output from R is below: Im(formula = Income ~ Education, data = CA) Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) 25200.25 1488.94 16.93 3.08e-10 *** Education 2905.35 112.61 25.80 1.49e-12 *** Residual standard error: 32400 on 698 degrees of freedom Multiple R-squared: 0.7602
x1: Rate of hay fever per 1000 population for people under 25 96, 92, 122,126, 94, 123,12, 93, 125, 95, 125, 117, 97, 122,127, 88 x2: Rate of hay fever per 1000 population for people over 5097, 112,103, 96,114, 88, 110, 79, 15, 100, 89, 114, 85, 96 x1 = s1 = x2 = s2 = Compute the corresponding z or t-value as appropriate. (Test the difference ?1 − ?2. Do not use rounded values. Round your answer to three decimal places.) What is the value of the sample test statistic? Find a 90% confidence interval for ?1 − ?2. (Round your answers to two decimal places.)lower limit:________upper limit:________
A Scenario: Jimmy store sells large tins of Tom Tucker Coffee. The deli uses a periodic review system. Inventory is checked every 10 days which more orders are needed for tins. Order lead time is 3 days. Average demand is 7 tins, so average demand during the reorder period and order lead time (13) is 91 tins. Standard deviation of demand during the same 13 day period is 17 tins.1. Calculate the restocking level ( Assume the desired level is 90%)2. Suppose standard deviation of demand during the 13-day period drops to 4 tins. What happened to restocking level? Explain why?3. Draw a saw-tooth diagram. Beginning inventory level is equal to restocking level and the demand rate is a constant 7 tins per day. What is the safety stock level? What is the average inventory level?
use table 13-1 to find what annual percentage rate was charged on meghans loan
The inflation adjusted annual return of a diversified asset portfolio is assumed to have a normal distribution with a mean of 3.5% and a standard deviation of 1.25%. Represent the value for the inflation adjusted annual return that 95% of outcomes would exceed on a diagram and determine this value.
Please solve max in 30-60 minutes with the step, I'm needed and no reject thank u 1.Given l4 = 100 and l9 = 50. Calculate l5 assuming a Uniform Distribution of Death (UDD) Information/Note l4 = number of people living in year 4 l9 = number of people living in year 9 l5 = number of people living in year 5
Directions: Compute the total returns, the average of returns, and the standard deviation of the following stocks: 1) 2) EGRH Inc. MP, Ltd. AVERAGE OF STOCK RETURN YEA AVERAGE OF RETURNS (x) YEAR STOCK RETURN PRICE (x₁) PRICE RETU Jan-2021 Po Feb-2021 P8.6 Jan-2021 PO. Feb-2021 PO.090 Mar-2021 P0.097 Apr-2021 PO.189 May-2021 PO.164 Mar-2021 P9.14 Apr-2021 P13.30 May-2021 P13 Jun-2021 P60 Jul-2021 16.94 Jun-2021 P0.495 Jul-2021 PO.28 Aug-2021 PO Sep-2021 90 Aug-202 P13.70 Sep-2 P14.88 Oct-2021 0.375 Oct 21 P15.30 Nov-20 PO.325 N2021 P14.30 Dec-2 PO.330 ec-2021 P15.52 3) SD (8) GSM Inc. YEAR Jan-2021 P57. Feb-2021 P52.90 Mar-2021 P50.95 Apr-2021 P58.25 May-2021 P74.05 Jun-2021 P94.75 Jul-2021 P85.0 Aug-2021 P10 Sep-2021 P 00 Oct-2021 01.00 Nov-2021 100.40 Dec-202 P113.80 SD (8) = STOCK RETURN PRICE (x₁) AVERAGE OF RETURNS -x)² SD (8) = ACEE, Inc. YEAR STOCK RETURN PRICE (x₁) Jan-2021 P13.56 Feb-2021 P20.80 Mar-2021 P22.50 Apr-2021 P18.90 May-2021 P17.00 Jun-2021 P18.76 Jul-2021 P16.38…
Suppose that an individual stock’s return is normally distributed with a mean of 9% and a standard deviation of 4%. What is the probability that the stock’s return will be less than 12%? (please round your answer to 4 decimal places)
Directions: Compute the total returns, the average of returns, and the standard deviation of the following stocks: 1) 2) EGRH Inc. DMP, Ltd. STOCK RETURN YEA AVERAGE OF RETURNS (x) YEAR STOCK RETURN PRICE AVERAGE OF RETURNS (x) PRICE (x₁) Jan-2021 P8.30 Feb-2021 P8.60 Jan-2021 PO. Feb-2021 PO.090 Mar-2021 P0.097 Apr-2021 PO.189 May-2021 PO.164 Mar-2021 P9.14 Apr-2021 P13.30 May-2021 P13.74 Jun-2021 P14.80 Jul-2021 P16.94 Jun-2021 P0.495 Jul-2021 PO.28 Aug-2021 PO Sep-2021 90 Aug-2021 P13.70 Sep-2021 P14.88 Oct-2021 0.375 Oct-2021 P15.30 Nov-20 PO.325 Nov-2021 P14.30 Dec-2 PO.330 Dec-2021 P15.52 3) SD (8) GSM Inc. STOCK YEAR PRICE Jan-2021 P57.70 Feb-2021 P52.90 Mar-2021 P50.95 Apr-2021 P58.25 May-2021 P74.05 Jun-2021 P94.75 Jul-2021 P85.00 Aug-2021 P105.00 Sep-2021 P114.00 Oct-2021 | P101.00 Nov-2021 P100.40 Dec-2021 P113.80 SD (8) = RETURN (x₁) -x)² AVERAGE OF RETURNS (x-x)² (x) SD (8) = ACEE, Inc. YEAR STOCK RETURN PRICE (x₁) Jan-2021 P13.56 Feb-2021 P20.80 Mar-2021 P22.50 Apr-2021…

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS