Calculate the mean daily return, variance and standard deviation for both stocks show your work?

AAPL	BABA
-0.0148	-0.0064
0.012538	-0.00155
0.006178	0.012908
0.015207	-0.00189
0.008281	0.004847
0.00406	0.002824
-0.00744	0.024519
-0.00065	0.050842
0.002316	0.070611
0.012017	-0.01099
-0.00091	-0.00525
-0.00146	0.003517
-0.00128	0
0.002567	-0.00144
-0.00777	-0.01249
0.003133	0.001464
-0.00753	-0.01994
-0.00426	0.000639
-0.00586	0.011922
-0.00112	-0.00189
-0.00768	0.011804
0.000943	0.012396
0.005938	0.002366
0.009369	0.018785
-0.00028	0.045642
0.006128	-0.01407
-0.02621	0.002443
-0.02265	-0.02876
0.022399	0.011845
0.023805	-0.00516
0.035387	0.021141
0.033998	0.020019
-0.00562	0.001819
-0.01166	-0.01539
-8.8E-05	-0.01621
-0.00018	0.045777
0.009423	0.031698
-0.01666	-0.01509
0.001508	-0.0169
0.00186	0.022382
0.007605	0.004526
-0.01553	-0.02943
0.007755	0.002274
-0.00469	-0.00388
0.004266	0.000664
0.000443	0.01432
0.00743	0.001122
0.001493	-0.01009
0.017447	0.022736
0.002154	-0.02933
0.008942	-0.0153
-0.00307	-0.01419
0.005556	-0.00294
-0.00068	0.00972
-0.00068	0.004862
-0.00298	0.005709
-0.00051	-0.00077
-0.00393	0.000867
0.009005	0.005388
0.0051	-0.00268
-0.02249	-0.01382
-0.0096	-0.00389
-0.00664	-0.0044
-0.00158	-0.00235

Solutions

Expert Solution

Formulas Used:-

Mean	=AVERAGE(B1:B65)	=AVERAGE(C1:C65)
Variance	=VAR(B2:B65)	=VAR(C2:C65)
std. deviation	=SQRT(B68)	=SQRT(C68)

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

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

BAFB-0.01209-0.009810.002052-0.00471-0.0050.0151010.0039630.0063530.0034920.0008790.003253-0.00160.005702-0.001440.0054430.000160.000752-0.000160.01172-0.007850.002525-0.00484-0.002070.0086780.002078-0.0037-0.00415-0.002820.0040910.004775-0.00630.001772-0.00634-0.00716-0.002330.00332-0.005640.0086370.0050670.012644-0.01573-0.00553-0.01040.0022250.0034760.0003960.00970.0026950.0139520.025452-0.002630.0101750.00196-0.00595-0.03288-0.024330.0123710.01251-0.01045-0.0115-0.008470.0044020.0007830.004539-0.008370.005610.006156-0.003250.002432-7.8E-050.0216760.0101060.0100340.001077-0.00068-0.0163-0.00918-0.005080.0057440.010840.006930.004196-0.00908-0.008820.0054190.0014050.0048580.003898-0.00098-0.00450.0182230.002184-0.001780.002102-0.004240.0019420.0148670.009691-0.01546-0.01044-0.004340.0013190.001652-0.009530.00090.0004690.003745-0.002660.0082090.0080760.0079940.011978-0.0025-0.00085-0.001550.0159230.0134190.0091620.011422-0.007430.0469-0.00945-0.01532-0.0103-0.002090.012337-0.00406-0.00228calculate the mean daily return, Variance and standard deviation for each stock?

Please show all your work/steps. Thank you. Calculate the mean, variance, and standard deviation of returns...

Please show all your work/steps. Thank you. Calculate the mean, variance, and standard deviation of returns for: (a) CAT & PG individually, and (b) an equally-weighted portfolio of the two stocks. For the portfolio, 1st compute the monthly returns. Then, compute the mean, variance, and standard deviation calculations with Excel’s Data Analysis “Descriptive Statistics” function, “Summary Statistics” (in the function dialogue box). Compare the return and risk of the three assets. Monthly Stock Returns Year Month S&P 500 CAT PG...

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

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 descriptive statistics BY HAND (showing your work) (variance , standard deviation, range, average, dispersion,...

Calculate the descriptive statistics BY HAND (showing your work) (variance , standard deviation, range, average, dispersion, median, mode)that we've covered in class for the two following variables: Variable X Variable Y 4 40 2 36 8 49 6 38 10 56 5 58 3 39 9 53 10 34 9 47

PLEASE SHOW WORK A.What is the standard deviation of returns for Stocks A and B?RA =...

PLEASE SHOW WORK A.What is the standard deviation of returns for Stocks A and B?RA = 23.5% RB = 14.6% σA = 13.05% σB = 4.98% State Probability Expected Return Stock A Stock B Expansion 30% 40% 22% Normal 60% 20% 12% Recession 10% -5% 8% B.What is the covariance of returns between stocks A and B?σA,B = 60.9 %2 C.What is the correlation coefficient?ρA,B = 0.94

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

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

Subjects