Question

In: Finance

calculate the mean daily return, Variance and standard deviation for each stock?

BAFB
-0.01209-0.00981
0.002052-0.00471
-0.0050.015101
0.0039630.006353
0.0034920.000879
0.003253-0.0016
0.005702-0.00144
0.0054430.00016
0.000752-0.00016
0.01172-0.00785
0.002525-0.00484
-0.002070.008678
0.002078-0.0037
-0.00415-0.00282
0.0040910.004775
-0.00630.001772
-0.00634-0.00716
-0.002330.00332
-0.005640.008637
0.0050670.012644
-0.01573-0.00553
-0.01040.002225
0.0034760.000396
0.00970.002695
0.0139520.025452
-0.002630.010175
0.00196-0.00595
-0.03288-0.02433
0.0123710.01251
-0.01045-0.0115
-0.008470.004402
0.0007830.004539
-0.008370.00561
0.006156-0.00325
0.002432-7.8E-05
0.0216760.010106
0.0100340.001077
-0.00068-0.0163
-0.00918-0.00508
0.0057440.01084
0.006930.004196
-0.00908-0.00882
0.0054190.001405
0.0048580.003898
-0.00098-0.0045
0.0182230.002184
-0.001780.002102
-0.004240.001942
0.0148670.009691
-0.01546-0.01044
-0.004340.001319
0.001652-0.00953
0.00090.000469
0.003745-0.00266
0.0082090.008076
0.0079940.011978
-0.0025-0.00085
-0.001550.015923
0.0134190.009162
0.011422-0.00743
0.0469-0.00945
-0.01532-0.0103
-0.002090.012337
-0.00406-0.00228

calculate the mean daily return, Variance and standard deviation for each stock?

Solutions

Expert Solution

The first pic is with using BUILTIN EXCEL FUNCTIONS & second pic is actual method to follow

Actual method

jeff jeffy answered 3 years ago
Next > < Previous

Related Solutions

Calculate the mean daily return, variance and standard deviation for both stocks show your work?
AAPLBABA-0.0148-0.00640.012538-0.001550.0061780.0129080.015207-0.001890.0082810.0048470.004060.002824-0.007440.024519-0.000650.0508420.0023160.0706110.012017-0.01099-0.00091-0.00525-0.001460.003517-0.0012800.002567-0.00144-0.00777-0.012490.0031330.001464-0.00753-0.01994-0.004260.000639-0.005860.011922-0.00112-0.00189-0.007680.0118040.0009430.0123960.0059380.0023660.0093690.018785-0.000280.0456420.006128-0.01407-0.026210.002443-0.02265-0.028760.0223990.0118450.023805-0.005160.0353870.0211410.0339980.020019-0.005620.001819-0.01166-0.01539-8.8E-05-0.01621-0.000180.0457770.0094230.031698-0.01666-0.015090.001508-0.01690.001860.0223820.0076050.004526-0.01553-0.029430.0077550.002274-0.00469-0.003880.0042660.0006640.0004430.014320.007430.0011220.001493-0.010090.0174470.0227360.002154-0.029330.008942-0.0153-0.00307-0.014190.005556-0.00294-0.000680.00972-0.000680.004862-0.002980.005709-0.00051-0.00077-0.003930.0008670.0090050.0053880.0051-0.00268-0.02249-0.01382-0.0096-0.00389-0.00664-0.0044-0.00158-0.00235Calculate the mean daily return, variance and standard deviation for both stocks show your work?
Problem 01: Calculate individual stock average, standard deviation, variance, portfolio variance Given are the daily returns...
Problem 01: Calculate individual stock average, standard deviation, variance, portfolio variance Given are the daily returns for two stocks X and Y for five business days in last week. If you have 1000 dollars to invest and you are considering to invest 600 dollars in stock X and 400 dollars in stock Y. Calculate the following A. average stock return for individual stocks B. variance and standard deviations for the individual stocks C. calculate the covariance and correlation between the...
a) Calculate the mean, variance, and standard deviation for each of the binomial distributions below. i)...
a) Calculate the mean, variance, and standard deviation for each of the binomial distributions below. i) ?~?(1000,0.05) ii) ?~?(800,0.25) b) Team Victory’s winning rate is 20% whenever it plays a match. If the team Victory played 10 matches, what is the probability: i) It will win exactly one match. ii) It will win at most two matches. c) On average, Ali scores a goal per match. What is the probability that Ali will score: i) No goals in the next...
how to calculate standard deviation and coefficient of variance of the expected return of one asset?...
how to calculate standard deviation and coefficient of variance of the expected return of one asset? Of a portfolio? give examples
Calculate the mean, the variance, and the standard deviation of the following discrete probability distribution. (Negative...
Calculate the mean, the variance, and the standard deviation of the following discrete probability distribution. (Negative values should be indicated by a minus sign. Round intermediate calculations to at least 4 decimal places. Round your final answers to 2 decimal places.) x −32 −20 −10 −5 P(X = x) 0.46 0.24 0.18 0.12
Given the data set below, calculate the range, mean, variance, and standard deviation
Given the data set below, calculate the range, mean, variance, and standard deviation. 19,  33,  8,  29,  18,  5, 10, 14,  25 Range = Mean = Variance = Standard deviation =
1. Calculate the mean, the variance, and the standard deviation of the following discrete probability distribution....
1. Calculate the mean, the variance, and the standard deviation of the following discrete probability distribution. X -23 17 -9 -3 P(X=x) 0.5 0.25 0.15 0.19 2. A marketing firm is considering making up to three new hires. Given its specific needs, the form feels that there is a 60% chance of hiring at least two candidates. There is only a 5% chance that it will not make any hires and a 10% chance that it will make all three...
2. Calculate the expected return, variance, and standard deviations of stock A, stock B, and obtain...
2. Calculate the expected return, variance, and standard deviations of stock A, stock B, and obtain the expected return of an equally weighted portfolio of both (meaning 50% in A, and 50% in B). Please show all work and formulas used. Scenario Probability A B Boom 1/3 -4% 9% Normal 1/3 8% 4% Recession 1/3 20% -4%
(TCO 2) Given the data below, calculate the expected return, variance, and standard deviation of the...
(TCO 2) Given the data below, calculate the expected return, variance, and standard deviation of the following company. In a recessionary economy, which is expected to occur with a 30% probability, the expected returns would be -5%. In an expanding economy with an expected probability of occurrence of 20%, the expected return would be 10%. In a normal economy, expected to occur 50% of the time, the expected return would be 5%.
a) the mean is b) the variance is c) the standard deviation is
activities 0 1 2 3    4 5 6 7 probability 0.058 0.121 0.161 0.178 0.217 0.128 0.084 0.053 a) the mean is _______ b) the variance is ____________ c) the standard deviation is_____________  
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT