Use the data in the worksheet of the spreadsheet Chapter 04 Questions.xls and the Excel spreadsheet developed in the JamesStein estimator outbox to

a. Calculate estimates for the countries listed.

b. Repeat estimating the James Stein estimators to get JS estimates excluding Argentina and Brazil. [In cells B3, B4, and B6, change the range from B12:Y12 to D12:Y12.]

c. Compare the data, statistics, and results for Argentina and Brazil with those of the other countries. What is different about these two countries? What do you know about them that might explain this difference? Assuming you need to include these two countries, what might you do to ensure that they do not skew the JS results for the other markets?

d. Using Excels chart wizard, create a chart that shows the JS estimate of alphas with and without Argentina and Brazil for each market along with its sample mean.