Create a correlation of statistics for the dataset


Homework: Data Analysis

1) Create a summary of statistics for the dataset. (provide a screenshot)

2) Create a correlation of statistics for the dataset. (provide a screenshot)

3) What is the Min, Max, Median, and Mean of the Price? (provide a screenshot)

4) What is the correlation values between Price, Ram, and Ads? (provide a screenshot)

5) Create a subset of the dataset with only Price, CD, and Premium. (provide a screenshot)

6) Create a subset of the dataset with the only Price, HD, and Ram where Price is greater than or equal to $1750. (provide a screenshot)

7) What percentage of Premium computers were sold? (provide a screenshot) (Hint: Categorical analysis)

8) How many Premium computers with CDs were sold? (provide a screenshot) (Hint: Contingency table analysis)

9) How many Premium computers with CDs priced over $2000 were sold? (provide a screenshot)(Hint: Conditional table analysis).

Format your homework according to the following formatting requirements:

(1) The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.

(2) 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.

(3) Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Create a correlation of statistics for the dataset
Reference No:- TGS03033419

Expected delivery within 24 Hours