De La Salle University – Dasmariñas
COLLEGE OF SCIENCE AND COMPUTER STUDIES
MATHEMATICS AND STATISTICS DEPARTMENT
City of Dasmariñas, Cavite
SMATH001LA – Data Analytics for Engineering
2nd Semester / Midterm Period / S.Y. 2022-2023
LABORATORY ACTIVITY #1
Descriptive Statistics for Qualitative Data
NAME: Earl Benedict M. Rañola DATE: September 9 2024
Score:
COURSE/YEAR & SECTION: BSA11 PROF.: ____________________
OBJECTIVES:
1. Create a pivot table and data visualization in Microsoft Excel.
2. Clearly organize and compute detailed information about the three data sets.
3. Graph and calculate several descriptive measures of the data set using a variety of
methods
Data Set 1: Categorical Data
The class levels of a simple random sample of students are as follow: Senior
Senior Senior Freshman Junior Senior Senior Sophomore
Junior Junior Senior Senior Freshman Senior Senior
Senior Sophomore Sophomore Sophomore Sophomore Senior Sophomore
Junior Junior Senior Senior Freshman Senior Senior
Senior Senior Freshman Junior Senior Senior Sophomore
Junior Junior Senior Senior Freshman Senior Senior
Senior Sophomore Sophomore Sophomore Sophomore Senior Sophomore
Junior Junior Senior Senior Freshman Senior
Tasks: (10-point each)
a. Construct a table that gives the frequency distribution of this data. Interpret the result.
Frequenc
Students y
Freshman 6
Junior 10
Senior 27
Sophomo
re 12
Grand
Total 55
Interpretation: Out of the 55 students who responded to the survey, the majority are
Seniors, with a frequency of 27. This is followed by Sophomores, who account for 12
responses, Juniors with 10, and finally, Freshmen with 6.
Frequenc Percent
b. Construct a table that Students y age gives the relative frequency
distribution of this Freshman 6 10.91% data. Interpret the result.
Junior 10 18.18%
Senior 27 49.09%
Sophomo
re 12 21.82%
Grand 100.00
Total 55 %
Interpretation: Out of the 55 students who responded to the survey, the majority are
Seniors, making up 49.09% (27 students). This is followed by Sophomores at 21.82% (12
students), Juniors at 18.18% (10 students), and finally, Freshmen at 10.91% (6 students).
c. Construct a pie chart of this data that displays the percentage of students at each class
level. Interpret the result.
Frequency
11%
22%
Freshman
Junior
18% Senior
Sophomore
49%
Interpretation: The pie chart shows that out of the 55 survey respondents, Seniors make
up the largest portion at 49%. Sophomores represent 22% of the total, while Juniors
account for 18%. Freshmen form the smallest segment, comprising 11% of the student
population.
d. Construct a bar graph of this data that displays the frequency of students at each class
level. Interpret the result.
Total
30
25
20
Total
15
10
0
Freshman Junior Senior Sophomore
Interpretation: The bar graph shows that Seniors have the highest frequency among the
55 survey respondents, with 27 students. Sophomores follow with 12 students, while
Juniors account for 10. Freshmen have the lowest frequency, with 6 students.
Data Set 2: Categorical Data
The preferred mode of learning of a simple random sample of students are as follow:
Online modular face-to-face blended
Online Online Online face-to-face
face-to-face face-to-face face-to-face blended
blended blended modular modular
modular modular Online blended
blended Online Online face-to-face
face-to-face face-to-face face-to-face face-to-face
Tasks: (10-point each)
a. Construct a table that gives the frequency distribution of this data. Interpret the result.
Mode of Freque
Learning ncy
blended 6
face-to-face 10
modular 5
Online 6
Grand Total 27
Interpretation: The frequency distribution shows that, among the 27 respondents, the
most preferred mode of learning is face-to-face, with a frequency of 10 students. Blended
and online learning share equal popularity, with 6 students each opting for these modes.
The least preferred mode is modular learning, with a frequency of 5 students.
b. Construct a table that gives the relative frequency distribution of this data. Interpret the
result.
Mode of Freque Percent
Learning ncy age
blended 6 22.22%
face-to-face 10 37.04%
modular 5 18.52%
Online 6 22.22%
100.00
Grand Total 27 %
Interpretation: The relative frequency distribution indicates that 37.04% of students
prefer face-to-face learning, making it the most preferred mode. Blended and online
learning are tied, with each being chosen by 22.22% of the students. Modular learning is
the least preferred, with 18.52% opting for this method.
c. Construct a pie chart of this data that displays the percentage of students at each class
level. Interpret the result.
Frequency
22% 22%
blended
face-to-face
modular
Online
19%
37%
Interpretation: representing 37.04% of the responses. Blended learning and online learning
are equally preferred, each accounting for 22.22%. Modular learning is the least favored
mode, comprising 18.52% of the total. This distribution highlights a strong preference for
traditional face-to-face learning, with a notable interest in blended and online options, while
modular learning is less commonly chosen.
d. Construct a bar graph of this data that displays the frequency of students at each class
level. Interpret the result.
Total
10
9
8
7
6 Total
5
4
3
2
1
0
blended face-to-face modular Online
Interpretation: The bar graph shows that among the 27 respondents, face-to-face
learning is the most frequently chosen mode, with 10 students preferring it. Both blended
and online learning are equally popular, with 6 students each opting for these methods.
Modular learning has the lowest frequency, with 5 students selecting it.
