GLOBAL INVESTMENTS

  Use Excel to do a regression of the inflation rate (X) on the percent changes in stock market indices (Y). Include the data from all eighteen countries, including Japan. Use a significance of .05. Interpret your results (R-square, regression coefficient, and p-value). How would inflation in a foreign country affect the value of foreign profits for a U.S. investor? Explain your answer.