Homework: Data Analysis and Visualization
a) 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 content folder.
b) Create a Word document that includes the screen shots described below.
Questions/Requests:
I. Create a summary of statistics for the dataset. (provide a screen shot)
II. Create a correlation of statistics for the dataset. (provide a screen shot)
III. What is the Min, Max, Median, and Mean of the Price? (provide a screen shot)
IV. What is the correlation values between Price, Ram, and Ads? (provide a screen shot)
V. Create a subset of the dataset with only Price, CD, and Premium. (provide a screen shot)
VI. 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)
VII. What percentage of Premium computers were sold? (provide a screen shot)(Hint: Categorical analysis)
VIII. How many Premium computers with CDs were sold? (provide a screen shot)(Hint: Contingency table analysis)
IX. How many Premium computers with CDs priced over $2000 were sold? (provide a screen shot)(Hint: Conditional table analysis)
Format your homework according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
Attachment:- Working-with-Data.rar