L. D.
College of Engineering, Ahmedabad-15
Continuous Evaluation Test – March-April 2022
BE- Semester (VI) Branch: Computer Engineering Date: 04/04/2022
Marks: 70 Duration: 1.5 Hrs
Data Mining (3160714) Max. Marks: 20
[05] CO1L1 Q.1 [A] Illustrate the KDD process in details. [05] CO1L2
[05] CO1L1 [B] Explain the data mining architecture. [05] CO1L2
OR
[05] CO1L1 [B] Describe the major issues in data mining. [05] CO1L2
Q.2 [A] Suppose that the data for analysis includes the attribute
age. The age values for the data tuples are (in increasing order):
13, 15, 16, 16, 19, 20, 20, 21, 22, 22, 25, 25, 25, 25, 30, 33, 33, 35,
[05] CO1L3 35, 35, 35, 35, 36, 40, 45, 46, 52, 70. [05] CO1L4
(i) What is the mean of the data? What is the median?
(ii) What is the mode of the data? Comment on the data's modality (i.e., bimodal, trimodal, etc.).
(iii) What is the midrange of the data?
(iv) Can you find (roughly) the first quartile (Q1) and the third quartile (Q3) of the data?
(v) Give the five-number summary of the data.
OR
[A] Using the data for age 13, 15, 16, 16, 19, 20, 20, 21, 22, 22, 25,
25, 25, 30, 35, 35, 35, 35, 35, 36, 40, 45, 46, 52, 70. Answer the
[05] CO1L3 following: [05] CO1L3
(i) Use smoothing by bin means to smooth the data, using a bin depth of 3. Illustrate your steps.
Comment on the effect of this technique for the given data.
(ii) How might you determine outliers in the data?
(iii) What other methods are there for data smoothing?
[B] In real-world data, tuples with missing values for some attributes
are a common occurrence. Describe various methods for handling
[03] CO1L3 this problem. [03] CO1L2
[C] Use the two methods below to normalize the following group of
[02] CO1L2 data: 200, 300, 400, 600, 1000 [02] CO1L2
i) min-max normalization by setting min = 0 and max = 1
ii) z-score normalization
Q.3 [A] Apply Apriori algorithm for generating large itemsets on the
[05] CO3L5 following data set: [05] CO3L5
Transaction ID Items Purchased
T1 1,3,4
T4 2,3,5
T10 1,2,3,5
T20 2,5
Page 1 of 2
L. D. College of Engineering, Ahmedabad-15
Continuous Evaluation Test – March-April 2022
BE- Semester (VI) Branch: Computer Engineering Date: 04/04/2022
Duration: 1.5 Hrs Data Mining (3160714) Max. Marks: 70
[05] CO1L3 Q.1 [A] Illustrate the KDD process in details. [05] CO1L3
[05] CO1L3 [B] Explain the data mining architecture. [05] CO1L3
OR
[05] CO1L3 [B] Describe the major issues in data mining. [05] CO1L3
Q.2 [A] Suppose that the data for analysis includes the attribute
age. The age values for the data tuples are (in increasing order):
13, 15, 16, 16, 19, 20, 20, 21, 22, 22, 25, 25, 25, 25, 30, 33, 33, 35,
[05] S3O1L4 35, 35, 35, 35, 36, 40, 45, 46, 52, 70. [05] S3O1L4
(i) What is the mean of the data? What is the median?
(ii) What is the mode of the data? Comment on the data's modality (i.e., bimodal, trimodal, etc.).
(iii) What is the midrange of the data?
(iv) Can you find (roughly) the first quartile (Q1) and the third quartile (Q3) of the data?
(v) Give the five-number summary of the data.
OR
[A] Using the data for age 13, 15, 16, 16, 19, 20, 20, 21, 22, 22, 25,
25, 25, 30, 35, 35, 35, 35, 35, 36, 40, 45, 46, 52, 70. Answer the
[05] S3O1L4 following: [05] S3O1L4
(i) Use smoothing by bin means to smooth the data, using a bin depth of 3. Illustrate your steps.
Comment on the effect of this technique for the given data.
(ii) How might you determine outliers in the data?
(iii) What other methods are there for data smoothing?
[B] In real-world data, tuples with missing values for some attributes
are a common occurrence. Describe various methods for handling
[03] S3O1L3 this problem. [03] S3O1L3
[C] Use the two methods below to normalize the following group of
[02] S3O1L2 data: 200, 300, 400, 600, 1000 [02] S3O1L2
i) min-max normalization by setting min = 0 and max = 1
ii) z-score normalization
Q.3 [A] Apply Apriori algorithm for generating large itemsets on the
[05] CO3L5 following data set: [05] CO3L5
Transaction ID Items Purchased
T1 1,3,4
T1 2,3,5
T10 1,2,3,5
T20 2,5
Page 1 of 2