Question: Question 4 6 points Save An What is the mean, variance and standard deviation of APPL stock monthly returns based on the price data in

Question 4 6 points Save An What is the mean, variance

Question 4 6 points Save An What is the mean, variance and standard deviation of APPL stock monthly returns based on the price data in the attached file above? O a. Mean-0.9896;Variance-0.0076;Standard Deviations 8.7296 O b. Mean-1.24% ; Variance-0.0067; Standard Deviation-8.2% C. Means 0.57% ; Variance-0.0027;Standard Deviation 5.15% O d. Mean_ 2.3%,Variance-0.032:Standard Deviation-17,89% X AAPL Price dat.. E13 1 Date 2 12/12/2014 110.379997 3 1/2/2015 117.160004 42/2/2015 128.460007 5 3/2/2015 124.43 6 4/1/2015 125.150002 7 5/1/2015 130.279999 8 6/1/2015 125.43 9 7/1/2015 121.300003 10 8/3/2015 112.760002 11 9/1/2015 110.300003 12 10/1/2015 13 11/2/2015 118.300003 14 12/1/2015 118.230003 Close A Moving to another question will save this response. uestion 4 of 16 119.5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

This is complete write up of your portfolio formation in a Word file, with calculations copied and pasted in it from your Excel file. 1. Stocks of Five publicly traded companies from different...

This is complete write up of your portfolio formation in a Word file, with calculations copied and pasted in it from your Excel file. 1. Select the stocks of three publicly traded companies from...

SOC 332 W2 Q2 Chapters 3 & 4 Question 1 of 20 A correlation describes the relationship between two: A.equal-interval numeric variables 1.0 Points B.scatterplots C.standard deviations D.horizontal...

Question 6 Points F/'// in the blanks: Find the variance and standard deviation of the following data set from a sample: 106, 121, 152, 234, and 347. Sample variance = Sample standard deviation =...

) You would like to build an equally-weighted portfolio of four stocks: A, B, C, and D. The mean and variance-covariance information of the four stocks are given in the data excel file. 1) (4 points)...

please help me answer question by excel 1. Each team member will pick a company to analyze. That way, teams with 5 members will be working with portfolios of 5 different stocks, and teams with 4...

I pick Starbuck company. My team members pick Amazon, AT&T companies Collect price information for each stock and the S&P 500 index from Yahoo! Finance (http://finance.yahoo.com) as follows: Enter...

Hello, I need help with the highlighted questions(I, J, and K). Also, can you please explain how you completed the regression part. The assignment is Week 5 assignment. The other documents are from...

How does HR forecasting process help an organization to get right people at the right time? Real world examples will be appreciated to justify your answer. How do the environmental and organizational...

Myrtle Coast Corporation has a $35,000 operating loss during the current year. Not included in the loss is a $40,000 dividend it received from a corporation in which it owns a 15% interest. Identify...

In 1 9 8 5 , the exchange rate between the U . S . dollar and the Japanese yen was $ 1 = 2 6 2 yen; in 2 0 2 2 , the rate was $ 1 = 1 3 1 yen. Which one of the following might be a plausible...

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

Health status earlier in life is a good predictor of wealth later in life.

According to Smith (1999), nearly all of the differences in health outcomes between rich and poor in America can be attributed to differences in access to medical care.

The thrifty phenotype hypothesis states that early-life events after birth have a strong influence on health status even in adulthood.