Assignment: Use RStudio to generate a word document with basic data analysis of the following dataset: dataset_price_personal_computers.csv (attached a file) Use the following video to learn the si

Assignment:

Use RStudio to generate a word document with basic data analysis of the following dataset:  dataset_price_personal_computers.csv (attached a file)

Use the following video to learn the simple commands to conduct basic data analysis with RStudio:  Basic Data Analysis in RStudio.mp4(https://s3.us-east-1.amazonaws.com/blackboard.learn.xythos.prod/5a31b16bb2c48/3149183?response-content-disposition=inline%3B%20filename%2A%3DUTF-8%27%27Basic%2520Data%2520Analysis%2520in%2520RStudio.mp4&response-content-type=video%2Fmp4&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200128T142000Z&X-Amz-SignedHeaders=host&X-Amz-Expires=21600&X-Amz-Credential=AKIAIL7WQYDOOHAZJGWQ%2F20200128%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=2c3fc368a7f7f72fee12e47c56982dd354312f255de5d47c803adf40282d34a0)

Questions/Requests:

Create a summary of stats for the dataset. (provide a screen shot)

Create a correlation of stats for the dataset. (provide a screen shot) (Hint: Transform may be needed)

What is the Min, Max, Median, and Mean of the Price? (provide a screen shot)

What is the correlation values between Price, Ram, and Ads? (provide a screen shot)

Create a subset of the dataset with only Price, CD, and Premium. (provide a screen shot)

Create a subset of the dataset with only Price, HD, and Ram where Price is greater than or equal to $1750. (provide a screen shot)

What percentage of Premium computers were sold? (provide a screen shot)(Hint: Categorical analysis)

How many Premium computers with CDs were sold? (provide a screen shot)(Hint: Contingency table analysis)

How many Premium computers with CDs priced over $2000 were sold? (provide a screen shot)(Hint: Conditional table analysis)

Your document should be an easy-to-read font in MS Word (other word processors are fine to use but save it in MS Word format). Your cover page should contain the following: Title, Student’s name, University’s name, Course name, Course number, Professor’s name, and Date.