Compute time averages for every variable for each firm

Assignment Help Other Subject
Reference no: EM132724047 , Length: word count:1500

Statistics for Finance Project

Complete the tasks below:

Question 1. Using Capital IQ1, download data for at least 50 US firms for the period 2010-2019. Present a table of summary statistics for all the variables used in the project (including the components of Tobin's Q). Make sure to include: mean, standard deviation, min, max, 25% percentile, 50% percentile, 75% percentile, number of firms, number of firm-year observations. Note that it could be the case that a particular firm has data available for 10 years, whilst another firm has data available for, for example, only 5 years. As long as you have a minimum of 5 observations per firm this is ok. Label this table: Table1: Summary Statistics2 and include a legend at the end of the table that defines each variable; e.g. Price denotes Day Close Price; Equity denotes Total
Common Equity, etc.

Question 2. Firm size is measured as log(Total Assets). Performance is measured with Tobin's Q (total assets plus market value of equity less book value of equity divided by total assets; where market value of equity equals price per share times the total number of shares outstanding)3. Choose the largest and the smallest firm for which you have 10 years of data. Is average performance statistically different between these two firms? Answer yes or no and show two different ways in which you could reach this conclusion. Make sure to show all the details of your tests and present a table for each test. Label these tables: Table2A: Differences in Performance_1 and Table2B: Differences in Performance_2

Question 3. You will run a cross-sectional regression. Therefore, compute time averages for every variable for each firm. You will end up with 50 cross-sections. Run a simple regression analysis to assess whether larger firms are associated with better performance. Note that you should run this regression using 50 observations. Label this table: Table 3: Simple-regression

Question 4. Discuss whether the coefficient on size is statistically significant at the 5% level and interpret the coefficient.

Question 5. Is the beta estimator for size unbiased? Explain

Question 6. Using SIC codes add industry dummy variables to your regression. Label this table: Table 4: Industry controls.
Explain what these dummy variables are controlling for.

Question 7. Add the following variables to the regression (don't forget also to include the industry dummy variables):
a. a sensible explanatory variable of your choice (you may need to look at some academic papers to make a good choice and include references in Appendix 2)

b. A sensible dummy variable of your choice (you may need to look at some academic papers to make a good choice and include references in Appendix 2)

Include the table with results. Label this table: Table 5: Multiple Regression Model

Question 8. Discuss whether the variable chosen in 7a. above is statistically significant at the 5% level and interpret your result.

9. Discuss whether the variable chosen in 7 b. above is statistically significant at the 5% level and interpret your result. (50 words max).

Question 10. Using an F-test assess whether the industry dummies are jointly significant. Show the F-statistic, critical value and discuss your results (50 words max).

Question 11. Compare the coefficient of size in Table 2 vs that of Table 5. Explain why they are different (100 words max)

Question 12. Compare the R-square of Table 3 to that of Table 5. Which model is better? (100 words max)

Question 13. Your variable of interest is size. Even after running your multiple regression model, your model is likely to suffer from endogeneity. Give an example of an omitted variable that could lead to a positive bias and include a brief explanation. (100 words max)

Question 14. Suppose you add firm's average number of employees to the multiple regression model. Would you expect your main results to change? Explain. (100 words max)

Question 15. In Lecture 4 pg. 63 we used an example based on the binomial distribution to explain the Central Limit Theorem (CLT). Make up your own example and show that the CLT works (originality will be rewarded). Feel free to include graphs or figures if this adds value to your explanation. (200 words max)

Question 16. Using daily prices for 2019 for the largest of your 50 firms (you do not need to include this variable in the descriptive statistics or any of the questions above), what is the predicted price for January 1st 2020 based on the random walk model? Clearly show how you estimated this price and discuss whether this is a good prediction. (200 words max)

Attachment:- Statistics for Finance Project.rar

Reference no: EM132724047

Questions Cloud

Explain how dnp can be used to reduce weight : Dinitrophenol (DNP) was used in the manufacture of munitions in World War I. In the 1930s, it was used as a weight loss drug. Use in the U.S. cannot be regulate
What is meant by phenotype : 1) What is a character? Give 3 examples of characters that Mendel studied. Give 3 examples of human characters. What are traits?
Give examples of uncertainty in measurement : 1. Give examples of uncertainty in measurement. 2. What happens to field of view with increased magnification?
Describe the functions of endocrine system : Describe the Functions of Endocrine System, List selected Endocrine Organs of body and the chemicals (hormones) they produce.
Compute time averages for every variable for each firm : Discuss whether the coefficient on size is statistically significant at the 5% level and interpret the coefficient and Discuss whether the variable chosen
What is ecosystem diversity : What is species biodiversity? Discuss at least one reason why you think species diversity is important. What would happen if there were no species diversity?
Basic structural unit of compact bone tissue : What is the basic structural unit of compact bone tissue?
Questions about the nitrogen cycle : What is the reservoir for the nitrogen cycle? How does nitrogen move from the reservoir to the exchange pool?
Discuss the role of entomology in the movie : You are required to watch oneAntzBee Movie of the following movies:

Reviews

len2724047

12/8/2020 5:13:42 AM

Hi We want to collaborate for regular assignments if you deliver good quality work . Attaching task requirement Word count ; 1500 deliverables ; all the tables as mentioned in the brief should be of STATA, and STATA file along with the word document .

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd