Correlation and Regression analysis

Bouvier co. is a Canadian company that sells forestry products to several Pacific rim customers. bouviers sales are very sensitive to exchange rates. The following table shows recent annual sales (in millions of Canadian dollars) and the average exchange rate for the year (expressed as the units of foreign currency needed to buy one Canadian dollar).

a. Calculate the sample mean and standard deviation for X (the exchange rate) and Y (sales).

b. Calculate the sample covariance between the exchange rate and sales.

c. Calculate the sample correlation between the exchange rate and sales.

d. Calculate the intercept and coefficient for an estimated linear regression with the exchange rate as the independent variable and sales as the dependent variable.

e. Calculate the standard error of estimate (SEE).

f. Calculate the coefficient of determination (R2).