# Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.

6 Pages

### stat107_Homework3_Solutions

Course: STATS 107, Spring 2012
School: Harvard
Rating:

Word Count: 764

#### Document Preview

107 Stat Spring 2012 Homework #3 Solutions 1. The Portfolio which invests 35.28% in stock A and the rest in stock B gives a higher mean return (42.62%) for the same standard deviation. This is shown below: stock A stock B Portfolio mean 14.25% 62.72% 45.62% variance 6.38% 14.43% 4.32% sigma 25.25% 37.99% 20.78% covariance -5.52% weights 0.352773 0.647227 1 2. A single run gave a correlation of -0.006206696. A...

Register Now

#### Unformatted Document Excerpt

Coursehero >> Massachusetts >> Harvard >> STATS 107

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
107 Stat Spring 2012 Homework #3 Solutions 1. The Portfolio which invests 35.28% in stock A and the rest in stock B gives a higher mean return (42.62%) for the same standard deviation. This is shown below: stock A stock B Portfolio mean 14.25% 62.72% 45.62% variance 6.38% 14.43% 4.32% sigma 25.25% 37.99% 20.78% covariance -5.52% weights 0.352773 0.647227 1 2. A single run gave a correlation of -0.006206696. A more comprehensive summary is given below for 10000 runs of this scenario: Min. 1st Qu. Median Mean 3rd Qu. Max. -6.08E-02 -1.15E-02 -2.82E-05 1.95E-04 1.21E-02 6.66E-02 For any single run, the correlation is close to zero. However, it is obvious that the investing schemes are dependent since we know that the daily returns for both managers are exactly the same in magnitude. 3. a) and b) QUESTION 1 Mean Return (%) 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 26.00 Unrestricted Standard Deviation (%) 22.81 21.48 20.29 19.26 18.41 17.77 17.36 17.20 17.30 17.65 18.23 19.04 20.03 21.18 22.48 23.88 25.39 QUESTION 2 Restricted Standard Deviation (no short sales) (%) No Solution 22.33 20.64 19.36 18.42 17.77 17.36 17.20 17.41 18.36 20.07 22.52 No Solution No Solution No Solution No Solution No Solution 30.00 25.00 20.00 15.00 10.00 5.00 0.00 0.00 5.00 10.00 Efficient Frontier Question 3a Question 3b 15.00 20.00 25.00 30.00 In 3b, some of the returns do not have an optimal solution when we are restricted to no short sales. This is because those mean returns lie outside the range of mean stock returns. (i.e. they are either smaller than the smallest mean stock return or larger than the largest) and thus no convex combination (i.e. the weights are between 0 and 1) of the stocks will ever achieve those mean returns. c) Global Minimum Variance portfolio: US 0.3757 Germany 0.1971 UK 0.0725 Japan 0.2075 Australia 0.1144 Canada 0.0347 France -0.0019 weights Portfolio Variance Portfolio std Portfolio expected return 295.76 17.20% 17.12% d) Maximum Return Portfolio (with no short sales): If short sales are not permitted, the maximum return that can be achieved will be the return of the stock with the maximum return. This will be the mean return of Germany. The volatility is the standard deviation. The details are given below. Portfolio Variance Portfolio std Portfolio expected return 625.00 25.00 21.70 Maximum Return Portfolio (with short sales): If short sales are permitted, the maximum return that can be achieved is undefined due to the weights being infinite (In Solver, there will be no convergence, and any weights obtained are only due to finite machine precision). The volatility here is likewise undefined. The result from Solver is however given here. Portfolio Variance Portfolio std Portfolio expected return 4197602989166900000.00 2048805258.97 674846681.37 e) short With sales permitted, the following were obtained for the Tangent portfolio: Portfolio Variance Portfolio std Portfolio expected return Riskless rate: Sharpe ratio: 442.14 21.03 22.87 5.5 0.826177 With the following weights, US Germany UK Japan Australia Canada France weights 0.6462 0.5400 0.2629 0.1979 0.1495 -0.6360 -0.1605 f) With no short sales, the Tangent portfolio is given by: Portfolio Variance Portfolio std Portfolio expected return Riskless rate: Sharpe ratio: 339.90 18.44 19.06 5.5 0.735257 With these weights: US 0.2245 Germany 0.4417 UK 0.1769 Japan 0.1546 Australia 0.0023 Canada 0.0000 France 0.0000 weights It can be seen that the weights change a lot from 3e. g) i) We can't create such a portfolio since the desired standard deviation (12%) is smaller than the standard deviation of our minimum variance portfolio (even with short sales allowed). ii) This problem simply needs us to find the weights w for the client's portfolio, such that: Portfolio= (1-w)*Riskfree + w*Tangent portfolio ...and Std(Portfolio)=12% Where the Tangent portfolio is the same one obtained in 3f. We can easily use solver to obtain this by maximizing the Portfolio mean return subject to the constraints that: 1. w is positive; and 2. std(portfolio)=12 This produces the following results: weights 0.650888009 0.349111991 T-portfolio Riskless i.e. Invest 65.09% of your capital in the Tangent portfolio and use the rest to buy the bank Certificate of Deposit. iii) Portfolio std Portfolio mean return 12.00 14.32 h) i) Yes this is easily obtained in solver. Note that there won't be a unique solution, since the standard deviations will be different for different weights combinations that lead to a mean return of 30%. For this question, they are all correct. However the optimal (minimum variance) weight combination is given below: US 0.9811 Germany 0.9643 UK 0.4989 Japan 0.1864 Australia 0.1932 Canada -1.4669 France -0.3569 weights .. with the following mean and volatility: Portfolio Variance Portfolio std Portfolio expected return 1029.74 32.09 30.00 ii) Somewhat similar to 3g, this problem simply needs us to find the weights w for the client's portfolio, such that: Portfolio= (1-w)*Riskfree + w*Tangent portfolio ...and mean(Portfolio)=30% Where the Tangent portfolio is the same one obtained in 3e (NOT 3f this time). We can easily use solver to obtain this by minimizing the Portfolio standard deviation subject to the constraint that: 1. mean(portfolio)=30 Note here that w is unconstrained. This produces the following results: weights 1.410246391 -0.410246391 T-portfolio Riskless i.e. borrow 41.02% of your capital (or short the bank Certificate of deposit) and then add that to your original capital and invest everything in the tangent portfolio. iii) Portfolio std 29.65 Portfolio mean return 30.00
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Harvard - STATS - 107
Stat 107 Spring 2012Harvard UniversityHomework 2 Solutions 1. GMC Envoys See hw2 q1.R for code. Our goal is to find the order size S that gives us the highest average profit across simulations of D. Given consumer demand D and an order size S, the deale
Harvard - STATS - 107
Interest Initial Deposit Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Value8% \$155\$167.40 \$180.79 \$195.26 \$210.88 \$227.75 \$245.97 \$265.64 \$286.89 \$309.85 \$334.63 \$361.40 \$390.32 \$421.54 \$455.27 \$491.69 \$531.02 \$573.50 \$619.38 \$668.93 \$722.4
Harvard - STATS - 107
Stat 107 Spring 2012 Homework 1 Solutions1) 2) 3) 4) 5) See Excel file &quot;Problem 1&quot; See Excel files &quot;Problem 2.1&quot; and &quot;Problem 2.2&quot; See Excel file &quot;Problem 3&quot; See Excel file &quot;Problem 4, 5&quot; See Excel file &quot;Problem 4, 5&quot;6) Note: in this problem, we used th
Harvard - STATS - 107
Harvard - STATS - 107
Harvard - STATS - 107
#1) Style Analysislibrary(quantmod)getSymbols(&quot;VWNDX&quot;,from=&quot;2009-01-01&quot;,to=&quot;2012-03-31&quot;)getSymbols(&quot;VDIGX&quot;,from=&quot;2009-01-01&quot;,to=&quot;2012-03-31&quot;)getSymbols(&quot;VHGEX&quot;,from=&quot;2009-01-01&quot;,to=&quot;2012-03-31&quot;)getSymbols(&quot;VITAX&quot;,from=&quot;2009-01-01&quot;,to=&quot;2012-03-31&quot;)VW
Harvard - STATS - 107
#Pairs Trading Companies:#Home Depot (&quot;HD&quot;) and Lowes (&quot;LOW&quot;)#Papa Johns (&quot;PZZA&quot;) and Dominoes (&quot;DPZ&quot;)#Walmart (&quot;WMT&quot;) and Target (&quot;TRGT&quot;)#McDonalds (&quot;MCD&quot;) and Taco Bell/KFC/Pizza Hut (&quot;YUM&quot;)#Dell (&quot;DELL&quot;) and HP (&quot;HPQ&quot;)#Coke (&quot;COKE&quot;) and Pepsi (&quot;
Harvard - STATS - 107
#1)library(quantmod)f=file.choose() #choosing a file that has the ticker namesthis one has 500 of them!crap=read.csv(f)tickers=as.character(crap[,1])getSymbols(&quot;SPY&quot;, from = &quot;2009-03-01&quot;, to = &quot;2012-02-29&quot;,auto.assign = T)SPY.monthret=monthlyReturn(
Harvard - STATS - 107
#1)#Monthly Returns over last 10+ yearslibrary(quantmod)getSymbols(tickers, from = &quot;2002-01-01&quot;, to = &quot;2012-02-01&quot;) stocks=list(IBM,MCD,KFT,F)means=100*apply(cbind(monthlyReturn(IBM),monthlyReturn(MCD),monthlyReturn(KFT),monthlyReturn(F),2,mean)sds
Harvard - STATS - 107
### Section 1 Code:# Playing with R and quantmod###R can do math:(10.5-12)/(5/sqrt(30)exp(2)sin(pi/6)#R has some built-in functions, that you can pass options (aka, parameters in a comp. sci. sense) to:log(10)log(10, base = 10)#You can store
Harvard - STATS - 107
Stat 107Section #10April 18 &amp; 19, 2012Logistics Kevin Rader, krader@hsph.harvard.edu. Sections: Wed 1-2pm (SC-B10), Thurs 12-1pm (SC-216).Office Hours (SC-602): Wed 2-3pm, Thurs 2-3pm, Fri 1-3pm, Mon 2-3pm, Tues 2-3pm Required Lecture on Thursday (W
Harvard - STATS - 107
Stat 107Section #9April 11 &amp; 12, 2012Logistics Kevin Rader, krader@hsph.harvard.edu. Sections: Wed 1-2pm (SC-B10), Thurs 12-1pm (SC-216).Office Hours (SC-602): Wed 2-3pm, Thurs 1-2pm, Fri 2-3pm Project Proposal: is due Thurs evening by 11:59pm. Plea
Harvard - STATS - 107
Stat 107Section #8April 4 &amp; 5, 2012Logistics Kevin Rader, krader@hsph.harvard.edu. Sections: Wed 1-2pm (SC-B10), Thurs 12-1pm (SC-216).Office Hours (SC-602): Wed 2-3pm, Thurs 1-2pm, Fri 2-3pm, Tues (April 10): TBD Homework #5 is due Tuesday night by
Harvard - STATS - 107
Stat 107Section #7March 28 &amp; 29, 2012Logistics Kevin Rader, krader@hsph.harvard.edu. Sections: Wed 1-2pm (SC-B10), Thurs 12-1pm (SC-216).Office Hours (SC-602): Wed 2-3pm, Thurs 1-2pm, Fri 2-3pm Homework #5 is due Tuesday, April 10, before midnight.
Harvard - STATS - 107
Stat 107Section #6March 21 &amp; 22, 2012Logistics Kevin Rader, krader@hsph.harvard.edu. Sections: Wed 1-2pm (SC-B10), Thurs 12-1pm (SC-216).Office Hours (SC-602): Wed 2-3pm, Wed 3-5pm (this week only), Thurs 1-2pm, Fri 2-3pm Homework #4 is due Tuesday
Harvard - STATS - 107
Stat 107Section #5February 29 &amp; March 1, 2012Logistics Kevin Rader, krader@hsph.harvard.edu. Sections: Wed 1-2pm (SC-B10), Thurs 12-1pm (SC-216).Office Hours (SC-602): Wed 2-3pm, Thurs 1-2pm, Fri 2-3pm Homework #3 is due Friday night before midnight
Harvard - STATS - 107
Stat 107Section #4February 22 &amp; 23, 2012Logistics Kevin Rader, krader@hsph.harvard.edu. Sections: Wed 1-2pm (SC-B10), Thurs 12-1pm (SC-216).Office Hours (SC-602): Wed 2-3pm, Thurs 1-2pm, Fri 2-3pm Homework #3 is due next Friday night, Mar 2, before
Harvard - STATS - 107
Stat 107Section #3February 15 &amp; 16, 2012Logistics Kevin Rader, krader@hsph.harvard.edu. Sections: Wed 1-2pm (SC-B10), Thurs 12-1pm (SC-216).Office Hours (SC-602): Wed 2-2:30pm, Thurs 1-1:30, Fri 2-3pm Homework #2 is due on Friday night, Feb 17th, be
Harvard - STATS - 107
Stat 107Section #2February 7-9, 2012Logistics Kevin Rader, krader@hsph.harvard.edu. Sections: Wed 1-2pm (SC-B10), Thurs 12-1pm (SC-216).Office Hours (SC-602): Wed 2-3pm, Fri 2-3pm Course website: my.harvard.edu/k85336. All section material will be
Harvard - STATS - 107
Stat 107Section #1February 1 &amp; 2, 2012Logistics Kevin Rader, krader@hsph.harvard.edu. Office hours (SC-602): Wed 2-3pm, Fri 1-2pm (TBD in future) Course website: my.harvard.edu/k85336. All section material will be posted under 'Sections Kevin's Sect
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 25: Behavioral Finance and Wrap Up1Cognitive BiasesFundamental Limitations InHuman Mental ProcessesSimple Rules Of Thumb LeadingTo Faulty JudgmentsSimilar To Optical IllusionsPhysic
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 23: Technical Analysis1IntroductionTechnical analysis is the attempt to forecaststock prices on the basis of market-deriveddata.Technicians (also known as quantitativeanalysts or cha
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 22: A brief time on time series analysis1Time-Series Data and DependenceTime-series data are simply a collection ofobservations gathered over time.All the finance data weve looked at h
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 21: VaR and Resampling1Value at RiskSimply put, assume you have a \$1,000,000portfolio (very cool! )You ask: What is the probability that I'd lose\$X (OR MORE) over the next M months?M
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 19: Value at Risk1Playing with PerformanceAnalyticsSome R CodegetSymbols(&quot;AAPL&quot;,from=&quot;2009-01-01&quot;)getSymbols(&quot;JNJ&quot;,from=&quot;2009-01-01&quot;)getSymbols(&quot;SPY&quot;,from=&quot;2009-01-01&quot;)aaplret=monthl
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 18: Performance Analytics, part 21Style AnalyticsIs a forthcoming package in R that will allowone to do style analysis; in particular rollingstyle analysis.Recall, we assume the style
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 17: Performance Analytics, part 112Pairs Trading ReduxWe have you backtest a pairs tradingstrategy on this weeks homework.Based on an idea presented in a Brazilianpaperpaper on the
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 16: Pontificating about the Project and Beta1The Class ProjectImportant DatesApril 10th: project proposalMay 1st: project dueThere are least two directions one can takefor the final
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 15: Single Index Models, part 21Oh that Wayne.2Whats in the worksDear Prof. Parzen,I hope that you enjoyed the spring break. The IOP, Harvard Dems,Libertarians, and I have been talki
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 13: The Single Index Model1The World is Complicated2Systemic RiskFinancial Stability Board: a risk of disruption to financialservices that is caused by an impairment of all or parts o
Harvard - STATS - 107
STATE STREET ASSOCIATESOutlineSystemic risk:Applications for investors and policymakersThe absorption ratio as a measure of implied systemic riskThe absorption ratio and the pricing of risky assetsMark KritzmanWindham Capital ManagementMIT Sloan S
Harvard - STAT - 107
Stat 107: Introduction to Business and Financial StatisticsClass 10: Portfolios, part 31Recall: The Efficient FrontierMaximumReturn PortfolioExpected ReturnEfficient PortfoliosEfficientFrontierInefficient PortfoliosMinimum Variance PortfolioRi
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 9: Portfolios, part 21Return on a portfolioAssume we have n stocks of interestLet Ri be a random variable denoting thereturn of stockHence the return on a portfolio is given bytheth
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 6: Simulation (cont) andPortfolios, part 11Simulating Two AssetsIn the previous examples, we assumed wewere simply investing in one asset, themarket index.But that was purely for eas
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 4: Monte Carlo Simulation1Historical NoteThe name Monte Carlo simulation comesfrom the computer simulations performedduring the 1930s and 1940s to estimate theprobability that the cha
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 4: Statistics Review, Part II1As January goes so does the yearhttp:/blog.stocktradersalmanac.com/post/As-January-Goes-so-Goes-the-Year 2The Data3Review of Basic Statistics (cont)Rand
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 3: Statistics Review, Part I1Homework DiscussionDue Midnight Friday night via emailstat107spring2012@gmail.comIdea of Momentumpapers on websiteetfreplay.com200 day moving average (mo
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 2: Computing Discussion1What to ReadSomeone last time asked what web sites Iread. Too many is the short answer!But an interesting study was recentlyreleased that is good to look at ca
Harvard - STATS - 107
Stat 107: Introduction to Business and Financial StatisticsClass 1: Introduction1Where Am I?Michael Parzen: Sci 300bOffice Phone: 617-495-8711Google Voice: 617-942-0621Email: mparzen@stat.harvard.edu2Who Am I?3WarningThis is the first second(!
Texas San Antonio - BIO - 1404
Biology Notes 4/17/12From Gene to proteinTranscription&amp;TranslationiClicker: Which of the following is the best example of gene expression?-mouse fur color resultsfrom pigment formed by gene encoded enzymesBacterial Cell:-Bacteria can simultaneously
Texas San Antonio - BIO - 1404
Biology Notes 4/19/12Regulation of gene expression-Bacterial Operons-Repressible tryptophan operon-Inducible lactose operon-Differential Gene Expression in EukaryotesBacterial Operon Modelprecursor-&gt;enzyme 1-&gt;enzyme 2-&gt;enzyme 3-&gt;tryptophanoperon-a
Texas San Antonio - SOC - 1013
Sociology Notes 4/16/12 Religion and SociologyWhat is religion? Set of beliefs adhered by the members of a community, incorporating symbols regarded with a sense of awe or wonder together with ritual practicesTheism A belief in on or more supernatura
Texas San Antonio - SOC - 1013
Sociology Notes 4/20Civil religion: Pledge of Allegiance U.S. Currency Oath of Office Oath in CourtScientology Aliens dropped into volcanoes in hawaii other religions are also crazy/all over the place hinduism, rebirth it will eventually become
Texas San Antonio - CHEM - 1122
Lab Final85-90% multiple choicemaybe some short answer2 hours!21 questions7 mathReview:hyrdate problemsnaming compounds p.61 from chemistry booklimiting reagent problembalance equation, convert all reactants to moles, use balanced equations, whi
Texas San Antonio - MAT - 1093
MAT 1093 Test 3 ReviewName_MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.Match the point in polar coordinates with either A, B, C, or D on the graph.1) 3,354BA321-5-4-3-2-112345
University of Texas - MS - 3053
First published in Exchange, the magazine of the Brigham Young University School of Business,the following twelve categories were developed to cover the root or cause of most ethicalbusiness dilemmas that one might encounter in their jobs. The following
University of Texas - SPN - 610
University of Texas - SPN - 610
University of Texas - SPN - 610
University of Texas - SPN - 610
University of Texas - SPN - 610
University of Texas - SPN - 610
University of Texas - SPN - 610
University of Texas - SPN - 610
University of Texas - ACC - 312
ACC 312 Fundamentals of Managerial AccountingMidterm Exam I, Spring 2012, Wednesday February 22nd 2012ACC 312 Fundamentals of Managerial AccountingMidterm Exam I, Spring 2012, Wednesday February 22nd 2012NameUTEID_InstructorClass Day_ TimeDO NOT
University of Texas - ACC - 312
University of Texas - ACC - 312
University of Texas - OM - 335
OM 335: Homework Assignment 11 SolutionsProblem 1:Home Depot is a large hardware store located in Long Beach Mall: The EverlastBinder, a special purpose glue is one of the items it sells. Each unit of EverlastBinder costs Home Depot \$10. There is an a
UCSD - BILD - 1
Problem Set A1. If you know that Boron has an atomic number of 5 and an atomic mass of 11, what doyou know about the number of protons, electrons, and neutrons in its atoms?2. What is special about the outer electron shell, and what can you predict fro
UCSD - BILD - 1
1.a) What are the components of a phospholipid?b) How does each component affect the hydrophilicity or hydrophobicity of themolecule?c) Draw a simple picture of a phospholipid bilayer and indicate where thehydrophilic and hydrophobic regions are loca
UCSD - BILD - 1
1. Describe the experiment which demonstrated that proteins within the plasma membraneare able to move freely within the bilayer.2.a) How do the conditions inside a lysosome differ from those in the cytosol?b) How does the function of this organelle i