1. Correlation between each the change in unit’s cash flows and the change in the euro

2. Correlation between the change in the firm’s total cash flows and the change in the euro

3. Estimate using the regression function of the Data ToolPak the relationship between changes in each unit’s cash flows and the firm’s total cash flows and the change in the euro exchange rate

 

Quarter 1 2 3 4 5 6 7 8 9 10 11 12 % Change in Unit A's Cash Flows -4 5 5350L -3 -5 -5 -2 -1 -3 3 1 -3 % Change in Unit B's Cash Flows -4 -1 -4 -4 2 4 3412 % Change in Unit C's Cash Flows 0 1 5 4 1 -2 2 5 3 -5 -4 -1 % Change in Total Cash % Change in Value of the Flows] cruo -4 LASGA NG N N wob 0 3 2 -2 -5 -2 4 -2 -5 -1 -1 0 1 NSSING LG -- 1 -4 -5 -4 -5 2 5 5 2