Reference no: EM132385398
DNSC 2001 –Business Analytics II
Assignment
Question 1: Portfolio Optimization:
In the accompanying data file, you are given monthly returns of four stocks: JCPenney, Amoco, GM and JPMorgan for 240 months during the 20 year period from 1975 to 1994. We are interested in developing optimal portfolios (in Markowitz' sense) using only the last 15 years
(1980-1994) of data. In so doing, you will go through the following steps and present your results in a report.
(a) Using JMP IN or EXCEL analyze each of the four stock returns and estimate the mean, variance and standard deviation of the monthly returns. In so doing, identify the stocks with the maximum expected return and minimum variance (or standard deviation).
(b) Using JMP IN or EXCEL estimate the correlation between each pair of stocks and identify whether any of the stocks are negatively correlated.
(c) Using the results from parts (a) and (b), develop a spreadsheet model where you obtain the covariance for each pair of stocks (as we did in class).
(d) Now assume that a particular investor will allocate his/her monthly funds equally between these four stocks. Obtain the monthly portfolio mean and variance (or standard deviation) for this investor.
(e) Consider another investor who allocates funds equally between Amoco and JPMorgan (that is, nothing is invested in JCPenney and GM). Compare this portfolio's mean and variance (or standard deviation) with that portfolio in part (d). That is, discuss which one has a higher average return and which one has a higher standard deviation (or variance).
(f) Using EXCEL solver find the minimum variance portfolio that guarantees at least an average (mean) monthly return of 0.0125. How are the funds allocated in this portfolio ? Compare the average return and standard deviation of this portfolio with that of the investor in
part (d).
(g) Find the minimum variance portfolios (separately) with at least an average return of 0.013, an average return of 0.0135, and an average return of 0.014. Compare the means and standard deviations of these portfolios as well as their optimal allocations (including the one in part
(f)). What do you observe as you are increasing the minimum average return requirement in the portfolio?
Question 2:
Analyze the Servpro case and write up a report presenting your analysis.
Question 3:
In order to examine the differences in ages of teachers among five school districts, an educational statistician took random samples of six teachers’ ages in each district. The data are listed below.
Ages of Teachers among Five School District
|
1
|
2
|
3
|
4
|
5
|
|
41
|
39
|
36
|
45
|
53
|
|
53
|
48
|
28
|
37
|
55
|
|
28
|
41
|
29
|
46
|
49
|
|
45
|
51
|
33
|
48
|
56
|
|
40
|
49
|
27
|
51
|
48
|
|
59
|
50
|
26
|
49
|
61
|
Test at the 10% significance level to determine if differences in teachers’ ages exist among the five districts. (State your null and alternative hypotheses, the test statistic, p-value, and the conclusion).
Question 4:
A recent study of educational levels of 2000 voters and their political party affiliations in a Midwestern state showed the results given in the table below. Use the 5% significance level and test to determine if party affiliation is independent of the educational level of the voters.
Attachment:- Portfolio Data.rar