College Name: Shaheed Sukhdev College of Business Studies
Unique Paper Code: 61013341
Exam: Practical Examination
Name of the Paper: Financial Database & Analysis Software
Name of the Course: BBA(FIA)
Semester: III
Duration: 2 hours
Max marks: 25
Additional time for scanning and mailing the document: 30 minutes
Instructions for the candidates:
1. Students are required to submit the scanned copy (in pdf/jpg only) of the solved assignment
via reply mail only to the email used (fdas.sem3bbafia@sscbsdu.ac.in) for sending the
question paper in a stipulated time period (Don’t compose a new mail, only send via reply on
the same thread). Assignment submitted as a separate email to same email-id/another email-id
will not be accepted, and will be treated as “Assignment not submitted”.
2. Ruled Sheet/Register page/plain A4 sheet may be used to solve the assignment.
3. Each page should be numbered in a sequence.
4. At the top of the first page of the answer sheet you are required to write the following
information:
a. Examination roll number
b. Name of the student
c. Name of the Course
d. Name of the Subject
e. Unique paper code
f. Semester
5. Please ensure that the scanned copy of assignment you are submitting should be readable
and clear.
6. Attempt all questions.
7. All questions carry equal marks.
Set 1
Q 1. Create a data frame with the title “employee” which includes name of employee, height
of the employee in inches, employee code and gender of the employee. You are required to fill
random data of 20 students under different variables of employee data set. You are also required
to do the following:
a. Calculate mean, median & standard deviation of height of the employee in inches of the male
employee using ‘Aggregate’ function.
b. Add a new variable “weight of employee” to the data frame.
Q 2. Answer the questions on the basis of the data given below
Employee Name Department Salary Age Designation Gender
D Marketing 62000 55 Employee M
P Marketing 100000 30 Manager M
T Finance 90000 35 Manager F
H Finance 45000 45 Manager M
J Operations 50000 55 Employee F
B Legal 40000 35 Employee M
N Finance 135000 42 Manager F
A Finance 100000 37 Manager M
V Distribution 92000 35 Manager F
(i) Create vectors of the given variables in the above table.
(ii) Write a program to create a data frame on the basis of the information given above and
label the names of the columns.
(iii) Create two separate files on the basis of the field gender.
(iv) Access 3th row and 2rd column and also make a list of the above information.
(v) Extract those records where the salary is less than equal to 100000.
(vi) Display the composition of the above information.
Q 3. A dataset with the name of ‘cars’ is attached with this mail. With regard to this dataset
(‘cars’), perform the following:
(a) First save the dataset ‘cars’ in your working directory. Then, write a command to read ‘cars’
dataset in your workspace in R. Store the dataset as ‘mydata’
(b) Write a command to develop a regression model treating ‘mpg’ as the dependent variable
and, ‘cubicinches’, ‘hp’ and ‘weightlbs’ and as independent variables
(c) Extract coefficients, p-values and adjusted R-square values from the summary of the model.
Interpret these values
(d) Write the regression equation. Predict the value of ‘mpg’ using the ‘predict’ function for
cubicinches = 300, hp = 170 and weightlbs = 3500 (write code as well as predicted value)
(e) Determine the ‘vif’ (variance inflation factor; ‘car’ package) for the variables of the
regression model. Comment on the occurrence of multicollinearity
Q 4. Consider the following data
Sample a Sample b
1 -0.66
-0.31 -0.65
-0.74 -0.64
0.77 -0.6
0.21 -0.43
-0.9 -0.42
0.38 -0.41
0.63 -0.36
-0.77 -0.05
-0.12 0
0.82 0.03
-0.4 0.08
-0.55 0.32
0.73 0.39
0.07 0.42
-0.76 0.43
0.4 0.63
0.48 0.64
-0.7 0.67
-0.03 0.7
(i) Detect whether there is a violation of stationarity in the above data sets. Perform an
appropriate test, interpret the output and write the hypotheses also.
(ii) Summarize the two samples using mean, median, standard deviation and inter quartile
range. Compare the two samples on the basis of these summarizations
(iv) Write code to make the histogram of two samples, Add name to the charts. Also, label
the horizontal and vertical axis suitably.
