CH7, P 235, Can you describe these three table? ( Especially third one) Formula

Question

CH7, P 235, Can you describe these three table? (

Especially third one)

Formula in cell C25 =CI6"SUMPR00UCT($a$18 $A$24.CI8:C24) Formula in cell D2S-I2 Copied from C25 (note the absolute addresses) Formula in cell A26 =SUMPRODUCT($A$l8:$A$24.H6:H12) Formula in cell A27 =SUM(C25:125)" 0.5 Formula in cell A2B =A26/A27 The Efficient frontier Spreadsheet Model for International Diversification Country Index Statistics and Forecasts or Risk Premiums The Bordered Covariance Matrix Cell A18 - A24 AI8 is set arbitrarily to 1 while A19 to A24 are setto 0 Formula in cell C16 =A18 ... Formula in cell |16 =A24 Formula in cell A25 =SUM(AI8:A24)

Explanation / Answer

Thanks for posting. These 3 three tables look like currency exchange rates. "covariance is a measure of how much two random variables change together" by Wikipedia What is it asking you to do?

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---