Reference no: EM132426131
1. Inclass,we learned that we can assess the impact of a macro indicator by running a regression of the appropriate measure of stock market returns on the appropriate measure of the surprise contained in the announcement of the macroindicator.
a. Using the posted spreadsheet, how exactly would you measure a surprise in nonfarm payrolls? Please state your answer by copying and pasting the corresponding Excel formula with cell references below.
b. Using the posted spreadsheet, how exactly would you measure the stock return associated with the nonfarm payroll announcement? Please state your answer by copying and pasting the corresponding Excel formula with cell references below.
2. Using your answer to question 1, estimate a regression of announcement returns on nonfarm payroll surprises. Copy and paste the regression statistics below. Based on your results, are nonfarm payroll surprises a statistically significant determinant of stock market returns?
How does the economic magnitude of their effect compare to that of ISM surprises (put differently, which macro indicator has been a more powerful driver of stock returns during the past 3 years.
Attachment:- Spread sheet.rar