Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer all questions fully and include all requested answern and output onto a single pdf , doc, or docx file. All written work for the
Answer all questions fully and include all requested answern and output onto a single pdf doc, or docx file. All written work for the report will need to be typed, and all requested plots need to be generated through R All plots need to be correctly labeled and easy to readunderstand In addition to the typed project, upload the source file used to perform all requested statisticul operations and the final cleaned dataset as a csv file. Failure to upload the R source file and the cleaned dataset will result in a substantial loss of points. Data for completing this project may be found under the "FilevProjectProject page on Canvas. Cleaning and Inspecting data: The file Stocks.csv contains data on the closing stock price on a single day for a larpe number of companies, For each company, the dataset provides the name Name stock market ticker symbol Symbol sector Sectot Mock price Price dividend as a percentage of stock price Dividend pricetocamings ratio PE earaings per share EPS book value in billions of dollars Book Value lowest and highest share price over the last weeks week low and weck high market value of the company's shares in billions of dollars Market Cap and earnings before interest, taxes, depreciation, and amortization in billions of dollars EBITDA Data Cleaning: apts How many companies are included in the Stocks.csy dataset? bpts How many missing values are there for each variable? Hox many incomplete observations are there? cpts Clean up the missing data by cither remewing all incomplete observations or by imputing values for the missing data. Which opeion did you choose? Why? dpts Add a column to this dataset obtained by taking the log base of the beok value. cpts Add a column to this dataset obtained by taking the log base of the market cap. fpts Add a columa to this dataset obtained by taking the log hase of the EBITDA. gpts Create a variable that is if the company has a pricetoearnings ratio greater than and is otherwise. Add this variable as a column ia the dataset. Hint: The felse function can do this fairly easily. Try looking at the help tile to see how to do this.bpts Replace the rd entry of the Name variable with your full name. ipts Save this cleaned dataset as a csv file.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started