Question

In: Statistics and Probability

I have Stock Return of two Companies MSFT(Microsoft) and APPL (Apple).It is mentioned in the given...

I have Stock Return of two Companies MSFT(Microsoft) and APPL (Apple).It is mentioned in the given Table.The Question is : '

''We would also like to check whether both stocks (Apple and Microsoft) have the same return on average. Using the confidence interval approach, perform and present an appropriate hypothesis test at the 5% level of significance, and interpret your result. Which stock would you prefer and why? [Hint: Hypothesis test about two population means. Zero marks if you test using an approach other than the confidence interval approach.]

Note:the Calculations should be made using EXCEL

'

R_MSFT (%) R_APPL (%)
0.00 0.00
1.33 7.02
1.84 2.73
3.44 2.83
5.13 6.97
2.03 -1.72
1.26 6.95
1.82 9.64
-2.89 -7.46
-13.95 5.96
8.19 9.21
-7.55 -3.19
17.92 0.58
-3.73 4.02
-5.96 -3.79
5.62 -3.35
-7.05 -7.16
1.69 -2.35
17.34 8.01
3.20 -1.01
2.06 -11.68
-0.71 -7.82
-7.95 -0.67
8.20 11.97
-10.21 -15.07
6.09 6.32
-3.51 -4.36
10.23 8.62
1.37 1.80
0.24 6.34
3.95 0.43
0.57 -2.70
3.07 4.68
3.96 4.66
-1.04 12.12
2.90 4.75
3.87 -0.01
2.00 6.15
-1.31 -5.89
5.32 3.22
2.81 9.77
-0.38 -6.21
11.03 9.24
1.18 1.65
1.61 -1.54
10.50 -1.07
-1.31 6.19
-2.70 -5.98
2.44 -1.51
5.53 12.29
-0.23 -0.95
7.30 2.76
5.72 17.92
1.80 -0.83
-6.84 -3.10
3.75 -20.34
-8.78 -12.41
2.78 5.37
7.02 3.95
5.14 9.26
10.20 5.49

Solutions

Expert Solution

The calculation in the excel are give below

R_MSFT (%) R_APPL (%)
0 0
1.33 7.02
1.84 2.73
3.44 2.83
5.13 6.97
2.03 -1.72
1.26 6.95
1.82 9.64
-2.89 -7.46
-13.95 5.96
8.19 9.21
-7.55 -3.19
17.92 0.58
-3.73 4.02
-5.96 -3.79
5.62 -3.35
-7.05 -7.16
1.69 -2.35
17.34 8.01
3.2 -1.01
2.06 -11.68
-0.71 -7.82
-7.95 -0.67
8.2 11.97
-10.21 -15.07
6.09 6.32
-3.51 -4.36
10.23 8.62
1.37 1.8
0.24 6.34
3.95 0.43
0.57 -2.7
3.07 4.68
3.96 4.66
-1.04 12.12
2.9 4.75
3.87 -0.01
2 6.15
-1.31 -5.89
5.32 3.22
2.81 9.77
-0.38 -6.21
11.03 9.24
1.18 1.65
1.61 -1.54
10.5 -1.07
-1.31 6.19
-2.7 -5.98
2.44 -1.51
5.53 12.29
-0.23 -0.95
7.3 2.76
5.72 17.92
1.8 -0.83
-6.84 -3.1
3.75 -20.34
-8.78 -12.41
2.78 5.37
7.02 3.95
5.14 9.26
10.2 5.49
xbar=average(R_MSFT) ybar=average(R_APPL)
1.9237 1.4213
s2x=var(R_MSFT)) s2y=var(R_APPL)
35.3060 50.9013
S=sqrt(((n-1)*s2x + (n-1) * s2y)/(n+n-2))
6.5653


Related Solutions

Question #: Lebron James contains the monthly return data for Microsoft (MSFT), IBM (IBM), Apple (AAPL)...
Question #: Lebron James contains the monthly return data for Microsoft (MSFT), IBM (IBM), Apple (AAPL) and Hewlett-Packard (HPQ) for the period 2007/1- 2016/12. Month MSFT IBM AAPL HPQ 20070131 0.033490 0.020587 0.010490 0.050740 20070228 -0.083927 -0.059607 -0.013064 -0.090804 20070330 -0.010650 0.014203 0.098097 0.022109 20070430 0.074273 0.084341 0.074158 0.049826 20070531 0.028393 0.046864 0.214339 0.084718 20070629 -0.039756 -0.012664 0.007005 -0.022096 20070731 -0.016288 0.051306 0.079646 0.031600 20070831 -0.005519 0.058202 0.051002 0.072127 20070928 0.025409 0.009512 0.108247 0.010537 20071031 0.249491 -0.014261 0.237701 0.037959 20071130...
You estimate that the expected return of MSFT stock is 4%, and standard deviation of MSFT stock is 9%.The expected return of AAPL stock is 3%,and
You estimate that the expected return of MSFT stock is 4%, and standard deviation of MSFT stock is 9%.The expected return of AAPL stock is 3%,and standard deviation of MSFT stock is8%. If the correlation between AAP Lreturns and MSFT returns is 80%,what is the expected return and standard deviation of a portfolio with $4,000 invested in MSFT and $6,000 invested in AAPL? 
Discuss Apple's (AAPL) and Microsoft (MSFT) beta and relate to the volatility of the stock and...
Discuss Apple's (AAPL) and Microsoft (MSFT) beta and relate to the volatility of the stock and its returns over a six month period.
Apple Inc., Microsoft Corp., Berkshire Hathaway, and Facebook have all been identified as companies that have...
Apple Inc., Microsoft Corp., Berkshire Hathaway, and Facebook have all been identified as companies that have accumulated substantial sums of cash. For this discussion: Select one of these companies and review their latest Balance Sheet and Statement of Cash Flows. Suggest at least two (2) advantages and two (2) disadvantages of companies accumulating cash hoards. Provide a rationale for your suggestion.
The annual data on stock prices and dividends for Microsoft Corporation(MSFT) is as follows: Year Price...
The annual data on stock prices and dividends for Microsoft Corporation(MSFT) is as follows: Year Price (Beginning of the Year) Price (End of the Year) Dividends (End of the Year ) 2005 26.28 28.15 0.29 2006 28.15 30.86 0.33 2007 30.86 32.60 0.37 2008 32.60 17.10 0.41 2009 17.10 28.18 0.46 2010 28.18 27.73 0.55 2011 27.73 29.53 0.68 2012 29.53 27.45 0.83 2013 27.45 37.84 0.97 2014 37.84 46.45 1.15 What will be the IRR if the stock is...
Given the following companies sales of 4 brands below Microsoft Apple Alibaba Huawei 41 35 48...
Given the following companies sales of 4 brands below Microsoft Apple Alibaba Huawei 41 35 48 40 45 52 32 37 46 53 41 43 35 30 24 26 28 31 33 27 36 35 27 25 c) Use the analysis of variance to calculate the F-test d) Make a statistic decision about the Null hypothesis
Each student will select two (2) competing fortune 500 Companies, i.e. Microsoft and Apple, and do...
Each student will select two (2) competing fortune 500 Companies, i.e. Microsoft and Apple, and do a complete SWOT analysis of each. Upon the completion of each SWOT analysis, the student will discuss in detail the area(s) they feel each company has a competitive advantage and what area(s) each company may have an opportunity for growth. I NEED HELP CAN SOMONE DO THIS PLEASE The 2 companies I picked is Coca Cola and Pepsi
Obtain monthly close prices of Microsoft (symbol: MSFT) adjusted for stock splits and dividends during December...
Obtain monthly close prices of Microsoft (symbol: MSFT) adjusted for stock splits and dividends during December 1989 – December 2019 from Yahoo Finance (finance.yahoo.com). Using Excel, compute monthly returns during January 1990 – December 2019. From these returns, compute arithmetic and geometric return averages over the entire period. Report your answers and confirm that arithmetic average is greater than geometric average. Guideline: 1. Yahoo Finance allows you to download the data in a spreadsheet. 2. At Yahoo Finance, go to...
The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and...
The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and NVidia (NVDA) for the first half of 2017. Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 MSFT 68.93 69.84 68.46 65.86 63.98 64.65 NVDA 144.56 144.35 104.3 108.93 101.48 109.18 Create a formula to calculate the monthly rate of return during the first semester of 2017 and for each company. Format the results as percentages with two decimal...
1.    The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and...
1.    The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and NVidia (NVDA) for the first half of 2017. Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 MSFT 68.93 69.84 68.46 65.86 63.98 64.65 NVDA 144.56 144.35 104.3 108.93 101.48 109.18 a)    Enter the data, as shown, into a worksheet and format the table as shown. b)   Create a formula to calculate the monthly rate of return during the first semester...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT