1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER- IV EXAMINATION SUMMER 2017
Subject Code:3640005 Date:06/06/2017
Subject Name: Data Analytics with R
Time: 10:30 A.M. 01:00 P.M. Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1

Do as directed:
1. Give the difference between and
2. .result_1 is valid variable name? Explain.
3. Give output for the following code in R.
v LETTERS[1:4]
for i in
print(i)

4. Give the use of operator in R.
5. Give the function name to delete a variable in R.
6. How to sort character vectors in reverse order?
7. Give the difference between Barchart and Histogram.
07

What is Data Analytics? Explain classification of Data with example.
07
Q.2

What is Give features of R.
ii) Give the syntax to create a vector in R. Explain the concept of vector recycling with example.
03
04

What is list? Create a list which contains one vector having 5 numbers and one matrix of size 2x3. Give names to the list elements "Vector" and "Matrix". Print the list. Convert list to vector.
07
OR

Explain array( and apply( function with example.
07
Q.3

Explain UDF in R. Also explain the concept of default argument. Create UDF to print square from 1 to n (pass n as an argument).
07

Write R script to connect MySQL Database in R.
a. Create a connection object for the database named Test.
b. Insert 5 records in table named Employee name, salary).
c. Fetch all the records of Employee table in R.
d. Drop Employee table.
07
OR
Q.3

Explain pie( function with all parameters. Explain legend of chart with example.
P.T.O.
07
2

Write R script to create data frame "student" with the fields of stud_id, stud_name, email_id and mobile_no. Perform following operations:
a. Display data of data frame
b. Display summary of data frame
c. Display structure of data frame
d. Extract and display only stud_name and mobile_no from data frame
07
Q.4

What is Linear Regression? Give steps to establish a Linear Regression in R. Explain lm( function with example.
07

What is a Decision Tree? How does it work? Explain ctree( function of party package with example.
07
OR
Q.4

What is Normal Distribution? Explain following function used in R for Normal distribution.
dnorm(
ii) pnorm(
iii) qnorm(
iv) rnorm(
07

What is Logistic Regression? Explain glm( function.
ii) What is Survival Analysis? Give syntax of Surv and survfit( function.
03
04
Q.5

Write a short note on Applications of Data Analytics.
07

What is Prescriptive Analytics? Explain data creation for analytics through active learning.
07
OR
Q.5

Read the csv file named input.csv name, salary, dept) into R. Print number of rows and columns of file. Write records of IT department in it_dept.csv
07

What is Prescriptive Analytics? Explain data creation for analytics through designed experiments.
07