Question: Question/answer needed is bolded below 1. In class, we learned that we can assess the impact of a macro indicator by running a regression of

Question/answer needed is bolded below

1. In class, 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 macro indicator

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.

Question/answer needed is bolded below 1. In class, we learned that we

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)?

.0 K 0 0 0 0 0 0 0 0 0 K 0 0 0 0 0 K 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 K 0 0005 .O 0 5 0 0 0 0 0 0 0 0 0 K 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68525 74 3 5 5 8 8 5 80 7 8 8 5 1 9 95 al-K OK K KKKKKKKKKKKK OK OK OK OK KKKKKKKKKKKK OK OK K OK OK igh Act 8 2 5 5 5 6 8 6 2 3 9 2 1 2 2 1 33 2 2 4 2 3 1 1 2 2 1 2 1 2 1 3 04 20 6 3 try-uuuuuuuuuuuuuuuu_uuuuuuuuuuuuuuuuuuuu 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 8 6 Dat-03 08. 05 02 07 04 02 06 03 10-07 05 02 07 04 01 06 03. 08, 05 02 09 06. 04. 01 06 03 07 05 02 07 04 01 08 05 03 3 4 5 6 78 9 01234567890 22 3333333333-4 0123 4 5 6 7 9 0 1 23456789 1 2 .0 K 0 0 0 0 0 0 0 0 0 K 0 0 0 0 0 K 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 K 0 0005 .O 0 5 0 0 0 0 0 0 0 0 0 K 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68525 74 3 5 5 8 8 5 80 7 8 8 5 1 9 95 al-K OK K KKKKKKKKKKKK OK OK OK OK KKKKKKKKKKKK OK OK K OK OK igh Act 8 2 5 5 5 6 8 6 2 3 9 2 1 2 2 1 33 2 2 4 2 3 1 1 2 2 1 2 1 2 1 3 04 20 6 3 try-uuuuuuuuuuuuuuuu_uuuuuuuuuuuuuuuuuuuu 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 08 8 6 Dat-03 08. 05 02 07 04 02 06 03 10-07 05 02 07 04 01 06 03. 08, 05 02 09 06. 04. 01 06 03 07 05 02 07 04 01 08 05 03 3 4 5 6 78 9 01234567890 22 3333333333-4 0123 4 5 6 7 9 0 1 23456789 1 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

1. In class, 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...

In class, 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...

1. In class, we learned that we could access 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...

summarize the main idea of each article, discuss issues being highlighted briefly, give opinion pertaining the coverage of each article and provide recommendations for each issue in the article....

1. Suppose you had $10,000 to invest in a taxable account with a long investment horizon (20 years or longer) and wanted your investment to mirror the performance of the S&P 500. Suppose you are...

London School of Science & Technology Qualification Unit number and title BTEC Level 5 HND Diploma Business UNIT 6: Business Decision Making Student name and ID number Assessor name Al Hassan Barrie...

Hi, I am doing a project for derivatives class and I have some questions about a regression and Monte Carlo simulation that I need to come up with. So the goal is to hedge against CDS instruments by...

Corporate Resilience and Response to COVID-19 by Alex Cheema-Fox, Bridget R. LaPerla, and Hul (Stacie) Wang, State Street Associates; and George Serafeim, Harvard Business School he coronavirus...

What kinds of property are covered by floater policies?

Explain how a stock's historical standard deviation of returns is conceptualized as a measure of the stock's "total risk."

Which legislation supports the use of whistleblowers in identifying securities law violators? A . Dodd - Frank Act B . Sarbanes - Oxley Act C . Securities Act of 1 9 3 3 D . Foreign Corrupt Practices...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

2. Describe the major provisions of the Sherman and Clayton acts. What government entities are responsible for enforcing those laws? Are firms permitted to initiate antitrust suits on their own...

3. Contrast the outcomes of the Standard Oil and U.S. Steel cases. What was the main antitrust issue in the DuPont cellophane case? In what major way do the Microsoft and Standard Oil cases differ?...

4. Why might one administration interpret and enforce the antitrust laws more strictly than another? How might a change of administrations affect a major monopoly case in progress? LO21.2