Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For ALL Questions in this exercise, please use the North American Stock Market 1994-2018 dataset. Please load the data into a data frame called companies

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

For ALL Questions in this exercise, please use the North American Stock Market 1994-2018 dataset. Please load the data into a data frame called companies by reading the appropriate.rds file. See lecture slides to see how to do this. Make sure to run the code library(tidyverse) so you load tidyverse. For each fiscal year (fyear), you want to calculate the median value of assets (at) for all companies recorded in that fyear. Make the assumption that each company is listed only once per year. Which fyear had the highest median at? 2001 O 2009 O 2011 2018 O None of the above. Suppose you want to create a new dataset. To create this new dataset, start with the usual companies dataset. Then, for each firm, drop all observations (of that firm) if the firm has never reached $100 million in total assets (i.e., at) at any time in the dataset. Note that assets is listed in millions, so $100 million would be 100. To elaborate, let's consider the following hypothetical case: Suppose there are 6 observations for company ABC. If at least one of these 6 observations has at >= 100, you must NOT drop ANY of the observations for firm ABC. How many observations (i.e., rows) are in the new dataset after dropping observations indicated above? Hint: Each company is uniquely identified by its gvkey, and each row is uniquely identified by the combination of gvkey and fyear. O 9,003 O 144,655 O 163,777 O 177,391 O None of the above. Now, start with the full companies dataset again. Suppose you want to drop any observation (i.e., any row) that has less than $100 million in total assets (at

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Theory Practice And Techniques In Bookkeeping Accounting And Auditing

Authors: N/A,

1st Edition

1680947761, 978-1680947762

More Books

Students also viewed these Accounting questions

Question

Persuasive Speaking Organizing Patterns in Persuasive Speaking?

Answered: 1 week ago