Reference no: EM132457801
Assignment:
- 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:
Question 1: Create a summary of statistics for the dataset. (provide a screen shot)
Question 2: Create a correlation of statistics for the dataset. (provide a screen shot)
Question 3: What is the Min, Max, Median, and Mean of the Price? (provide a screen shot)
Question 4: What is the correlation values between Price, Ram, and Ads? (provide a screen shot)
Question 5: Create a subset of the dataset with only Price, CD, and Premium. (provide a screen shot)
Question 6: 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)
Question 7: What percentage of Premium computers were sold? (provide a screen shot)(Hint: Categorical analysis)
Question 8: How many Premium computers with CDs were sold? (provide a screen shot)(Hint: Contingency table analysis)
Question 9: How many Premium computers with CDs priced over $2000 were sold? (provide a screen shot)(Hint: Conditional table analysis)