data analysis and viz

• Use the tool of your choice (RStudio, Excel, Python) to generate a word document with basic data analysis of the data set posted in the Week 2 content folder.
• Create a Word document that includes the screen shots described below.

Questions/Requests:

• Create a summary of statistics for the dataset. (provide a screen shot)
• Create a correlation of statistics for the dataset. (provide a screen shot) 
• 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. Your cover page should contain the following: Title, Student’s name, University’s name, Course name, Course number, Professor’s name, and Date.