• Home
  • Blog
  • I want the assignment completed as per instructions below and added excel file for reference

I want the assignment completed as per instructions below and added excel file for reference

0 comments

Background: This course is all about data visualization. However, we must first have some understanding about the dataset that we are using to create the visualizations.

Assignment:

  • Use R/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 R/RStudio Part 1: As per attached below.
  • Use the following video to learn the simple commands to conduct basic data analysis with R/RStudio Part 2: As per attached below.

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.

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}