efficient portfolio

Individual efficient portfolio design
Each student is required to design an efficient portfolio frontier consisting of at least four companies (each from a different S &P 500 sector) using historical annual return data over the last fifteen years.  A brief discussion of why the student selected the specific sectors and a specific company within that sector must be included in the assignment.  Chapter 8 of Ragsdale shows a step by step approach for building  the  portfolio  and  drawing  the  efficient  frontier  diagram  using  Excel  Solver. 

Please  get 15 years data from YAHOO finance