Answered step by step
Verified Expert Solution
Link Copied!

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 read/understand. 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 "FilevProject/Project 1^11 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), price-to-camings ratio (PE), earaings per share (EPS), book value in billions of dollars (Book Value), lowest and highest share price over the last 52 weeks (52 week low and 52 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).1. Data Cleaning: (a)(2pts) How many companies are included in the Stocks.csy dataset? (b)(4pts) How many missing values are there for each variable? Hox many incomplete observations are there? (c)(8pts) 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? (d)(2pts) Add a column to this dataset obtained by taking the log base 10 of the beok value. (c)(2pts) Add a column to this dataset obtained by taking the log base 10 of the market cap. (f)(2pts) Add a columa to this dataset obtained by taking the log hase 10 of the EBITDA. (g)(4pts) Create a variable that is 1 if the company has a price-to-earnings ratio greater than 15 and is 0 otherwise. Add this variable as a column ia the dataset. (Hint: The 1felse() function can do this fairly easily. Try looking at the help tile to see how to do this.)(b)(3pts) Replace the 3rd entry of the Name variable with your full name. 1(i)(3pts) Save this cleaned dataset as a csv file.

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

Step: 3

blur-text-image

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

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions