What is the correlation values between price-ram and ads

Assignment Help Database Management System
Reference no: EM131840407

Assignment

Background: This course is all about data visualization. However, we must first have some understand about 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 screen shot)
• Create a correlation of stats for the dataset. (provide a screen shot) (Hint: Transform may be needed)
• 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 (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.

Reference no: EM131840407

Questions Cloud

Different lines of business with different risks : Consider a firm with two equally sized divisions (in terms of their value) that engage in completely different lines of business with different risks.
What would the entry be using US GAAP : The other bank account had a balance greater than 500,000. Kramer recorded the 100,000 overdraft as a liability. What would the entry be using US GAAP
What coupon rate should the company set : BDJ Co. wants to issue new 25-year bonds for some muchneeded expansion projects. The company currently has 5.6 percent coupon bonds
How does this change influence the price of the product : How does this change influence the price of the product in British pounds?
What is the correlation values between price-ram and ads : What is the correlation values between Price, Ram, and Ads? What percentage of Premium computers were sold?
Compare and contrast the various investment : Compare and contrast the various investment products that are available and the types of institutions that sell them.
What is the price of right : The firm currently has 2 million common shares outstanding, each priced at $25 in the market. What is the price of each right?
Evaluate a sample for testing inventory : What is your opinion of the method of selecting his sample? Provide recommendations to the CPA about how to select and evaluate a sample for testing inventory
Describe two common security threats against wired devices : Describe at least two common security threats against wired and wireless devices and typical countermeasures used by corporate security teams.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd