Please explain to me on how you got that answer, thank you!
As we are to deal with only the close prices and add 0.5 to each of them as asked in the question, we ignore rest of the columns.
a) Test for Two Variances: A, B :
Null hypothesis σ(A) / σ(B) = 1
Alternative hypothesis σ(A) / σ(B) ≠ 1
Significance level α = 0.05
Test :
method | df1 | df2 | test statistic | p-value |
Levene | 1 | 17 | 0.1 | 0.757 |
STEPS : stat-> basic statistic-> 2 variance
CONCLUSION : we accept the null hypothesis as p-value=0.757>0.05 and conclude there is no significant difference in variance between the two data sets.
b)
as p-value=0.046<0.05, we reject the null hypothesis and conclude that the two groups have significant difference in their means. i.e smoking affects the weights of newborn on average.
steps : stat-> basic statistics-> 2 sample t. select appropriate columns in the boxes.click ok.
c) 95% CI for difference: (-3.278, -0.038)
steps: as above. ( CI is also given in the picture)
1. You will need your ticker code (show your ticker code on your homework and include a printout ...
MINICASE 1
You need to show your working notes in excel for credit. You
must submit your work using excel files (with .xls or .xlsx for
credit). This assignment will require you to analyze time series of
monthly returns.
MONTHLY data for the period of 01/01/2015 – 08/31/2018
− S&P 500 Index (ticker: ^GSPC)
− General Electric Company (ticker: GE)
− Intel Corporation (ticker: INTC)
− Chevron Corporation (ticker: CVX)
− Apple Inc. (ticker: AAPL)
Calculating Returns:
Use the ‘Adj...