The impact of macro indicator by running regression

Assignment Help Financial Management

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

Reference no: EM132426131

Questions Cloud

How does inflation solve the horizon problem : What is cosmic inflation: How does inflation solve the horizon problem? The flatness problem?

Define conceptualization and operationalization : A police chief has hired you to conduct an applied research study on police officers' attitudes and perceptions in a particular jurisdiction.

What were economist major contribution to school of economic : What school of thought the economist belonged to, what theories the economist created or advanced, what were the economist major contributions to the school

Gender differences in communication styles : Based on your readings and personal experience are there gender differences in communication styles? Provide real-life examples.

The impact of macro indicator by running regression : 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

What devices might not be allowed in certain facilities : Some organizations prohibit workers from bringing certain kinds of devices into the workplace, such as cameras, cell phones, and USB drives.

Discuss about companies that have been harmed by a disaster : Choose one such company and create a brief case study about it. Successful narratives will focus on the manner in which the organization was impacted.

Describe the six components of the CAMELS rating system : Describe the six components of the CAMELS rating system. Explain the following commercial bank balance sheet items.

Establish for advertising and promotion : Analyze what specific objectives you as a marketer would establish for advertising and promotion. Determine what criteria would need to be met

User Account

All Pages