GUJARAT TECHNOLOGICAL UNIVERSITY

ATMIYA INSTITUTE OF TECHNOLOGY AND SCIENCE, RAJKOT

M.C.A. SEM. IV Practical Examination

Subject: Data Analytics with R

Date: 18/03/2017                                                                      MAX. MARKS: 30

Q.1	Perform following : 1) Define the following vector with rep function. 1 1 1 2 2 2 3 3 3 4 4 4 2) Use the function paste to create the following character vectors of length 30: (a) ("label 1", "label 2", ....., "label 30"). Note that there is a single space between label and the number following. 3) Create the following matrix B with 5 rows: B = 10 -10 10 10 -10 10 10 -10 10 Find the cross product of the matrix and make diagonal element zero. 4) check class of the "1L / 100" . create a vector 1 2 NA 4 NA, and display vector without NA. and sort these vector in descending order. 5)  define new binary operator which return the multiplication of two numbers.	10
Q.2	Perform following queries using product_master and sales_order_details table: 1)    Find out the products with cost_price more than 100 and less than 600 and sell_price is more than 500. 2)    Find out the product with minimum selling price and maximum selling price. 3)    Find out first 6 records of sales order table. 4)    Display all the rows of table sales_order except column qty_disp and product_name should be starting with “D” . 5)    Display sum of qty_ordered for each product from sales_order.	10
Q.3	Read “Duncan.csv” and generate a following charts 1)    Simple Boxplot of type vs. income Give a notch in boxplot Provide colors to boxplot Provide “Income” as label to x axis. 2)    Generate scatter plot matrix of income and prestige Generate scatter plot matrix of income, education and prestige Set solid pointing character and make it 1.5 larger.	2 1 1 1        1 2 2

***** All the Best *****