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

Please help
how to understand standard deviations
Ore
The actual monthly demand of special pizza in the past 6 months were: 449, 352, 413, 348, 290, 352 If a four-month moving average forecasting model is used to generate forecasts, what is the value of the Mean Absolute Percent Error (in percent)? Use at least 4 decimals.
Data collected in 2019 showed that on average household in Malaysia earn RM6500 per month. The distribution of the Malaysia household income is approximately normally distributed with standard deviation RM1020. Without referring to R or statistical table, answer the questions below based on the given information. You must show proper steps or explanation. a) Approximately how many percent of Malaysia household earn less that RM3440 per month? b) What is the minimum earning of Malaysia household with the top 2.5% income?
The Credit Risk Department of a major bank estimates the default rate on loans under $10,000 to be 4%. The bank will make 2400 loans that are under $10,000 next month. Find the mean of ^p, where ^p is the proportion of defaults on the 2400 loans under $10,000 to be made next month.
6. Scientists estimate that the distribution of the life span of the Galápagos Islands giant tortoise is approximately normal with mean 100 years and standard deviation 15 years. Based on the estimate, which of the following is closest to the age of a Galápagos Islands giant tortoise at the 90th percentile of the distribution? (A) 80 years (B) 115 years (C) 120 years (D) 125 years (E) 130years
Suppose that the quarterly sales levels among health care information systems companies are approximately normally distributed with a mean of 8vmillion dollars and a standard deviation of 1.1million dollars. One health care information systems company considers a quarter a "failure" if its sales level that quarter is in the bottom 15%of all quarterly sales levels. Determine the sales level (in millions of dollars) that is the cutoff between quarters that are considered "failures" by that company and quarters that are not. Carry your intermediate computations to at least four decimal places. Round your answer to one decimal place.
Statistical forecasting
Select the year with a mean of 40 months, a median of 50 months, and a small standard deviation for the incubation period of chronic wasting disease. select the year with a mean of 40 months, a median of 50 months, and a large standard deviation for the incubation period of chronic wasting disease
30. The equation for yearly sales (in 000 rupees) for a commodity with year 2011 as , 91.6 + 28.8X. Determine the trend equation to give monthly trend values with Jan. 2012 as emmem originy origin and calculate the trend for March, 2012.

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