Show computation through excel.During the past 5 years, you owned 2 stocks that had the following annual rates of return.Year12345Stock T0.190.08-0.12-.0300.15Stock B0.080.03-0.090.020.041. Compute the arithmetic mean annual rate of return for each stock. Which stock is mostdesirable by this measure?2.Compute the standard deviation of the annual rate of return for each stock. By thismeasure, which is the preferable stock?3. Compute the coefficient of variation for each stock. By this relative measure of risk,which stock is preferable?4. Compute the geometric mean rate of return for each stock.5. Discuss the difference between the arithmetic mean return and the geometric meanreturn of each stock. Relate the differences in the mean returns to the standardsdeviation of the return for each stock.

Sample size, The data annual rate of return on the two stock is shown below, YearStock TStock…

Answered: 1. Compute the arithmetic mean annual…

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

The fitted line that results from regressions of the Single Index Model is called:a. The security specific line.b. The security characteristic line.c. The single index line.d. The security market line.
The regression line for a set of data will have little meaning unless: Select one: a. the correlation coefficient is significant. b. the slope of the regression line is zero. c. the standard deviation of errors is zero. d. there are at least 30 data points chosen.
What formula do I use to find the variance, portfolio return and standard deviation in excel, given different combination of portfolio weights
Take the following information about the theater industry. The theater seats are classified as either reserved or vacant. Among the reserved seats, 2 percent becomes vacant every period. Among the vacant seats, 8 percent become reserved periodically. What is the natural rate of seats that are vacant?
A company's price/earnings (P/E) ratio is the company's current stock price divided by the latest 12 months' earnings per share. Suppose the following table shows the P/E ratios for a sample of 10 Japanese companies and 12 U.S. companies. Japan P/E Ratio 152 28 19 127 38 212 65 664 32 69 United States P/E Ratio 16 25 25 42 23 15 Find the value of the test statistic. W = 16 X 28 15 28 39 17 15 Is the difference between the P/E ratios for the two countries significant? Use the MWW test and a = 0.01 to support your conclusion. State the null and alternative hypotheses. O Ho: The two populations of P/E ratios are identical. H₂: The two populations of P/E ratios are not identical. O Ho: Median for Japanese companies - Median for U.S. companies > 0 H₂: Median for Japanese companies - Median for U.S. companies 0 O Ho: Median for Japanese companies - Median for U.S. companies > 0 H₂: Median for Japanese companies - Median for U.S. companies = 0 O Ho: The two populations of P/E ratios are not…
Consider the following asset with it's returns over the last 3 years. The arithmetic mean is 8% 1yr 2yr 3yr 8% 4% 6% What is the standard deviation? Respuesta:
IQ tests supposedly measure our intelligence. They typically are ‘normed’ so that they have a mean of 100 and a standard deviation of 15. (Higher scores show higher intelligence.) Use the graph and use the z-score and percents from columns b and c in Table A, when relevant. If you scored 132, what is your z-score? (Interpret.) Use table A X, z(a), (b), and (c) X z (a) (b) (c) and use the graph! Write down or save your response to use in Part 2 of this quiz. Group of answer choices -2.53 z. I'm at the 98.34 percentile rank and 1.66% of people scored smarter than me. 2.13 z. I'm at the 98.34 percentile rank and 1.66% of people scored smarter than me. -2.13 z. I'm at the 1.66 percentile rank and 98.34% of people scored smarter than me. 2.53 z. I'm at the 0.57 percentile rank and 99.43% of people scored smarter than me. 2.13 z. I'm at the 1.66 percentile rank and 98.34% of people scored smarter than me. 2.53 z. I'm at the 99.43 percentile rank…
C. Atlantic Video is planning to add the new Marvel movie to their collection, and they predict that this will double their demand (i.e. new arrival rate is 60 customers every hour) and halve the standard deviation of the inter-arrival times. However, they want to keep the average waiting time of customers in line the same as before. Assume that the coefficient of variation for the check-out times does not change. Please answer the following questions. 1) Does the employee need to work twice as fast? If not, calculate the new service rate. 2) What is the average number of customers in the store?
your car is more crowded than you think. table 5.8 reports results from a 1969 personal transportation survey on "home-to-work" trips in metropolitan areas. The survey stated that the average car occupancy was 1.4 people. check that calculation.

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