Basic Data Analysis in RStudio
Background: This course is all about data visualization. However, we must first have some understanding of the dataset that we are using to create the visualizations.
Assignment:
- Use RStudio to generate a word document with basic data analysis of the following dataset: dataset_price_personal_computers.csv
- Use the following video to learn the simple commands to conduct basic data analysis with RStudio: Basic Data Analysis in RStudio.mp4
Questions/Requests:
- Create a summary of stats for the dataset. (provide a screenshot)
- Create a correlation of stats for the dataset. (provide a screenshot) (Hint: Transform may be needed)
- What is the Min, Max, Median, and Mean of the Price? (provide a screenshot)
- What is the correlation values between Price, Ram, and Ads? (provide a screenshot)
- Create a subset of the dataset with only Price, CD, and Premium. (provide a screenshot)
- Create a subset of the dataset with only Price, HD, and Ram where Price is greater than or equal to $1750. (provide a screenshot)
- What percentage of Premium computers were sold? (provide a screenshot)(Hint: Categorical analysis)
- How many Premium computers with CDs were sold? (provide a screenshot)(Hint: Contingency table analysis)
- How many Premium computers with CDs priced over $2000 were sold? (provide a screenshot)(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.
Submit your assignment on or before the due date.
URL to class Basic Data Analysis in RStudio:
https://s3.amazonaws.com/blackboard.learn.xythos.prod/5a31b16bb2c48/3149183?response-cache-control=private%2C%20max-age%3D21600&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=20200904T150000Z&X-Amz-SignedHeaders=host&X-Amz-Expires=21600&X-Amz-Credential=AKIAYDKQORRYTKBSBE4S%2F20200904%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=8ccc495069ce1f31f88c61d6cec5235b4bf5a4b623989010dfef45bc1c42b18d