solve the problem by using the template in the excel file provided and use population formulas provided in the files

profiledabf94
patemp-9.xls
Home>Business & Finance homework help>solve the problem by using the template in the excel file provided and use population formulas provided in the files

Sheet1

Name Weight A = 0.3 Weight M = 0.7
Prob A M
0.3 20 16
0.4 18 10
0.3 10 14
Expected Return A = 16.20 Note: All formulas must be completely cell referenced
Expected Return M = 13.00
Standard Deviation A = 4.1424630354
etc for the rest of the computations

Sheet2

Sheet3